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.

Works fine here and as far as I know, it's supported. Now SQL 2005 wasn't supported on Vista before SQL SP2.

There is no limit on a table created at runtime for size. I'd guess that you might exceed the disk space for the file and cause a growth, which in...

Use Profiler. Track the SPID of the user with sp_who and use that as a filter in Profiler.

In SQL, there is no ordering to records, so in order to get the top 10, you need to specify some order, as Peter mentioned.

Is it top 10 by name,...

Is this a single query?

Very intersting questions. I'd try to experiment and with dbcc page or even add data to a new table in 2k chunks and see how many pages are used.

My suspicion...

Thanks for the notes and I'd hope things are ok if I miss a newsletter. It's happened before, so I'd like to think so.

I definitely wasn't prepared for work, and...

Partitioning should help, though be sure you separate out the IO or move to a new server to help with the load. If you can handle some of the stuff...

David,

Can you explain to a not-so-smart guy on where/why you'd want this language? I'm not quite following the problems it solves, or maybe I just don't understand what you think...

You can't "upgrade", but you can detach the dbs from personal and attach to Standard. As mentioned above, install only Standard on the new server.