Partitioning 2: Getting and measuring partition elimination

In Partitioning 1, my query searched through all 1-12 partitions. Let’s see if we can reduce that number.

Adding the partitioning...

Azure SQL Database and Transaction Log

Checking out the transaction log in Azure SQL Database. If you are curious like me, you will want to know...

SQL Server Script To Check Your Backup RPO Status

I recently wanted a script to tell me that for every database on a given server
What levels of backups I...

Error: 9002, Severity: 17 log_reuse_wait_desc = ‘log_backup’ transaction log full

Shrink log file for log_reuse_wait_desc =...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Error: 9002, Severity: 17 log_reuse_wait_desc = ‘log_backup’ transaction log full

Shrink log file for log_reuse_wait_desc =...

[[ This is a content summary only. Visit my website for full links, other content, and more!...

SQLSaturday Krakow #824

Demo time – last preps!
SQL Saturday started on Friday with three preconfs. Kevin Boles, Tomasz Cieplak, Tomasz Libera & Grzegorz Stolecki did...

T-SQL Tuesday #111 – What is My “Why?”

This month for T-SQL Tuesday we are asked to describe our “Why”.  I have a couple of Whys not related...

What is your why? – T-SQL Tuesday #111

In this T-SQL Tuesday post, I answer Andy Leonards question of "Why do you do what you do"? It comes down to I automate what I can so that...

What is your why? – T-SQL Tuesday #111

In this T-SQL Tuesday post, I answer Andy Leonards question of "Why do you do what you do"? It comes down to I automate what I can so that...

What is your why? – T-SQL Tuesday #111

Would you believe that it is already the second Tuesday in February? Wow, this month is sure going fast. But...