Category: SQL Server

Performance of sys.partitions

After a question on #sqlhelp, I dug into what could be making sys.partitions slow, and how they might get the required information in a more efficient way.

Troubleshooting Error 18456

Updated in 2020 with a few new entries, this is a fairly comprehensive list of the reasons behind various 18456 error messages.