Category: SQL Server

For the last part in my series on using a calendar table, and with some help from Itzik Ben-Gan, I describe how you can solve complex scheduling problems.

In this part of my "using a calendar table" series, I talk about filling gaps and identifying gaps and islands.

It seems a lifetime ago I wrote about creating a calendar table; now I've started a new series showing how to use the calendar table. In the first installment, I deal with business day problems.

In this tip, I talk about cases where SQL Server will interpret YYYY-MM-DD as YYYY-DD-MM, which is less than optimal.

After seeing this question pop up on forums multiple times, I wrote a quick tip about enforcing unique constraints where order doesn't matter.

After a question on #sqlhelp, I dug into what could be making sys.partitions slow, and how they might get the required information in a more efficient way.

A security fix for an elevation of privilege issue has been released for all supported versions of SQL Server.

I explain a recent case where sp_prepare came in handy: trying to validate a plan guide's impact.

I recently came across an interesting issue with CHECKDB snapshots, as well as a bit of information missing from the documentation.

More background on ParamParser, some recent changes, and several syntax examples.

I've made the GitHub repository for ParamParser public; here is some more background behind this project.