Deciding between COALESCE and ISNULL in SQL Server
Tip : Deciding between COALESCE and ISNULL in SQL Server
Tip : Deciding between COALESCE and ISNULL in SQL Server
UPDATE 2020-01-28 – Microsoft has addressed my primary concern here in the SQL Server 2019 License Terms dialog: This is a great change, but I suspect a lot of people will still just check-check-next....
Tip : Minimize SQL Server plan cache bloat
Tonight I presented my "What's New in SQL Server 2012" deck to the folks up in Portsmouth, NH. The deck can be downloaded here. File Attachment: AB_NH_SQL2012.pptx.zip
This morning the SQL Server Release Services Team has pushed out new cumulative updates for SQL Server 2008 R2. Cumulative Update #13 for SQL Server 2008 R2 RTM Knowledge Base article: http://support.microsoft.com/kb/2679366 Build number:...
While I joked earlier this month that SQL Server 2012 Service Pack 1 was released on the same day as General Availability (hey, it's Microsoft's fault since they decided to GA on April 1),...
Tip : Storing E-mail addresses more efficiently in SQL Server – Part 2
This one time, I traveled over 18,000 miles and had 26 net time zone changes, all to give a couple of sessions.