Grouping in MS SQL Server

I did not realize how many options there were to basically build pivot tables in SQL. Very cool.

SQL unit testing?

Haven't used it yet, but it looks like it could be good.

What does bulk-logged mean anyway?

It doesn't always mean what you think it means, and it's not always faster. But it can save you a lot of log space when rebuilding an index.

Getting just the date

Just because I run into this problem a million times a month and always forget the correct magic:

SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))