Seeing Double
SQL Server allows some interesting index behavior and there's been some debate over whether it makes sense or not. This Friday Steve Jones asks if you have a reason for this.
Seeing Double
SQL Server allows some interesting index behavior and there's been some debate over whether it makes sense or not. This Friday Steve Jones asks if you have a reason for this.
Seeing Double
SQL Server allows some interesting index behavior and there's been some debate over whether it makes sense or not. This Friday Steve Jones asks if you have a reason for this.
UPSERT Functionality in SQL Server 2008
This article illustrates the functionality of UPSERT via the MERGE command in SQL Server 2008.
The April Energy Update
The bimonthly update on energy news from Steve Jones, focusing mostly this month on wind power.
Reading the SQL Server log files using T-SQL
One of the issues I have is that the SQL Server Error Log is quite large and it is not always easy to view the contents with the Log File Viewer. In a previous tip "Simple way to find errors in SQL Server error log" you discussed a method of searching the error log using VBScript. Are there any other easy ways to search and find errors in the error log files?
Same Report but Different Methods in SQL Server Reporting Services
In Reporting Services in SQL Server 2005 there are several ways of achieving the same result. This article introduces how we can create the same report using several different methods.
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