Another one I haven't read but would like to is "The Art of SQL." I'm not sure of the authors name. Several people I talked to says it's a great...

And in addition to making sure the App is pointed at the right database, make sure you are.

I've never tried doing it like that before. I generally just schedule perfmon to collect counters during the anticipated runtime of a process like that. Also collect Profiler data and...

Definately post the execution plans.

Even without them, changing the collation on the fly is likely to prevent the use of an index on the column. IN clauses act as cursors,...

I would recommend starting with Itzik Ben-Gan's "Inside SQL Server 2005: T-SQL Querying." It's one of the best books on TSQL out there and I can't recommend it enough. I...

I'm not sure. When I drop the database, the files go away too. Did you detach instead of drop the database?

Whoa!

I've definately seen variation, but nothing that extreme. Yeah, I'd love to see those examples. I'm just starting an article on how to break down complex queries. I may have...

It's really two different queries. I'd split them into two procedures, even if you call them from this single procedure, have it call the other two procedures depending on the...

And...

FROM @Datalink.Query(1).Name@ DQ1,

@Datalink.Query(2).Name@ DQ2

LEFT JOIN DQ1 on SC_NAMES.SC_CODE = DQ1.SrcCode

You've got a couple of other problems. You're mixing a variable in for the schema owner? You can't do that....

SC_NAMES is not a table in the FROM list.

I still land back at using one of the third party tools. They're very effective. I know the Red Gate tool can be run from the command line so you...

Sorry, I said ad hoc when I meant dynamic. I didn't mean to be unclear.

Seriously though, you'd be better off with dynamic queries running on each database individually rather than...

To all intents & purposes... Jinx!

If you're going with ad hoc queries, save yourself the headaches and just write the code directly against each database. The performance won't be any worse and the development and...

I'm not entirely sure I understand the question, but I'll take a shot.

You can export the entire schema to a single SQL file. Then you can use a third party...