Should You Split Queries?
The SplitQuery feature in EF is a terrible feature in most cases. Developers should avoid using it.
Should You Split Queries?
A Useful Script to Delete Data from Multiple Tables
Use Filtered Statistics to Improve Performance on Very Large Tables
The Performance Tuning Magic Show @ DPS2022
Can I Pause and Resume an Index Rebuild Operation?
Extract, Transform...and, send an e-mail!
How to Identify and Fix Tempdb Contention
Do You Have a Proper Backup Strategy?
Truth is multidimensional and depends on the perspective you view from
If you want to torture data - store it in CSV format