Creating a deep hierarchy with FOR XML
I have two tables in an application that I support. One is called [Report], and the other is [ReportParameter].
--SAMPLE...
2011-01-27
17,844 reads
Using the MERGE statement
I love MERGE. You know all those awful IF BEGIN END ELSE BEGIN END blocks you need to write for...
2011-01-17
4,055 reads
Wiring up a common click event handler in an ASP.NET page
I was just refactoring a server-side control and ran into some horrible code. Basicaly there was a big listbox that...
2010-12-30
3,099 reads
How to tell if a property exists by name
I recently was working on a library to manage reports in an application (probably a good candidate for an open source project)...
2010-12-29
663 reads
Blogs
Truncating very large transaction log in full recovery mode
By SQLPals
While I always configure transaction log backups for every database in non-simple recovery model,...
Autonomous Driving Around London
By Steve Jones
There’s a video of Bill Gates taking a drive in an autonomous car around...
Best way to monitor high worker thread on SQL Server
It is common to see high worker count issue on the production server and...
Forums
Significance of Historical waits report in SQL server Performance dashboard
I have the following historical wait report for my SQL server. I have noticed...
Has SQL Server Performance Improved?
Comments posted to this topic are about the item Has SQL Server Performance Improved?
Is TemporalTable SysStartTime available before performing an insert/Update?
I want to align a Date column (datetime2(7)) with the same full resolution date...
Ask SSC