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.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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.
SQL SERVER – Index Created on View not Used Often – Limitation of the View 3
An Index Created on a view does not always stop queries from reading the base table. Limitation 3 of views, shown with a simple example.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.