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.
Regaining sysadmin Access When Nobody Can Log In
Regaining sysadmin access starts with single-user SQL Server, a local sqlcmd connection, and a controlled Windows admin group.
Sharding: When One Server Is Not Enough
Sharding splits SQL Server data by a stable key when one server cannot meet scale needs; learn routing, cross-shard costs, and simpler options first.
SQL SERVER – Creating Database with Different Collation on Server
A client ran two instances on every server just for case sensitivity. Here is how to create a database with a different collation on the same server instead.
Take a Database Backup in SSMS: Step by Step
To take a database backup in SSMS, right-click the database, choose Tasks, then Back Up, and pick the backup type. This post walks through the dialog, shows the T-SQL that does the same work, explains the log backup error people meet first, and checks the files afterwards.










