What is the “cost” in Cost Threshold for Parallelism?
tl;dr; While at one point the cost of a query was an estimated time to run in seconds, today it’s...
2017-04-17
507 reads
tl;dr; While at one point the cost of a query was an estimated time to run in seconds, today it’s...
2017-04-17
507 reads
You know, sometimes you get a silly idea in your head and you just HAVE to try it out. The...
2017-04-13
381 reads
Koen Verbeeck (b/t) is hosting T-SQL Tuesday this month and our topic is The times they are a-changing. In other...
2017-04-11
480 reads
I was working on a blog post this weekend that required a list of random numbers. Now, this isn’t exactly...
2017-04-05 (first published: 2017-03-22)
2,246 reads
Wellll .. technically there is no native way to do it. I even went through my notes on identity columns. No...
2017-04-05
486 reads
Compressing your backups has very few downsides. It’s usually faster (the additional time for compression is less than the time...
2017-04-03 (first published: 2017-03-16)
1,588 reads
Extended Properties
Sometimes you find out the strangest things about SQL Server. I’ve written about extended properties before but had no...
2017-04-03
500 reads
One of the big benefits of Azure, and in fact any of the cloud offerings I’ve seen, is the ability...
2017-03-29
719 reads
It’s that time again. Kennie Nybo Pontoppidan (b/t) is the host this month and has a fun topic for us....
2017-03-27 (first published: 2017-03-14)
1,128 reads
It’s been almost 3 years since I updated these SPs! I can’t believe so much time has gone by! Well,...
2017-03-27
504 reads
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
By Brian Kelley
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
I am trying to create a filter on a SQL Server audit to capture...
I've come across what appears to be a strange deadlock anomaly. As seen in...
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
From T-SQL, without requiring an XEvent session, can I tell which deprecated features are being used on my instance?
See possible answers