Viewing 15 posts - 1 through 15 (of 691 total)
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:
http://channel9.msdn.com/Events/TechEd/NorthAmerica/2013/DBI-B404
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
All,
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
kiffab (12/19/2012)
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?
Simply put: No.
The information is not available, due to the way CDC works.
November 19, 2012 at 8:18 am
RBarryYoung (10/3/2012)
October 3, 2012 at 12:24 pm
Hi all,
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
UMG Developer (9/5/2012)
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
UMG Developer (9/5/2012)
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
Viewing 15 posts - 1 through 15 (of 691 total)