Viewing 15 posts - 57,901 through 57,915 (of 59,066 total)
Good lord, don't use a text column. If you have to, put a VARCHAR(8000) in a parallel table with the same key... you're asking for a world of hurt when...
August 4, 2006 at 8:31 pm
Actually, it does... but you must include the object owner as the object name... in other words, you have to use the 2 part naming convention when changing the ownership...
August 4, 2006 at 8:27 pm
Thanks for the feedback on this, Doanthi...
I don't know what it is but I've never had the speed problems with "Select Into" that so many have spoken about. It is...
August 4, 2006 at 8:13 pm
Spot on... I absolutely agree with Aaron. In fact, I don't know of any other way to establish DRI between two different databases.
August 4, 2006 at 7:56 pm
Cool... got titles and synops for the new books that you might care to share... nothing like being on the "bleeding edge", ya know
August 4, 2006 at 7:28 pm
John,
Just one more question... is the CDRFingerPrint unique no matter how many CDR's you load?
August 4, 2006 at 7:14 pm
John,
Despite the fact that Joe has, once again, demonstrated that soft-skills are not his main focus in life
, he is absolutely correct......
August 4, 2006 at 6:58 pm
Tom,
I agree with Serqiy... write other sp's to do one part of your process well... write as many as you need... then, go ahead and call them from a "main"......
August 4, 2006 at 5:23 pm
The following (code) tells me that your clustered index on Termination_Date isn't covering enough of the columns... if it is, then why are you joining to EventType and CDRFingerPrint, as well? ...
August 4, 2006 at 5:11 pm
Ok, not a problem (hopefully I understand your problem now)...
You'd lookup the timezone for each user, get the offset in minutes and, using DATEADD, simply add the minutes to the...
August 4, 2006 at 7:11 am
I agree... breaking up a proc/script just to control size is a bit stupid but using GOTO, as you suggested, isn't the way to do it. CASE and IF BEGIN/END is...
August 4, 2006 at 7:06 am
I know that, John... what are the statements? You may not need the loop at all! Loops are a form of RBAR and generally defeat the power of an RDBMS!
August 4, 2006 at 7:04 am
I suspect that part of the reason that it's taking so long is because of the self join during the insert... the criteria may have to be reevaluated after every...
August 4, 2006 at 6:48 am
"doesn't seem to lend itself to any sort of structure"???
As Serqiy said, you can create stored procedures that act as "main" routines that call other sometimes reuseable stored procedures as if they...
August 3, 2006 at 7:23 pm
Viewing 15 posts - 57,901 through 57,915 (of 59,066 total)