Viewing 15 posts - 2,671 through 2,685 (of 8,416 total)
GilaMonster (9/16/2010)
Combine this and the BIT thread and I'm just about ready to throw in the towel.
What an odd reaction by Mark Enloe (presumably the OP using a different account).
He/she...
September 16, 2010 at 2:50 am
Hugo Kornelis (9/16/2010)
Thanks, Paul, for an excellent series! I rarely give the full five stars to an article (yes, I am criticall), but you have absolutely deserved them.
Fantastic! Thank...
September 16, 2010 at 2:33 am
Matt Whitfield (9/16/2010)
Plus this:
In SQL Server 2005, SHOWOFFRULES displays a list of rules that are ON, and SHOWONRULES displays rules that are OFF, which is actually quite funny.
Just...
September 16, 2010 at 2:30 am
Christian Buettner-167247 (9/16/2010)
September 16, 2010 at 2:29 am
CirquedeSQLeil (9/16/2010)
Paul White NZ (9/16/2010)
September 16, 2010 at 1:04 am
WayneS (9/16/2010)
September 16, 2010 at 12:47 am
The final part of my optimizer series is up today. As expected, the page views have been lower than normal, but it has been good to reach new people...
September 16, 2010 at 12:00 am
dant12 (7/29/2010)
September 15, 2010 at 11:34 pm
Jeff Moden (9/15/2010)
September 15, 2010 at 11:18 pm
Chris Morris-439714 (9/15/2010)
SELECT [No biltong = ] = CAST('Þ¾ï' AS VARBINARY)
Very clever 😎
September 15, 2010 at 11:02 am
paul.knibbs (9/15/2010)
One wonders why they don't call that value Pages Allocated/sec rather than Page Splits/sec!
Both counters exist, but they measure different things 🙂
You may find some of the information and...
September 15, 2010 at 10:47 am
Robert,
I have some (hopefully viewed as constructive) criticisms:
The observed behaviour only applies to clustered tables - heap table inserts never cause page splits. Heap inserts are not counted by...
September 15, 2010 at 10:43 am
Chad Crawford (9/14/2010)
If only you and DEAD people can read Hex, how many people can read Hex?
Don't know. But I do know what an expired hexadecimal cow looks...
September 15, 2010 at 7:56 am
Thanks Wayne and Jason 🙂
September 15, 2010 at 1:23 am
Matt Whitfield (9/14/2010)
Just had a quick look, and [sys].[dm_exec_query_transformation_stats] exists in 2005 SP3 with no CUs (9.00.4035.00).
Thanks Matt. Part 4 is scheduled for Thursday this week, I hope you...
September 14, 2010 at 3:04 am
Viewing 15 posts - 2,671 through 2,685 (of 8,416 total)