Viewing 15 posts - 48,676 through 48,690 (of 59,065 total)
Shaun McGuile (8/18/2008)
Grant Fritchey (8/18/2008)
No kidding, drop the grenade & run...They could be doing something silly with reseed?
Thats not a grenade its a nuke......:D
COOL! Radioactive pork chops! I'm...
August 18, 2008 at 5:37 pm
Peso (8/18/2008)
Haven't you read Jeff's article yet?There are even some small nice graphs illustrating the each and one scenario with the comparisons above.
Thanks for the plug, Peter...:)
August 18, 2008 at 5:36 pm
Thousands... depends on the requirements of the problem. For example, most folks think you either need a Cursor or Temp Table to do running totals. Sure, there's the...
August 18, 2008 at 5:34 pm
... you did read the article on Triangular Joins, didn't you? That's how you recognize them.
August 18, 2008 at 5:16 pm
karthikeyan (8/18/2008)
That's a ticking time bomb in the face of scalability. It's known as a "Triangular Join" and you need to read about how bad they are...
How to...
August 18, 2008 at 5:15 pm
Like I said, the Tally table is unnecessary here. If you want to make something that will be programmable for this, why are you still referring to the OP's...
August 18, 2008 at 5:09 pm
Left my mindreader hat home... please post your code. 😉
August 18, 2008 at 4:47 pm
karthikeyan (8/18/2008)
And, sorry, the Tally table is not the solution here...
How and why ? Can you explain it ?
Yes... the OP gave us a table with numbers in it and...
August 18, 2008 at 5:20 am
Shaun McGuile (8/18/2008)
From my post before yours Jeff I totally agree.--Shaun
Spot on, Shaun! I missed that... sorry. Good to see I'm not the only one.
Now, if the OP...
August 18, 2008 at 5:14 am
Please don't suggest replacing a cursor with a Temp table and While loop... they're the same thing if you use a read only, forward only cursor. 😉
August 18, 2008 at 5:11 am
Heh... that's 3 different opinions as to what the OP actually wants...
Hey! SQLIndia! Would you mind clarifying what you want, please?
August 18, 2008 at 5:08 am
pleasehelpme (8/17/2008)
how do i extract data from yesterda using replication ? whgat about the format? and i want it to extract to txt files.
bASICally i...
August 18, 2008 at 5:01 am
bluepaperbag (8/15/2008)
I BCP THE tables out + data. Now how can I do incremtanl extract like using changeDate = Yesterday?
Sorry... I didn't read all of the previous posts on this...
August 18, 2008 at 4:57 am
Sure would like it if you'd post your benchmark code.
August 17, 2008 at 9:24 pm
You might also be interested in some of the pitfalls of concatenation code...
August 17, 2008 at 8:52 pm
Viewing 15 posts - 48,676 through 48,690 (of 59,065 total)