SQL Index Rebuild vs Reorganize Comparison
The post SQL Index Rebuild vs Reorganize Comparison appeared first on SQLServerCentral.
Database Administration
Raising the Cost Threshold for Parallelism (CTFP) Affects SQL Server ...
The post Raising the Cost Threshold for Parallelism (CTFP) Affects SQL Server Missing Indexes appeared first on SQLServerCentral.
Thoughts Before Speaking at the Software Architecture Conference
Tomorrow, August 15, I have yet another conference where I’ll speak about MySQL’s performance. To be more […]
Using Query Store to Identify CPU Intensive SQL Queries and ...
The post Using Query Store to Identify CPU Intensive SQL Queries and Creating Proper Indexes appeared first on […]
It’s a recovery strategy, not a backup strategy
I’ve talked about it before; you shouldn’t have a backup strategy, you should have a recovery strategy. […]
How much Space can I expect to recover from a ...
In my last article – Identify Tables With Dropped Columns – we saw how we can identify tables […]
Getting Your DBA Teams Scripts into Git
One of the things that many teams of DBAs have is a set of scripts they use in […]
Snake draft sorting in SQL Server, part 4
In the previous posts in this series (part 1, part 2, part 3), I described how I […]
Snake draft sorting in SQL Server, part 3
In part 2 of this series, I showed an example implementation of distributing a long-running workload in […]