You should be able to figure it out.

I don't have time to type out 6 subqueries each with 10 unioned queries...

... FROM tbl1 INNER LOOP JOIN tbl2 ON ... -- nested loop join

... FROM tbl1 INNER MERGE JOIN tbl2 ON ... -- merge join

... FROM tbl1 INNER HASH JOIN tbl2...

On 2005, you could use a recursive CTE.

Why can't you use a table?

If you absolutely want to do this the hard way, something kinda like this will probably...

Cross join a couple of system tables together. Jeff usually uses spt_values (in master)

You could use a user table also. All you need is one table of 1000 rows.

It is possible to force the type of join (nested loop, merge, hash) you want, however, unless you really understand how the different joins work, when the different types are...

- becuae the coffee in Seattle is soooo very good.

- because it's a good opportunity to renew friendships with the people you met last conference

- because you'll never complain about...

ALTER TABLE <Table name> ALTER COLUMN <Column name> <New data type>

If you do a Restore Headeronly, you get a resultset with details on each backup that's contained within the file. The DB name is one of the things returned.

restore headeronly...

Are the files read only? (if you copied them using CD/DVD it's very likely they are)

Are the files in a compressed or encrypted directory?

What happens if you run

ALTER DATABASE...

How big are those tables? How many pages?

Certain sp_configures also flush the cache. I don't know offhand which ones. In SQL 2000 prior to SP4 (I think) it was all changes done using sp_configure

There's a whitepaper on best practices for TempDB. I'll see if I can find it, I think I have the link at the office,

Regarding the separate drives, it depends on...

Please do. It would be...

Colin: do you have a good article/blog post that explains /3gb, /pae and AWE on 32 bit systems?

All /3gb does is change the normal division of the virtual addressable 4 GB (all that's directly addressable on 32 bit) from 2GB for user processes and 2 GB for...