-
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 -
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 -
Creating a list of random numbers
3March 22, 2017 by Kenneth Fisher
I was working on a blog post this weekend that required a list of random numbers. Now, this isn’t exactly …
Continue reading -
The parts of an object’s name
3March 20, 2017 by Kenneth Fisher
Any object within a database in SQL Server has what is called a four part name. Which rather implies four …
Continue reading -
Compressed backup errors and TF 3042
6March 16, 2017 by Kenneth Fisher
Compressing your backups has very few downsides. It’s usually faster (the additional time for compression is less than the time …
Continue reading
SQL Studies
Live, Learn, Share
SQL Studies 