I'll add a couple of more...

Everyone who doesn't telecommute will hate you (for obvious reasons).

Everyone who doesn't telecommute will perceive you as a slacker unless you produce double the work...

Heh... I know what you're thinking and "No", do NOT change the order of the columns in the index I recommended 😉

The PK Clustered Index you have might be good for something else, but it's no good for this query even though the execution plan say's you're using the clustered index......

For testing purposes, how many file names are we talking about? And, if you don't mind, can you post the CREATE statment for the table, any existing indexs, and...

Yowch! The data's a bloody mess. Who in their right mind would list the word "NULL" for a null in a transmitted text file nevermind add trailing spaces...

Thanks, Steve......

That's not nice... Matt was spot-on by saying you weren't providing enough information. I simply took a guess and didn't say much more than he did.

I do. In fact, I wrote an article about it that should be coming out soon! It was submitted way back on 11 Dec 2007...

And that, folks, is a Triangular join... works seemingly fine on small groups... cripples CPU's on larger groups... be careful...

See the following URL for more details on Triangular joins...

http://www.sqlservercentral.com/articles/T-SQL/61539/

Simply stated, there is no equivalent for Oracle's spool command. You can use OSQL with a DOS redirect to a file or BCP or DTS or...

Gregory,

I'm curious... What size (in gig or tera-bytes) is your OLTP and Reporting databases?

Best thing you could do for answers to all of that, and more, is to lookup "System Tables" in Books Online (comes free with SQL Server) and drill down to...

And another great tool bites the dust.

Well, where will it be run from... it'll make a difference.

I haven't tried to find the information in 2k5, but you really need to be careful... although the max number of columns may be 1024 per table, you need to...