There's a lot of things I don't like about the new site, to wit, reasons why I don't use other sites.

I've pretty much beat up on the "Recent Posts" and...

1. Ok... I just lost my post by hitting the Preview button... would you please fix that first 😀
2. Also, lot's of functionality has been lost under the "Recent Posts" link... 

1. What...

1. Ok... I just lost my post by hitting the Preview button... would you please fix that first 😀
2. Also, lot's of functionality has been lost under the "Recent Posts" link... 

1. What...

Great idea... but do you write production code the same way?  :blink:  No documentation, no formatting to speak of, no header?

I frequently DO tell the vendor 😛  Many times, I'll find an alternate that does the job right and start migrating business from the uncooperative vendor.  For sole source vendors, I teach...

Maybe... but how ya gonna know about SOX violations if no one reviews the code? 😛

Bottom line is to protect the data and the server.  Slow running code has the...

Sorry... my mistake... didn't read the reply well enough and this new system won't let me edit or delete my previous post...

Shoot... that's not true in 2000... lookup "Creating a Partioned View" to see how to partition tables... :discuss:

Great idea, George... just keep in mind that only works if you're calling BCP via xp_CmdShell in T-SQL or you have Windows Authentication enabled on the server...

You bet... thanks for the feedback.

Heh... at least you said "set"...

Ok, thanks, guys... I've gotta study this a bit.

Ummm... "monitoring" is great... helps you identify crap code that takes days to run without finishing... but, unless you take the next step, you might as well not waste your...

Wouldn't have a problem at all if the HD's were labeled correctly as HD1, HD2, HD3, etc

Here's the corrected query... since I don't have the tables available that you do, I'm unable to test it, but it should be close.  Combine that with the suggestions others...