Reload a table quickly.

Sometimes loading new data or even changes into a table just isn’t going to work. You need a complete reload....

It greatly pleases me to announce, HAL0003!

I while back as part of a T-SQL Tuesday post I created HAL0001, then later HAL0002 with a long-term goal...

When was my index created or at least last updated?

SQL Server stores a create date and a change date for each object in the sys.objects system view.

Unfortunately while...

Getting more done with OUTPUT

Use OUTPUT to perform an INSERT and a DELETE at the same time.

SQLSkills waits and latches library

SQLSkills is an amazing resource for the SQL Server community. Between their blogs, white papers, and the SQLSkills Insider emails...

Is it safe to grant Administer Bulk Operations?

First I guess we had best start with definitions right? The permission Administer Bulk Operations and the role bulkadmin are...

TSQL Tuesday #84: Zip to Speaker

Well, it’s that time of the month again. It’s T-SQL Tuesday yet again, and this time round it’s Andy Yun (b/t)...

The Halloween Problem

DBA: Help me! Help me! It’s Halloween! I have a problem! Oh won’t you please help me!
Ok, so that’s really...

New indexes, hypothetically

I saw something like this the other day. My first thought was “Hu, never seen that before.” My second thought...

It’s a small world

As I write this we are packing to leave for Disney World, where my family and I will spend close...