Find duplicate customers with T-SQL by normalizing names, reviewing fuzzy matches, and merging records only after ownership is settled.
Running a Command in Every Database Without sp_MSforeachdb
Run a checked command in every database with a FAST_FORWARD cursor, AG role filter, QUOTENAME, and per-database error log.
Redundant Indexes: Index on Col1, Col2 vs Col1, Col2, Col3
Redundant indexes cost space and slow every write, but not every one can go. This post measures an index on Col1, Col2 next to an index on Col1, Col2, Col3 on SQL Server 2025: size, plan, reads and log bytes. It ends with a safe way to remove one.
SQLAuthority News – Year 2012 in Review – Perspective of Blog
The Year 2012 for this blog in numbers: about 19 million views, 372 new posts and 2,360 in total. Thank you for making SQLAuthority.com a place to learn.
Wrap SQL Code in SSMS: SQL in Sixty Seconds #038
You can wrap SQL code in SSMS so long lines fit the window and you never scroll sideways. This post gives the exact menu path, what each option on that page does, a long query to test it with and a shortcut for switching it on and off.
Performance Baseline in SQL Server: Measure Before You Tune
Build a performance baseline in SQL Server with saved waits, file latency, query CPU, and counters before judging a tuning change.
SQLAuthority News – Last Post of Year 2012
My last post of year 2012 remembers 37 SQL in Sixty Seconds episodes, nine Memory Lane articles, community events and family moments.