Kevin has a great analysis. Go with that.

Raiserror can log them. Look at the options in BOL.

I wouldn't expect issues either. If you're serving pages on the web, it's a bad practice to have SQL on the same box as IIS for security reasons, but not...

Allocate more space to the log file. I'd run it up to 2GB or so. It doesn't hurt you to reserve the space and preventing growths during busy transactions is...

The SQL_Oracle is right. There is no answer.

The default works well, but it depends. The log grows because of changes in your data. If you have mostly static data, like...

I passed last week and this was definitely a hard exam. Broad coverage of lots of topics, so be sure you know the product pretty well. Also the simulation sections...

I think it's probably irrelevant, but you definitely need to keep track of it. I have had to pull old data for legal reasons, though drop it in it's own...

Failure of a project is definitely something I think you can measure and a few people have given some nice criteria.

However personal success or failure is something different and something...

select a.item, a.date

from MyTable a

where a.date = ( select max(b.date)

...

If you just need schema, then I'd just script out the database. All tables, views, procs, users, security, etc. Basically check everything in the script box.

It's been awhile, but I think this has something to do with security. Either your user or the SQL Server user do not have administrative rights needed for debugging.

Everything in the index plan should add up to 100%, so there will always be things with large percentages. Seeks are better than scans because you're traversing the index directly...

I thought there was plenty of time, but I am a fast reader.

This exam is a "case study" exam. Each "part" is a case study, maybe a page to a...

Take a backup and zip it.

Lots of differences and really two many to list. SS2K5 is a whole new animal and an upgrade should bring along your jobs.