Before SQL Server 2005, we would always use DBCC SHOWCONTIG to identify fragmentation in indexes. We would use DBCC INDEXDEFRAG to perform an online defrag and DBCC DBREINDEX to rebuild indexes ...

Microsoft’s Bradley Ball dives into the inner workings of SQL Server indexing to help developers and DBAs speak the same ...

In early November 2021, Microsoft announced the private preview of its flagship database product, SQL Server 2022. At some point in 2022, we will see SQL Server 2022 released as a general availability ...

At Microsoft Build, SQL Server 2025 enters public preview with major enhancements in AI integration, performance, reliability and developer tools -- reaffirming Microsoft’s continued investment ...

PolyBase, a data virtualization feature for SQL Server, allows users to seamlessly query data from various external sources directly using T-SQL (Transact-SQL) without the need for separate client ...

Here is a list of common wait types and techniques that every DBA (or wannabe DBA) should know. While there are many more wait types than listed here, understanding these will give you a leg up when ...