Viewing 15 posts - 1,411 through 1,425 (of 5,590 total)
The .dtsx files are XML (aka formatted text), so you could do a bulk import into a varchar(max) column, and then do a like comparing the proc names to that...
May 5, 2011 at 2:01 pm
Can you post the deadlock graph? It will be xml, starting with "<deadlock"...
May 5, 2011 at 7:13 am
Jeff Moden (5/4/2011)
Oh... and the dust bunnies said they made a new batch and it's in the freezer as we speak. Gotta love courteous dust bunnies. 😀
They said that,...
May 4, 2011 at 10:08 pm
Jeff Moden (5/4/2011)
Nicely done, Nadrek!
Yes indeed, very nice!
The cool part about all of this is if you run into a DBA that won't allow auxiliary tables such as a...
May 4, 2011 at 9:42 pm
Jeff Moden (5/4/2011)
May 4, 2011 at 9:39 pm
Jeff Moden (5/3/2011)
What I find really strange is why do people wait until I write an article to bring these wonders forward? 😛
To go along with this... where were...
May 4, 2011 at 8:26 pm
Nadrek (5/4/2011)
Results below. Wayne, for the very largest case, yours looks only very slightly faster than the article's code.
Well, it was worth a shot. At least we know now...
May 4, 2011 at 2:22 pm
Roy Ernest (5/4/2011)
Jeff Moden (5/3/2011)
Roy Ernest (5/3/2011)
As usual, great post Jeff. Five star article.. 🙂
Thanks, Roy. I appreciate you stopping by. How are you doing after that last...
May 4, 2011 at 8:37 am
Nadrek (5/3/2011)
May 4, 2011 at 8:35 am
Jeff Moden (5/3/2011)
What I find really strange is why do people wait until I write an article to bring these wonders forward? 😛
Maybe they want to hear about you...
May 4, 2011 at 8:13 am
GilaMonster (5/4/2011)
Grant Fritchey (5/4/2011)
May 4, 2011 at 8:06 am
Jeff Moden (5/3/2011)
mtassin (5/3/2011)
WayneS (5/3/2011)
ChrisM@home (5/3/2011)
Jeff, please please please write a book, without changing your style. Give us all an opportunity to repay you for what you've done for us.
+10!
Yes,...
May 3, 2011 at 5:18 pm
Jeff Moden (5/3/2011)
WayneS (5/3/2011)
Here's the results that I have. The "DemilitedSplit8Kpt" is the new DelimitedSplit8K function, with a permanent tally table.
It's true... a picture IS worth a thousand words. ...
May 3, 2011 at 5:17 pm
Nadrek (5/3/2011)
WayneS (5/3/2011)
May 3, 2011 at 5:13 pm
Viewing 15 posts - 1,411 through 1,425 (of 5,590 total)