Viewing 15 posts - 53,206 through 53,220 (of 59,068 total)
-- Plz close this post
First, thank you very much for posting your hard earned solution... that's what this forum is all about.
The only problem that I see with your solution...
January 1, 2008 at 8:58 am
I've found that the single best improvement you can make in this area is to find and remove all hidden RBAR... "touch" each row only once, if possible, and as...
January 1, 2008 at 8:48 am
Another great summary! Great work, Gail.
January 1, 2008 at 8:43 am
Yes, but you need to do it through "OSQL". Lookup "OSQL" in Books Online for full details about usage.
January 1, 2008 at 8:40 am
Nice blog, Gail...great explanations!
January 1, 2008 at 8:39 am
I'll say, "it depends"...
If I'm looking to hire an "entry level" developer, there may be little or no experience to go on in which case education (math background preferred)...
January 1, 2008 at 8:27 am
Still, ya gotta admit, Phil... that's 5 times faster... if you make those types of small improvements in many areas of a whole batch that makes multiple passes on a...
January 1, 2008 at 8:18 am
Heh... thanks Mike, but you didn't read the code block just before the conclusion 😉 Like Ragu... "It's in there". 😀
January 1, 2008 at 12:08 am
Thanks, Chirag. Appreciate the compliment!
December 31, 2007 at 10:40 pm
What a great way to start the year! Thank you for the awesome compliments, Paul!
December 31, 2007 at 10:09 pm
Jason! Hey! How's the new job???
I'll bet I know why he wants it... it's probably to find missing ID's in a table. My first reaction would be...
December 31, 2007 at 7:32 pm
Are you after the gaps in the EmpNo column?
That's what I want to know...
December 31, 2007 at 2:18 pm
Why on Earth would you want to generate a Billion sequential numbers? That will take 8 gigabytes of space all by itself... it is not practical to do such...
December 31, 2007 at 2:12 pm
True enough. Just listing options, Adam...
December 31, 2007 at 2:07 pm
You are correct... makes no significant difference if you only use it once at the beginning of a sproc... unless the sproc is being called millions of times a day...
December 31, 2007 at 2:01 pm
Viewing 15 posts - 53,206 through 53,220 (of 59,068 total)