Beware misleading data from SET STATISTICS IO
STATISTICS IO might not always tell the whole truth about data being read to process a query.
STATISTICS IO might not always tell the whole truth about data being read to process a query.
I follow up on an earlier post about trimming time from datetime, this time examining the performance characteristics of various methods without data access.
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...
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...
Tip : Script to create dynamic PIVOT queries in SQL Server
I show several reasons why you should stop using the sp_ prefix on stored procedures in SQL Server, including a performance hit.
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....
See if there is anything to gain by checking first if a particular column should be updated.