December 2008 - Posts

• Drop All Indexes and Stats in one Script

  I am not sure why someone would want to do this, but it was asked on the forums, and I figured I would post the code I created to perform such a nightmarish operation.  As with any post that I make providing code that could be potentially damaging Read More... Posted Monday, December 15, 2008 8:44 AM by Jonathan Kehayias | 0 Comments Filed under: Transact-SQL, MSDN Forums

• SQL Quiz #1

  Ok so I made a mistake last time around, and I actually was tagged by Kendal Van Dyke , though I missed it back in November.  So in the spirit of the exercise here are my two biggest blunders in SQL Server based on the Two mistakes post started by Read More... Posted Tuesday, December 09, 2008 11:54 PM by Jonathan Kehayias | 0 Comments Filed under: SQL Quiz