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 Wednesday, September 15, 2010 10:49 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Monday, September 29, 2014 10:07 PM
Points: 9,926, Visits: 11,183
Comments posted to this topic are about the item Inside the Optimizer: Constructing a Plan - Part 4

Link to Part 1
Link to Part 2
Link to Part 3




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #986904
Posted Thursday, September 16, 2010 1:13 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:48 PM
Points: 6,021, Visits: 8,290
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.

I don't think I'll ever want to actually disable any optimizer rules - but as you said at the end of the article, a better understanding of internals helps me become a better SQL Server professional.



Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #986969
Posted Thursday, September 16, 2010 2:14 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, July 22, 2013 11:59 AM
Points: 477, Visits: 719
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!


Atlantis Interactive - SQL Server Tools
My blog
Why I wrote a sql query analyzer clone
Post #987010
Posted Thursday, September 16, 2010 2:14 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 1:05 AM
Points: 2,842, Visits: 3,875
This is really great stuff... As already mentioned a few times by others, 5 stars aint enough for this series...

Edit: The link back to the article from the forum actually points to part 3 of the series and not part 4.


Best Regards,
Chris Büttner
Post #987011
Posted Thursday, September 16, 2010 2:29 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Monday, September 29, 2014 10:07 PM
Points: 9,926, Visits: 11,183
Christian Buettner-167247 (9/16/2010)
This is really great stuff... As already mentioned a few times by others, 5 stars aint enough for this series...Edit: The link back to the article from the forum actually points to part 3 of the series and not part 4.

Fixed the link! Thank you for the kind words too.




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #987021
Posted Thursday, September 16, 2010 2:30 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Monday, September 29, 2014 10:07 PM
Points: 9,926, Visits: 11,183
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!

Yep it still makes me smile




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #987022
Posted Thursday, September 16, 2010 2:33 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Monday, September 29, 2014 10:07 PM
Points: 9,926, Visits: 11,183
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 you. BTW Steve Jones encouraged me to post these articles on SSC - you can find the originals on my blog, together with some other optimizer-related stuff people might find interesting...or not!

I don't think I'll ever want to actually disable any optimizer rules - but as you said at the end of the article, a better understanding of internals helps me become a better SQL Server professional.

Precisely.




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #987025
Posted Thursday, September 16, 2010 7:48 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 1:11 PM
Points: 4,368, Visits: 6,208
From whence did you acquire this information Paul? Neat stuff!

Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #987260
Posted Thursday, September 16, 2010 8:01 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Monday, September 29, 2014 10:07 PM
Points: 9,926, Visits: 11,183
TheSQLGuru (9/16/2010)
From whence did you acquire this information Paul? Neat stuff!

Hey Kevin,

The four parts cover a lot of ground - did you have a particular piece of information in mind?

Paul




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #987273
Posted Thursday, September 16, 2010 8:11 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 1:05 AM
Points: 2,842, Visits: 3,875
You already told us, you stole from your own blog :P

But as an honest guess, I think you were just exploring SQL Server, and eventually found the DMV for the rules. Of course one important piece of information is the DBCC command list, maybe you got that from http://www.novicksoftware.com/tipsandtricks/tip-sql-dbcc-help.htm or just from http://msdn.microsoft.com/en-us/library/ms176040.aspx.
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.

Or do you just have some really good contacts with MS?
I am curious :)


Best Regards,
Chris Büttner
Post #987284
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse