Category Archives: Microsoft SQL Server
-
What is the system_health extended events session?
1July 5, 2017 by Kenneth Fisher
Similar to the default trace the system_health session is automatically started up when the instance starts and collects information about …
Continue reading -
SQL Homework – July 2017
9July 3, 2017 by Kenneth Fisher
For years Russ Thomas (b/t) has done a Monthly DBA Challenge and in fact I’ve used it as insperation a …
Continue reading -
SQL Crossword : T-SQL Keywords : June 2017
2June 28, 2017 by Kenneth Fisher
I did a SQL crossword last month (not my first one either) and it was pretty popular so I asked …
Continue reading -
Temp table quiz
10June 26, 2017 by Kenneth Fisher
Brent Ozar (b/t) posted a pop quiz on twitter earlier today. Go ahead and give it a shot .. I’ll …
Continue reading -
Dynamically generate the command line DMA statement for each database
Leave a commentJune 21, 2017 by Kenneth Fisher
If you are upgrading your instance to 2016 (or 2017 soon) then you probably are going to want to run …
Continue reading -
Adding Identity to an existing column
1June 19, 2017 by Kenneth Fisher
A friend had an interesting problem today. A really big table (multiple millions of rows) and no primary key. He …
Continue reading -
Turning ANSI_PADDING off, and why you shouldn’t
4June 15, 2017 by Kenneth Fisher
I ran into an interesting error the other day while doing a partition switch. Partition switch failed because : column …
Continue reading -
Buzzword Bingo
Leave a commentJune 13, 2017 by Kenneth Fisher
Grant Fritchey (b/t) is our host for T-SQL Tuesday this month and surprise surprise he’d like to talk about DEVOPS. …
Continue reading -
UDP vs TCP
3June 7, 2017 by Kenneth Fisher
If you’ve worked much with named instances you’ve probably had to deal with the question “What port is that instance …
Continue reading -
Backup to NUL
6June 5, 2017 by Kenneth Fisher
Yes, I spelled that correctly. NUL not NULL. NUL is basically a location you can send a backup to. In …
Continue reading
