Category Archives: Microsoft SQL Server
-
Why shouldn’t I shrink my database log file?
1May 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 -
Dynamic SQL and the joys of QUOTENAME
5May 11, 2017 by Kenneth Fisher
I’m a big fan of dynamic SQL. In the past I’ve written a How to, a Best Practices and even …
Continue reading -
Continuous Integration
Leave a commentMay 9, 2017 by Kenneth Fisher
It’s T-SQL Tuesday again! This month we are being hosted by James Anderson (b/t). Thanks James! He has asked us …
Continue reading -
Partitioning on a nullable column
3May 3, 2017 by Kenneth Fisher
tl;dr; If you are SWITCHing data into a table and the partitioning column is nullable you will need to add …
Continue reading -
Why is a Windows authenticated login more secure than a SQL authenticated one?
8April 26, 2017 by Kenneth Fisher
I had this question come up at work the other day and while I knew it was true I wasn’t …
Continue reading -
SSMS Tips: Copy Full Path
Leave a commentApril 24, 2017 by Kenneth Fisher
When you right click on a tab you’ll see a number of different options. You can set up new horizontal …
Continue reading -
When should I add an index?
7April 19, 2017 by Kenneth Fisher
We all know indexes are good and I’m hoping everyone knows you can have too many indexes. That means we …
Continue reading -
What is the “cost” in Cost Threshold for Parallelism?
2April 17, 2017 by Kenneth Fisher
tl;dr; While at one point the cost of a query was an estimated time to run in seconds, today it’s …
Continue reading -
No space queries
2April 13, 2017 by Kenneth Fisher
You know, sometimes you get a silly idea in your head and you just HAVE to try it out. The …
Continue reading
