Category Archives: Microsoft SQL Server
-
Adding Identity to an existing column
2June 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
14June 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 -
SQL Crossword
7May 31, 2017 by Kenneth Fisher
I thought I’d do another crossword. Enjoy! If you need any help with it feel free to let me know …
Continue reading -
Running multiple queries at the same time.
8May 24, 2017 by Kenneth Fisher
I read an interesting question today. Someone wanted to be able to run the same stored procedure multiple times, at …
Continue reading -
What’s in a partition?
Leave a commentMay 22, 2017 by Kenneth Fisher
In my last post on partitioning I used the $Partition command in passing. I’ve been thinking it deserves a bit …
Continue reading -
T-SQL FizzBuzz
17May 17, 2017 by Kenneth Fisher
I was looking around for something to write about this evening and came across one of Russ Thomas’ (b/t) old …
Continue reading -
Why shouldn’t I shrink my database log file?
10May 15, 2017 by Kenneth Fisher
TL;DR: It’s pretty pointless and can cause performance issues. Let’s start by asking why you might want to shrink your …
Continue reading
SQL Studies 