|
|
-
|
|
The following table lists all builds of SQL Server 7.0 known hotfixes, service packs and KB articles that have been released by Microsoft.
Quick Overview:
Codename
RTM
SP1
SP2
SP3
SP4
Codename Sphinx
7.00.623
7.00.699
7.00.842
7.00.961
7.00.1063
...
|
|
-
|
|
The following table lists all builds of SQL Server 2000 known hotfixes, service packs and KB articles that have been released by Microsoft.
Quick Overview:
Codename
RTM
SP1
SP2
SP3
SP4
Shiloh
8.00.194
8.00.384
8.00.532
8.00.760
8.00.2039
Microsof...
|
|
-
|
|
The following table lists all builds of SQL Server 2012 known hotfixes, service packs and KB articles that have been released by Microsoft.
Quick Overview:
Codename
RTM/Service Pack
Build Number
Denali
RTM
11.00.2100.60
SP1
11.00.3000
Microso...
|
|
-
|
|
The following table lists all builds of SQL Server 2005 known hotfixes, service packs and KB articles that have been released by Microsoft.
Quick Overview:
Codename
RTM/Service Pack
Build Number
Yukon
RTM
9.00.1399.06
SP1
9.00.2047
SP2
9.00.30...
|
|
-
|
|
The following table lists all builds of SQL Server 2008 known hotfixes, service packs and KB articles that have been released by Microsoft.
Quick Overview:
Codename
RTM/Service Pack
Build Number
Katmai
RTM
10.00.1600.22
SP1
10.00.2531
SP2
10.0...
|
|
-
|
|
The following table lists all builds of SQL Server 2008 R2 known hotfixes, service packs and KB articles that have been released by Microsoft.
Quick Overview:
Codename
RTM/Service Pack
Build Number
Kilimanjaro
RTM
10.50.1600.1
SP1
10.50.2500
S...
|
|
-
|
|
Like other mainstream commercial database systems, Microsoft SQL Server allows you to create multiple indexes on the same column of a table. This increases the likelihood of having duplicate indexes in the database because SQL Server does not prevent you ...
|
|
-
|
|
Checkout the sixth part of my XML support and SQL Server article series here.
In this part, you will learn about XML indexes (primary and secondary), and how they can effectively improve xQuery performance. You will also learn how you can manage the XML in...
|
|
-
|
|
Deadlocks are caused by poor database design, inappropriate isolation level, inefficient code etc.
Checkout my article (Tips for Minimizing Deadlocks) on SSWUG.org, in which I shared some tips that you can follow to minimize deadlocks in SQL Server online ...
|
|
-
|
|
The public role is a special fixed-database role, which exists in every SQL Server database. The public role is different from all other database-level roles because in SQL Server, every database user is automatically assigned to the public database role, ...
|
|