T-SQL Tuesday #52 – Arguments

It’s time for T-SQL Tuesday, this month hosted by Michael J Swart, our artistic DBA in the community. I love...

T-SQL Tuesday #52: Keep your head down!

It is T-SQL Tuesday again and this month we are taking the road less traveled. Michael J Swart (b/t) has...

Why worry about CXPACKET

Many people see CXPACKET at the top of their waits and start trying to fix it. I know this topic’s...

[SQL Snacks Video] The Basics of Joins

This is a special edition for SQL Snacks.  It is one (of many hopefully) SQL Snacks that has been recorded...

Bad Ideas: Alert Storming

Fellow DBA: There are so many alerts! It takes me a long time to get through them all. How do...

Issue with sys.dm_db_index_usage_stats in SQL Server 2012

I’d be struggling to remember a week where I hadn’t run a query against the dmv sys.dm_db_index_usage_stats to find unused...

Last Weeks Top “Reading” Links #74

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...

Look At The SQLSaturday Orlando Home Page

One of the weaknesses of the current SQLSaturday tool set is that the front page isn’t strong by default. It...

Two Digit Dates in SQL – MM/DD/YYYY

When creating dates or numbers as strings it is sometimes required to have two digit numbers.
For example, instead of...

Two Digit Dates in SQL – MM/DD/YYYY

When creating dates or numbers as strings it is sometimes required to have two digit numbers.

For example, instead of this:...