I have googled and read and reviewed the training kit but there were many pieces and finally I wanted an answer framed to my specific question.

ALZDBA, the recommended links...

I am working my way through this answer. Thanks for all the help, Paul NZ!

another question about starting SQL Server in single user mode. If prior to shutting down SSMS I had enabled xp_cmdshell using sp_configure, then from the command shell in single...

I expanded the SQL Server Agent logs and found "An idle CPU condition has not been defined - OnIdle job schedule will have no effect".

Is it possible that...

Is it possible that SQL Server Agent wouldn't execute a job if CPU idle went below a certain threshold?

here's a link for 2008 SQL Server...

http://msdn.microsoft.com/en-us/library/ms178129.aspx

it even includes info for skipping a column during import which may help with the earlier problem you had in the other...

http://msdn.microsoft.com/en-us/library/ms190393.aspx

Here's a link for "Format Files for Importing or Exporting Data". Haven't had a chance to read it through myself but looks promising. See how far you...

Thank you, I've noted your observations. I can use my 'sa'. I didn't know I could use master. The paths are in testing environment and I will not...

I'm following this thread and went to the documentation. I found:

"To prevent SQL Server from assigning identity values while bulk importing data rows into a table, use the appropriate...

My final understanding on this topic, is that, in the case of a column with FILESTREAM property the file is stored on the filesystem by human intervention. A properly formatted...

I am very sorry to bother you again. Suddenly, another question about FILESTREAM

Are the contents of the product catalogue, actually imported into the varbinary (max) column even when it...

I think it's a bad exam question 🙂

Good avator by the way. I feel like I am talking to Liam, all the time, Gail. For the record, that...

There are questions on the practice exams whose answers are "COM-based stored procedure conflict resolver" or "Enable the Common Language Runtime (CLR)", which the training kit doesn't talk about at...

OK, that's fine. So, back to the original exam question.

Since any changes to the catalog occur during a maintenance window what information in the quesiton would favor B over A?...

OK, if the file is under 2GB, can you give me a reason or two for not storing it in the database? Performance?