Enable xp_cmdshell with sp_configure: turn on show advanced options, set xp_cmdshell to 1 and run RECONFIGURE. The full script is ready to run in SSMS.
SQL SERVER – Alternate Fix : ERROR 1222 : Lock request time out period exceeded
ERROR 1222: Lock request time out period exceeded. Find the blocking transaction with DMVs, and what to change when you are not allowed to kill it.
SQL SERVER – Query to Find Seed Values, Increment Values and Current Identity Column value of the table
A query to list every identity column with its seed, increment and current value, plus what those numbers mean and how to reseed a table safely.
SQL SERVER – Understanding new Index Type of SQL Server 2005 Included Column Index along with Clustered Index and Non-clustered Index
Clustered index and non-clustered index compared: how many you can have, how each stores data, and where the SQL Server 2005 included column index fits.
SQL SERVER – Fix : Error 1418 – Microsoft SQL Server – The server network address can not be reached
Error 1418 says the server network address cannot be reached or does not exist. Check the firewall, then enable TCP/IP for the server and client on port 1433.
SQL Server Interview Questions and Answers Complete List Download
The SQL Server Interview Questions and Answers Complete List Download collects my six part series in one PDF, as many readers asked.
SQL Server Interview Questions and Answers Part 6
Interview Questions and Answers Part 6 covers the six properties of relational tables and de-normalization, adding redundant data to help performance.