Tag Archives: microsoft sql server
-
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?
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 -
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 -
Increasing and decreasing the performance level of your Azure SQL Database
Leave a commentMarch 29, 2017 by Kenneth Fisher
One of the big benefits of Azure, and in fact any of the cloud offerings I’ve seen, is the ability …
Continue reading
SQL Studies 