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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 4:20 PM
Points: 11,194, Visits: 11,142
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: Thursday, August 14, 2014 8:42 AM
Points: 58, Visits: 277
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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 4:20 PM
Points: 11,194, Visits: 11,142
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: Friday, August 29, 2014 8:18 AM
Points: 3,909, Visits: 3,636
This is an outstanding series, thanks Paul for sharing this information.
Post #987376
Posted Thursday, September 16, 2010 10:33 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Friday, August 29, 2014 1:51 PM
Points: 21,644, Visits: 15,317
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #987434
Posted Tuesday, September 21, 2010 9:23 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 4:20 PM
Points: 11,194, Visits: 11,142
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