Transaction Log Backups – How long to keep them?
Introduction In this post I will give you a tip on how long it would be …
Transaction Log Backups – How long to keep them? Read more →
Sort records without ORDER BY?
How often you see some smartie “optimizes” the query by removing ORDER BY, justifying that query …
Do you measure query IO with SET STATISTICS IO ON ?
Introduction In our tuning work and often in presentations we see people use SET STATISTICS IO …
Do you measure query IO with SET STATISTICS IO ON ? Read more →
READ COMMITTED sucks!
Are you still using READ COMMITTED transaction isolation level? Default transaction isolation level on all SQL …
Disk failure probability on a large number of disks
Introduction We either have or will experience a drive failure. Doesn’t matter if we talk about …
Disk failure probability on a large number of disks Read more →
Transaction log myths
There are some myths widely spread about transaction log that are to be debunked here: Log …
Procedure with Execute as login?
Sometimes we need a low-privileged user to do a specific administration task or task that require …
Set transaction log size and growth
Introduction What is the best practice, how to properly set-up transaction log initial size, growth, and …
Transaction log Truncate vs Shrink vs VLF number
Transaction log truncate – why it didn’t shrink my log ? (Truncate vs Shrink) Introduction One …
Transaction log Truncate vs Shrink vs VLF number Read more →
Transaction log survival guide: Shrink 100GB log
Introduction You got yourself in situation where transaction log has massively grown, disk space became dangerously …
Transaction log survival guide: Shrink 100GB log Read more →
