How do you find the size of the index for tables? A client asked me during a Health Check, and this script lists schema, table, index and size in KB and MB.
SQL SERVER – Unable to Start Service SQLSERVERAGENT on Server (mscorlib)
After moving the SQLAgent.OUT path, a client saw: Unable to start service SQLSERVERAGENT on server (mscorlib). Here is one cause of this error and the fix.
SQL SERVER – You Are Not Logged on as the Database Owner or System Administrator
A developer creating a table in SSMS got a pop-up: You are not logged on as the database owner or system administrator. Here is what the message means.
Build Your Own SQL Script Library
A SQL script library saves you from solving the same problem twice. This post shows a folder layout by task, a header block with the tested version, naming habits, a safe history, tests on a scratch server and a way to retire old scripts, with one small read-only script as an example.
SQL SERVER – Disable IntelliSense in SQL Server Management Studio
A client with over 350,000 tables in one database saw metadata locking every time SSMS opened. Disabling IntelliSense in SQL Server Management Studio fixed it.
SQL SERVER – XML Document Could Not be Created Because Server Memory is Low. Use sp_xml_removedocument to release XML documents
XML document could not be created, error 6624, on a server with 300 GB free. What OPENXML really costs, measured, and why XQuery is the fix.
SQL SERVER – Parallelism for Heap Scan
Two DBAs asked me if their table needed a clustered index. Our conversation during a Health Check turned into a lesson on parallelism for Heap Scan.