Viewing 15 posts - 1 through 15 (of 691 total)
Hope you feel better soon, Ken!!!
July 7, 2020 at 9:00 pm
August 24, 2017 at 3:00 pm
August 23, 2017 at 5:14 pm
For those of you who are interested in this topic, here's a link to a presentation I did at last year's TechEd show:
This presentation discusses a specific CLR aggregate-based technique...
February 5, 2014 at 7:57 am
Great, thanks for the quick reply.
April 22, 2013 at 8:23 am
Unfortunately you're going to have to remove the code for sp_whoisactive from this project.
The license for Who is Active, which is in the header, is as follows:
Who is Active? is...
April 22, 2013 at 8:08 am
Jon.Morisi (12/19/2012)If they're > 5% it's worth looking into. If CXPACKET waits are "the prevalent wait type", there's likely some tuning that can be done.
That's entirely dependent upon workload...
December 19, 2012 at 2:38 pm
Are there any facts or figures I can provide to support or contradict the CXPackets theory?
I'm unsure where to begin though I have sent a couple of rogue...
December 19, 2012 at 1:17 pm
Jon.Morisi (12/19/2012)CXPACKET waits (parallelism) should be addressed if > 5%.
That's a rather specific pronouncement, especially when you don't know anything about the workload in question. What's your logic there?
December 19, 2012 at 1:01 pm
ocolakoglu (2/8/2011)HiWhen i use change data capture can i log hostname,username information?
When i use change data capture can i log hostname,username information?
Simply put: No.
The information is not available, due to the way CDC works.
November 19, 2012 at 8:18 am
October 3, 2012 at 12:24 pm
No more comments on my newer CLR version? That's unfortunate. Where's Florian these days?
Anyway, I just discovered what I consider to be a major issue with CLR TVF based...
October 3, 2012 at 11:12 am
UMG Developer (9/5/2012)
But I can split the split operation into two pieces, one that uses the >4k version and one that uses the <=4k version. I don't know how much...
September 5, 2012 at 2:57 pm
And, going deeper down the rabbit hole... How big are the strings in question?I would say up to 25k characters, but probably averaging closer to 3k.
And, going deeper down the rabbit hole... How big are the strings in question?
I would say up to 25k characters, but probably averaging closer to 3k.
Ah, and there...
September 5, 2012 at 2:46 pm
I have cases where I have a table with ~20 million rows and each row contains a string that needs to be split, so that is a case...
September 5, 2012 at 2:30 pm