Beware misleading data from SET STATISTICS IO
STATISTICS IO might not always tell the whole truth about data being read to process a query.
Monthly Archive: October 2012
Trimming time from datetime – a follow-up
I follow up on an earlier post about trimming time from datetime, this time examining the performance characteristics of various methods without data access.
SQLSaturday #146 : Nashua, NH
Today was SQLSaturday #146, put on by Mike Walsh, Jack Corbett, and a host of other volunteers and organizers. Scott and I missed the speaker dinner last night, but we headed up from Rhode...
October 2012 Cumulative Updates are available – SQL Server 2008 R2 & SQL Server 2012
Microsoft released new cumulative updates for SQL Server; they announced them on their blog several hours ago. SQL Server 2012 RTM Cumulative Update # 4 KB Article: KB #2758687 25 fixes are listed at the...
Script to create dynamic PIVOT queries in SQL Server
Tip : Script to create dynamic PIVOT queries in SQL Server
Is the sp_ prefix still a no-no?
I show several reasons why you should stop using the sp_ prefix on stored procedures in SQL Server, including a performance hit.
MS12-070 : Security Updates for all supported versions of SQL Server
This week there was a security release for all supported versions of SQL Server. Each version has 32-bit and 64-bit patches, and each version has GDR (General Distribution Release) and QFE (Quick-Fix Engineering) patches....
Checking if a non-LOB column needs to be updated
See if there is anything to gain by checking first if a particular column should be updated.