Set them all to whatever the default is (Books online should tell you that)

From SQL 2000 onwards you should just be using the recovery models (full, bulk logged and simple)...

SQL 2000, SQL 2005 or SQL 2008?

Ignore that setting and don't mess with it. It's there only for backward compatibility (SQL 7 and earlier I think), it is deprecated, it will be removed in future versions.

I would suggest that you buy the Self-paced training kit from MS Press. It's quite a good coverage of the exam topics.

Table variables work on iteration?

Wrong place.

I'm talking about the windows accounts that the two services run as. First you need to find out what they are, check the services app from Administrative tools....

Permissions?

Running through BI dev studio it'll be running under your credentials. Running as a SQL job it will be running either as the SQL Server service account or the...

You should have a reasonable amount of experience with the product before writing the cert exam. If you have not worked on 2008 you will struggle with the 2008 exams....

Winter's coming early here. It's already nippy enough in the evenings to require a jacket. That doesn't normally happen til May.

select d.name as DatabaseName, mf.name as FileLogicalName, mf.physical_name, type_desc, max_size

from sys.master_files mf inner join sys.databases d on d.database_id = mf.database_id

Any files with a max size of -1 are set...

Please post table definitions. Read this to see the best way to post this to get quick responses.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Is this for SQL 2000, 2005 or 2008? If 2005 or higher, look...

Agreed, and that's the only reason I want to reply. I just...

Providing the log hasn't been backed up or truncated since the delete.

Same data volume?

Same indexes?

Same statistics?

Same execution plan?

Same number of concurrent users?

Unlikely. The default trace has a minimum of events. I don't believe that the DML events are among them. It would be just too much activity for what's supposed to...