A client kept truncating the transaction log because of a growing log file. I explain why that is risky and share two better options, starting with Simple recovery.
Percent of Total With SUM() OVER() in One Query
Calculate percent of total with SUM() OVER(), group and running shares, safe numeric division, and checks for zero totals.
SQL SERVER – Disabled Index and Index Levels and B-Tree
For T-SQL Tuesday I write about my mentor Vinod Kumar and his interesting question, which leads to a disabled index, its index levels and the B-Tree.
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.
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.





