Once a job completes (100%), it no longer appears in the dmv right? Am I correct in understanding that the DMV only shows currently executing requests?

Thanks

Good question, got tripped up on:

"All nonclustered indexes include the clustered index columns in their index pages"

I thought this was not true for the mere point that a table does...

This is so true dealing with most customer service departments these days. It really stinks that companies don't stand behind their products. What happened to the days when...

Thanks! I was not familiar with SAVE TRANSACTION.

Nice question! I didn't know a connections such as MULTIFLATFILE existed. I typically did what was suggested in the second answer. Thanks!

I agree as well that GROUPING_ID is not a sub clause of GROUP BY.

I agree that the answer appears simple, and SQL supports UCS-2 encoding, but if you take the question for face value, the answer looks like it could be up to...

I believe the answer should be char(1) or nchar(1) depending on the situation. varchar should not be used given the parameters in the question. The choice between char(1)...

I have a similar issue with AD limiting the number of rows returned. Did you ever find a resolution to this problem?

Thanks!

This is confusing, especially seeing this page:

http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

I agree. I think the correct answer is No...

I agree with the others, there is db_ssisltduser but no db_ssitduser.

Congratulations! This is truely a great site!

I agree with Warren as well. I originally thought the answer was NO until I read the restorehistory docs which have a verifyonly entry, so I answered YES which...

Could someone explain why the first answer would be incorrect?

I felt it was a correct answer based on SQL 2005 BOL:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/6d156257-8c80-4062-a6a0-acc6797b293f.htm

SQL Server 2005 supports the ability to impersonate another principal...