With 7 million rows of data, I'm thinking that you'll get a recompile on run anyway just due to the number of changes in the data.  So, I gotta ask,...

Chris,

Likewise it's interesting to think that databases are not used for performance... whatever.  The real key is that the inclusion of the NOLOCKs greatly reduced the number of deadlocks in...

Chris,

Yup... I agree on the data integrity thing but considering that a ROLLBACK is supposed to be (and, fortunately, is) an extremely rare occurance (and then usually only on the...

>I can only say that I would not do that.

Why not, Chris?

Thanks for the reply, Chris.  Your experience seems to contradict what BOL says.  Now, THAT's never happened before, eh?   Kinda why I asked if anyone had experience with...

Rumor has it that there are some very stiff penalties for storing unencrypted credit card information and other seemingly minor infractions on safeguards.  I would say there's no such thing...

Just for grins, how fast does it run without the ORDER BY?  If it's really fast, use the 14 row result set as a derived table and select from THAT...

Just a quick thought... why does the BCP login/password need rights to anything but the destination table?  Make a user that only has rights to the input staging table (you...

This will convert the number of seconds since midnight to a datetime (for today) datatype so you can do the join...

SELECT DATEADD(ss,secondssincemidnightcol,DATEADD(dd,DATEDIFF(dd,0,GETDATE()),0))

Nice job Sushila.... I use EM to troubleshoot other people's more complex joins and, occasionally, to make my own.  And, I "steal" code from it and QA quite a bit...

The "best" way would be to not store data in such a fashion...

That, not-with-standing... something like this should work...

 SELECT c.CategoryName,

        c.CategoryID

   FROM Category c,

        UserCategory uc

  WHERE ','+uc.CategoryID+',' LIKE...

Admittedly, I've not done much with Federated Servers but I'm not sure why the relatively simple process of ETL would justify the need even in a world wide setting.  The...

For reads, a "surrogate view" will give you that transparency.  The view would just do a SELECT * from the 4 part name. (Just gotta be careful that you're not...

I'm thinking that maybe a header with the purpose of the proc, usage, and a little revision history might be something to consider...  and, maybe, make all of the SQL...

Didn't the Feds just modify the dates for DST?