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.

Thank you for voting

We grab the top 50 according to some crazy forumula. Might be too much activity in the other forums.

OK, back online for awhile. So here goes.

It was probably a bad question to put out there, but it certainly got people thinking? My apologies for the poor wording.

There is...

That's true some of the time, but many people, including myself, still have work responsibilities that cannot easily be put off to anyone else.

John,

We're still sending them to you. It must be a filter somewhere that's stopped it.

Nothing has changed other than the domain name. Even the old one still works.

STeve