Viewing 15 posts - 33,826 through 33,840 (of 59,102 total)
Roy Ernest (5/27/2011)
I had a great time hanging around with...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 28, 2011 at 10:03 pm
Steve Jones - SSC Editor (5/27/2011)
Now we got the $27k Prius in '07, but got a $1500 tax credit and saved a ton of gas.
What did it do to your...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 28, 2011 at 10:01 pm
I don't know for sure but I'd almost bet the number of reads and writes being different from run to run are because I'm writing to disk and SQL Server...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 28, 2011 at 9:54 pm
Here's the profiler run between my and Wayne's code on my old box. I guess I'm going to have to try it on a more modern machine and see...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 28, 2011 at 12:57 pm
Your modification worked a real treat, Wayne... it used to take almost 7 mimutes for your previous code to run against the test data on my box. Now, it...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 28, 2011 at 12:37 pm
pete.griffiths (5/27/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
May 27, 2011 at 11:28 pm
Sorry... duplicate post removed.
--Jeff Moden
Change is inevitable... Change for the better is not.
May 27, 2011 at 11:18 pm
David Kuhl (5/27/2011)
battelofhalfwits (1/1/2009)
Two things
1) Never use Cursors! Looping through a temp table takes less overhead than a Cursor; especially when you are working on a 24/7/365 server where...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 27, 2011 at 11:15 pm
Not that it helps in the way you'd like, but the original code seems to work fine in SQL Server 2005, as well. Here's the first 20 rows...
HEADS
TAILS
HEADS
HEADS
HEADS
HEADS
HEADS
HEADS
HEADS
TAILS
HEADS
TAILS
HEADS
HEADS
HEADS
TAILS
HEADS
HEADS
HEADS
HEADS
If I...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 27, 2011 at 9:58 pm
jarid.lawson (5/27/2011)
Declare @TableName Varchar(128),
@FieldName...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 27, 2011 at 9:51 pm
Gosh, this one sounds a whole lot like homework, a test, or an interview question. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
May 27, 2011 at 9:31 pm
WayneS (5/27/2011)
Sean Lange (5/27/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
May 27, 2011 at 8:46 pm
As a bit of a sidebar, there IS a problem with CTE's which are really just "inline views". Sometimes there's a little "positive feedback" formed by CTE's and you...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 27, 2011 at 8:42 pm
While we're waiting for Ruban to actually show up for his own post, I went ahead and made the assumption that the table with the "duped names" actually does have...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 27, 2011 at 8:37 pm
Jeff Moden (5/27/2011)
Rani-434268 (5/26/2011)
Ex.
1. Dr Vasudev Narasima MD Vasudev Narasima MBBS
output
Dr...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 27, 2011 at 7:08 pm
Viewing 15 posts - 33,826 through 33,840 (of 59,102 total)