June 2008 - Posts

• Import/Export Wizard and indexes, keys etc

  Here's one which I've seen much confusion about. Something like "I copy tables from database A to database B but I don't get any indexes, keys, constraints etc. This worked in 2000. Why?". We need to first understand that that Import/Export Wizard just Read More... Posted Saturday, June 21, 2008 11:14 AM by TiborKaraszi | 0 Comments Filed under: Tools

• Did we have recent autogrow?

  I just read the question how to find out when autogrow in tempdb happened. And again I want to push for the default trace. The simple answer is that you already have this information available, just go and get it! (Unless you explicitly disabled the default Read More... Posted Thursday, June 19, 2008 4:51 PM by TiborKaraszi | 12 Comments Filed under: Trace