What are wait types and wait stats, and why do they matter? A simple explanation of the three kinds of wait types, starting with resource waits.
SQL SERVER – Soft Delete Conversation – Your Opinion Needed
My soft delete post got great replies on both sides. Here are short abstracts from readers like Karen Lopez and Tyler Clendenin, and your input is welcome.
Finding Misconfigurations With One Script
Finding misconfigurations With One Script checks SQL Server settings that deserve a review, with recommendations tied to workload and evidence.
SQL SERVER – Find Automatically Created Statistics – T-SQL
Ad-hoc queries on a production server left many useless automatically created statistics. Here is a T-SQL script to find them so you can clean them up.
Contained Database Users: Logins That Move With the Database
Use contained database users to move authentication with a database, inspect prerequisites, test connections, and review access ownership.
SQL SERVER – Find Row Count in Table – Find Largest Table in Database – Part 2
An improved script to find row count in table for every table and spot the largest table in the database, now with the schema name, thanks to Ameena.
SQL SERVER – Index Levels and Delete Operations – Page Level Observation
When you delete data from a table, does SQL Server reduce its size? A page level look at index levels and delete operations, corrected with Hrvoje’s help.