A client’s DBA restarted the server just to start a fresh Error Log. There is no need: you can recycle the log and create a new file without a restart.
SQL SERVER – Index Levels and Delete Operations – Page Level Observation
When you delete data from a table, does SQL Server reduce its size? A page level look at index levels and delete operations, corrected with Hrvoje’s help.
SQL SERVER – Download SQL Server 2008 Interview Questions and Answers Complete List
Download SQL Server 2008 Interview Questions and Answers as one complete list, now with typos corrected. Readers say it is very useful for beginners.
SQL SERVER – TRANSACTION, DML and Schema Locks
Most candidates in a senior developer interview could not create a scenario that shows schema locks. Here is a simple demo with a TRANSACTION and DML.
SQL SERVER – Interview Questions & Answers Needs Your Help
My SQL Server Interview Questions and Answers needs your help. I am updating it, so share a suggestion or a good interview question with its answer.
SQL SERVER – Difference Between Update Lock and Exclusive Lock
What is the difference between Update Lock and Exclusive Lock? An Update Lock can sit on a row that has a Shared Lock, then turns Exclusive when it writes.
SQL SERVER – Stored Procedure are Compiled on First Run – SP taking Longer to Run First Time
Why does a stored procedure take longer the first time? Stored procedures are not pre-compiled; each one is compiled on first run and cached after that.