Monthly Archives: April 2017
-
Why is a Windows authenticated login more secure than a SQL authenticated one?
12April 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?
3April 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 -
The more things change, the more they stay the same
2April 11, 2017 by Kenneth Fisher
Koen Verbeeck (b/t) is hosting T-SQL Tuesday this month and our topic is The times they are a-changing. In other …
Continue reading -
How do I change the increment of an identity column?
7April 5, 2017 by Kenneth Fisher
Wellll .. technically there is no native way to do it. I even went through my notes on identity columns. …
Continue reading -
Hiding tables in SSMS Object Explorer
13April 3, 2017 by Kenneth Fisher
Extended Properties Sometimes you find out the strangest things about SQL Server. I’ve written about extended properties before but had …
Continue reading
SQL Studies 