Viewing 15 posts - 7,981 through 7,995 (of 8,416 total)
GilaMonster (5/10/2009)
RBarryYoung (5/9/2009)
May 10, 2009 at 4:23 am
Hey James,
Yes it is spreading, but there is some fire-control too:
http://sqlblog.com/blogs/andrew_kelly/archive/2009/05/09/so-the-real-story-is.aspx
It will be interesting to see if Ed does post a correction.
Paul
May 10, 2009 at 4:17 am
Hey Flo!
SOB = son-of-a-b i tch
CYA = cover your a r s e
FUD = fear, uncertainty and doubt
Paul
May 10, 2009 at 4:14 am
Lynn Pettis (5/10/2009)
All I wanted to make sure was that it isn't the BEGIN TRANSACTION (explicit or implicit) that creates any locks.
Sure. BEGIN TRANSACTION doesn't even get logged, much...
May 10, 2009 at 3:23 am
Barry,
All string handling routines should handle any valid input - agreed.
The local-variable and CLR aggregate approaches both do this.
It is only the FOR XML method which fails on...
May 10, 2009 at 3:10 am
James,
Have you read the article at the link I posted?
Paul
May 10, 2009 at 1:50 am
RBarryYoung (5/9/2009)
May 10, 2009 at 1:48 am
Barry,
[Brief comments on the first of your two replies]
Let me avoid the various meanings of 'hack' by calling the use of FOR XML for concatenation an unsatisfactory and ad-hoc work-around.
The...
May 10, 2009 at 1:37 am
Hey Jeff,
Some initial comments:
The version that takes forever includes an index spool in the plan. The modifications you made to the other tally approaches remove that operator. The...
May 9, 2009 at 11:55 pm
Luckily I recognize those acronyms!
Expect questions from Flo 😀
Maybe age has brought patience? I don't hit 40 for another two months so I am still an impetuous youth!
😛
May 9, 2009 at 12:41 pm
RBarryYoung (5/9/2009)
Actually, as far as I can tell, the FOR XML PATH('') trick in fact uses this (or a very similar) method internally and consequently it scales the same: linearly.
I...
May 9, 2009 at 12:38 pm
RBarryYoung (5/9/2009)
Ah yes, been there many times.
I know. It seems to be the same most everywhere. Kinda depressing!
RBarryYoung (5/9/2009)
May 9, 2009 at 12:03 pm
According to this:
http://sqlcat.com/faq/archive/2009/05/08/windows2008-r2-beta-download-runs-smoothly-now.aspx
...this was nothing to do with SQL Server, CPU spikes, page splitting or GUIDs. The site was simply configured for an expected 20% increase in traffic (and...
May 9, 2009 at 11:47 am
Florian Reischl (5/9/2009)
Sorry,
:Whistling: I'm saying nothing.
Florian Reischl (5/9/2009)
TPM is "Technical Project Manager" (people like me) in your company.
We don't have those. We have small teams - an analyst,...
May 9, 2009 at 11:29 am
Viewing 15 posts - 7,981 through 7,995 (of 8,416 total)