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 Micro...

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 Micr...

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...

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 1...

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 ...

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 y...

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...

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 onli...

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 rol...