SQL Homework – July 2017

For years Russ Thomas (b/t) has done a Monthly DBA Challenge and in fact I’ve used it as insperation a...

Temp table quiz

Brent Ozar (b/t) posted a pop quiz on twitter earlier today.

Go ahead and give it a shot .. I’ll wait.
So?...

Turning ANSI_PADDING off, and why you shouldn’t

I ran into an interesting error the other day while doing a partition switch.
Partition switch failed because : column ‘xyz’...

Dynamically generate the command line DMA statement for each database

If you are upgrading your instance to 2016 (or 2017 soon) then you probably are going to want to run...

Adding Identity to an existing column

A friend had an interesting problem today. A really big table (multiple millions of rows) and no primary key. He...

SQL Crossword

I thought I’d do another crossword. Enjoy! If you need any help with it feel free to let me know...

Buzzword Bingo

Grant Fritchey (b/t) is our host for T-SQL Tuesday this month and surprise surprise he’d like to talk about DEVOPS....

Running multiple queries at the same time.

I read an interesting question today. Someone wanted to be able to run the same stored procedure multiple times, at...

UDP vs TCP

If you’ve worked much with named instances you’ve probably had to deal with the question “What port is that instance...

Backup to NUL

Yes, I spelled that correctly. NUL not NULL. NUL is basically a location you can send a backup to. In...