Viewing 15 posts - 52,066 through 52,080 (of 59,070 total)
Nisha, it depends... is the code for high hit ratio GUI code or is it for batch code that runs every once in a while?
March 6, 2008 at 6:29 am
SELECT/INTO hauls butt in any DB but it runs like an ape that sat on a hot coal if you use it on a database that is setup for anything...
March 6, 2008 at 6:24 am
Heh... WELLLLLLLLLLL!!!!!!
I'm pretty sure all you need is one select per column per table. It there where some rhyme or reason to the table names you
wanted to attack, we...
March 6, 2008 at 6:03 am
Grant Fritchey (3/5/2008)
What this is doing is using the temp table in place of a join or joins. That's bad.
Ummm... I gotta say, "Not always". I've used temp...
March 6, 2008 at 5:17 am
Nicely done... there are a couple of things I do exactly the opposite of you, but if I were working in your shop, the rules you wrote are pretty easy...
March 6, 2008 at 5:07 am
Ok...when a shopper logs in, what are the key field(s) that are looked at in the "old" table? Also, how long is it currently taking to validate the shopper?
March 6, 2008 at 4:52 am
Thats one of the better ideas, Ralph. It takes 25 ms duration, 15 ms CPU time, and 214 logical reads.
The update method I showed, as long as it looks,...
March 6, 2008 at 4:47 am
My thoughts, exactly... next question would be... when is VARCHAR(MAX) in an "in row" condition? I'm thinking the answer, unlike the TEXT datatype can be forced to be, is...
March 6, 2008 at 4:33 am
Well... maybe a little evil 🙂 It is a good "tie breaker" question.
March 6, 2008 at 4:31 am
That's what "index tuning" is all about... getting the columns in the correct order to produce an Index Seek. Nice job.
March 6, 2008 at 4:20 am
You would use a cursor and while loop instead of a set based solution?
March 6, 2008 at 4:18 am
Whew. Ok... just wanted to make sure.
March 6, 2008 at 4:15 am
Jack Corbett (3/5/2008)
I don't need to intimidate my code, I always do it the best way the first time;)
Mr. Corbett... keep that up an I may have to find some...
March 6, 2008 at 4:15 am
Heh... maybe so but I like that attitude. Why is there always enough time to do it again but never enough time to do it right the first time?...
March 6, 2008 at 4:13 am
newbie (3/5/2008)
As stated previously, my bulk insert sp inserts records into a table from a txt file....
March 6, 2008 at 4:12 am
Viewing 15 posts - 52,066 through 52,080 (of 59,070 total)