Who dropped my table? Who is using my memory? SQL Server Management Studio Reports answer many such questions. Here is an introduction to them.
SQL SERVER – Find Blocking Using Blocked Process Threshold
My friend Jim came back with more blocking questions. Here is how the blocked process threshold option, a feature hidden in plain sight, helps find blocking.
Missing Index Query Text: Linking Suggestions to Their Queries
A missing index suggestion means more when you can see its query. Here is how to link them, trim the text and test the index.
MySQL – Add a Column at Particular Ordinal Position in Table
SQL Server needs the designer to add a column at a particular ordinal position, but MySQL does it with ALTER TABLE and AFTER. Here is a quick example.
SQL SERVER – Activity Monitor to Identify Blocking – Find Expensive Queries
My friend Jim needed an easy way to find blocking on a live system. Here is how to use Activity Monitor to identify blocking and find expensive queries.
SQL SERVER – SSIS Component Error Outputs – Notes from the Field #034
Notes from the Field #034: Tim Mitchell explains SSIS component error outputs, how to use them in practice, and the caveats to watch for.
Natively Compiled Procedures: ATOMIC Blocks and T-SQL Limits
Native procedures check every statement when you create them. Build a tiny one and see which habits it will not accept.