Category Archives: Microsoft SQL Server
-
Modulo!
7April 14, 2016 by Kenneth Fisher
I love this somewhat obscure mathematical operator. All it does is return the remainder of a division statement but even …
Continue reading -
The risks of Delayed Durability
3April 12, 2016 by Kenneth Fisher
It’s T-SQL Tuesday again and this month we are hosted by Jens Vestergaard (b/t) who want’s us to talk about …
Continue reading -
Name the schema when you create an object (or else)
1April 6, 2016 by Kenneth Fisher
This is one of those frequently ignored best practices. When you create an object, specify the schema where it will …
Continue reading -
Complex/Conditional ORDER BYs
1April 4, 2016 by Kenneth Fisher
Typically it’s considered best to run your queries without an ORDER BY and let the application do any sorting needed. …
Continue reading -
Hidden code in AdventureWorks
4April 1, 2016 by Kenneth Fisher
I’ve playing around with AdventureWorks and managed to found some hidden code! Truly odd stuff. I’m so shocked I couldn’t …
Continue reading -
When should I test?
2March 30, 2016 by Kenneth Fisher
To test or not to test. That is the question. Or is it? Shouldn’t we always test? That was the …
Continue reading -
Why you shouldn’t use SELECT *
2March 28, 2016 by Kenneth Fisher
I answered an interesting question on SE today (ever notice how many posts come from stuff I read on forums?) …
Continue reading -
I’m presenting for the Pass Security Virtual Chapter!
1March 23, 2016 by Kenneth Fisher
Tomorrow (3/24/2016) at noon CT I’ll be presenting my SQL Server Security Basics session for the Pass Security Virtual Chapter. …
Continue reading -
TOP 1 killed my performance; Rob Farley helped me resurrect it.
15March 21, 2016 by Kenneth Fisher
tl;dr; There is no short version of this. It’s LONG. It’s interesting but you might want to skip it if …
Continue reading -
What permissions do I need?
Leave a commentMarch 16, 2016 by Kenneth Fisher
Ever wondered how to tell what permissions are required to run a statement or perform a task? Well, sometimes it …
Continue reading
SQL Studies 