SQL Index Rebuild vs Reorganize Comparison
This tip covers the differences and similarities between SQL Server index rebuild and index reorganize operations.
2024-09-30
This tip covers the differences and similarities between SQL Server index rebuild and index reorganize operations.
2024-09-30
2024-09-27
406 reads
This article explores how raising the Cost Threshold for Parallelism (CTFP) affects missing index recommendations in SQL Server along with examples.
2024-09-25
2024-09-20
434 reads
This continues my series on auditing SQL Server. The fist parts covered discovery and documentation, server level hardware audits and SQL Server engine level audits. This section examines database configuration audits.
2024-09-18
2024-09-13
149 reads
2024-09-11
368 reads
I’m not the first person to write about cleaning up unused or redundant indexes.
2024-08-16
2024-08-14
365 reads
2024-08-05
336 reads
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
You can find all the session materials for the presentation “Indexing for Dummies” that...
Comments posted to this topic are about the item DBCC CHECKIDENT
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
Hi, our peer who owns a remote mysql server from which we extract warehouse...
What is returned as a result set when I run this command without a new seed value?
See possible answers