Back to Basics, Blog, DBA, Indexes, performance tuning, Posts with Scripts, SQL Server, Stored Procedures Quick Tip: Remove CONVERT\CAST from your WHERE\JOIN clauses By: Monica Rathbun Published On: March 28, 2022 Read Blog >
Blog, drop_existing, Index, Indexes, Msg 7999, performance tuning, SQL Server SQL Index Creation Using DROP EXISTING= ON By: Monica Rathbun Published On: February 17, 2021 Read Blog >
Azure, Blog, Indexes, performance tuning, SQL Server Dropping Unused Indexes on an Azure SQL Database By: Monica Rathbun Published On: August 12, 2020 Read Blog >
Blog, Indexes, performance tuning, SQL Server Coding Standards Gone Bad in SQL Server By: Monica Rathbun Published On: April 21, 2020 Read Blog >
Blog, Indexes, performance tuning, SQL Server In Memory Table Indexes By: Monica Rathbun Published On: January 22, 2020 Read Blog >
Blog, Indexes Changing MaxDop For Resumable Index Create Operations By: John Morehouse Published On: January 17, 2020 Read Blog >