Viewing 15 posts - 55,621 through 55,635 (of 59,072 total)
Thanks, Gail ![]()
--Jeff Moden
Change is inevitable... Change for the better is not.
July 27, 2007 at 5:15 pm
Ah... I see what you're getting at...
Yes, in that case, if the inserted row size is greater that than free size remaining on the target page due to a clustered...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 27, 2007 at 5:10 pm
Nah... this one...
One individual had a devil of a good time leading others on just for the sake of a good bar room brawl. I rather enjoyed...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 27, 2007 at 4:24 pm
Cool... thanks, Michael.
Yeah, clearing the cashe didn't seem to matter in my testing so I didn't include it in my code. And, I very much like the idea of using...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 27, 2007 at 4:04 pm
| In other words, who are we to tell someone else the proper way to do their job, especially... |
--Jeff Moden
Change is inevitable... Change for the better is not.
July 27, 2007 at 3:57 pm
Heh... again, I absolutely agree... that makes for some butt ugly
code and I'd personnally never do it that way... Like you, my "Localized...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 27, 2007 at 7:58 am
There is a potential problem in this update... I've seen it lock up servers if parallism is spawned and the indexes are just right... if you need to do a...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 26, 2007 at 11:01 pm
Only one way to find out... test it ![]()
--Jeff Moden
Change is inevitable... Change for the better is not.
July 26, 2007 at 10:51 pm
I'm not sure that's right... lowering the Fill Factor allows more room between items in an index. Having more "room" might also mean that a page may have to split...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 26, 2007 at 10:49 pm
Heh... "What works for them all the time", could break tomorrow...
Then, a new "Localized Best Practice" will be born getting them closer...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 26, 2007 at 10:46 pm
I pull more than a half-million rows from Oracle to SQL using a linked server and an INSERT/SELECT in less than 2 minutes... sure you want to stick with DTS? --Jeff Moden Change is inevitable... Change for the better is not.
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
July 26, 2007 at 10:39 pm
P.S. I'll kindly with-hold the lecture about making such mixed character sequences ![]()
--Jeff Moden
Change is inevitable... Change for the better is not.
July 26, 2007 at 10:32 pm
As much as I love number (Tally) tables, there's absolutely no need for one here... nore is there the need for a bunch of functions, etc. I don't remember where...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 26, 2007 at 10:32 pm
Heh... I agree... but that's not the debate... "It Depends" is not the debate... the debate is "What is the best practice?" and it also seems to be coming "What the...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 26, 2007 at 10:19 pm
Heh... I knew it
... the term "Best Practice" is a bloody Management term
... AND, it...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 26, 2007 at 10:00 pm
Viewing 15 posts - 55,621 through 55,635 (of 59,072 total)