SQL Server Transactions and Locking (Part 1)
In many situations, data modification requires several steps. For example, you may need to change the values ??in two separate...
2013-05-22
610 reads
Basit's SQL Server Tips
Designing and Implementing Online Analytical Processing (OLAP) Architecture (Part 1)
The well-designed online analytical processing (OLAP) solution is fundamental to organizations analysis capabilities. That is why, when designing the OLAP...
2013-05-22
890 reads
SQL Server index related dynamic management views and functions (Part 3)
With the release of SQL Server 2005 and later releases, Microsoft introduced set of new dynamic management view and function...
2013-05-22
589 reads
Microsoft SQL Server 2012 Builds
The following table lists all builds of SQL Server 2012 known hotfixes, service packs and KB articles that have been...
2013-05-08
1,662 reads
Microsoft SQL Server 2008 R2 Builds
The following table lists all builds of SQL Server 2008 R2 known hotfixes, service packs and KB articles that have...
2013-05-08
21,308 reads
Microsoft SQL Server 2008 Builds (Last Updated May 20, 2013)
The following table lists all builds of SQL Server 2008 known hotfixes, service packs and KB articles that have been...
2013-05-08
1,334 reads
Microsoft SQL Server 2005 Builds
The following table lists all builds of SQL Server 2005 known hotfixes, service packs and KB articles that have been...
2013-05-08
2,628 reads
Microsoft SQL Server 2000 Builds
The following table lists all builds of SQL Server 2000 known hotfixes, service packs and KB articles that have been...
2013-05-08
2,369 reads
Microsoft SQL Server 7.0 Builds
The following table lists all builds of SQL Server 7.0 known hotfixes, service packs and KB articles that have been...
2013-05-08
1,169 reads
Find Duplicate Indexes on SQL Server (Script)
Like other mainstream commercial database systems, Microsoft SQL Server allows you to create multiple indexes on the same column of...
2013-05-07
1,215 reads
Blogs
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
BIT_COUNT() IV
Comments posted to this topic are about the item BIT_COUNT() IV
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers