Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Inside the Optimizer: Constructing a Plan - Part 4 Expand / Collapse
Author
Message
Posted Thursday, September 16, 2010 8:33 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 4:51 AM
Points: 9,928, Visits: 11,199
Christian Buettner-167247 (9/16/2010)
In general I assume there is no single source of information, just lots of experience & knowledge built over the years, and a lot of exploration to build that knowledge over time.

That's a pretty fair assessment.

Or do you just have some really good contacts with MS?

Sadly, no.




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #987303
Posted Thursday, September 16, 2010 8:45 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 2:32 AM
Points: 60, Visits: 309
Excellent and very throught provoking series.

Do we think the mix up of RULEOFF/RULEON in SQL 2005 was a deliberate ploy or purely accidental by the MS developers?

Post #987310
Posted Thursday, September 16, 2010 8:49 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 4:51 AM
Points: 9,928, Visits: 11,199
Lawrence Moore (9/16/2010)
Do we think the mix up of RULEOFF/RULEON in SQL 2005 was a deliberate ploy or purely accidental by the MS developers?

It's usually safe to assume cock-up over conspiracy




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #987315
Posted Thursday, September 16, 2010 9:48 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, November 10, 2014 12:05 PM
Points: 3,969, Visits: 3,648
This is an outstanding series, thanks Paul for sharing this information.
Post #987376
Posted Thursday, September 16, 2010 10:33 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 9:21 AM
Points: 17,977, Visits: 15,981
Matt Whitfield (9/16/2010)
Awesome, just awesome.

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 made my day!


Agreed - quite funny.

ShowOffsRule




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #987434
Posted Tuesday, September 21, 2010 9:23 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 4:51 AM
Points: 9,928, Visits: 11,199
Cliff Jones (9/16/2010)
This is an outstanding series, thanks Paul for sharing this information.

Thank you very much, Cliff.




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #990428
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse