<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Paul White
»
Inside the Optimizer: Constructing a Plan -...
16 posts, Page 1 of 2
1
2
»»
Inside the Optimizer: Constructing a Plan - Part 4
Rate Topic
Display Mode
Topic Options
Author
Message
Paul White
Paul White
Posted Wednesday, September 15, 2010 10:49 PM
SSChampion
Group: General Forum Members
Last Login: Today @ 1:03 AM
Points: 10,990,
Visits: 10,543
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
Hugo Kornelis
Hugo Kornelis
Posted Thursday, September 16, 2010 1:13 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 3:21 AM
Points: 5,244,
Visits: 7,062
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
Matt Whitfield
Matt Whitfield
Posted Thursday, September 16, 2010 2:14 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Friday, February 15, 2013 7:29 AM
Points: 509,
Visits: 718
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
Christian Buettner-167247
Christian Buettner-167247
Posted Thursday, September 16, 2010 2:14 AM
SSCrazy
Group: General Forum Members
Last Login: 2 days ago @ 6:12 AM
Points: 2,526,
Visits: 3,620
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
Paul White
Paul White
Posted Thursday, September 16, 2010 2:29 AM
SSChampion
Group: General Forum Members
Last Login: Today @ 1:03 AM
Points: 10,990,
Visits: 10,543
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
Paul White
Paul White
Posted Thursday, September 16, 2010 2:30 AM
SSChampion
Group: General Forum Members
Last Login: Today @ 1:03 AM
Points: 10,990,
Visits: 10,543
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
Paul White
Paul White
Posted Thursday, September 16, 2010 2:33 AM
SSChampion
Group: General Forum Members
Last Login: Today @ 1:03 AM
Points: 10,990,
Visits: 10,543
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
TheSQLGuru
TheSQLGuru
Posted Thursday, September 16, 2010 7:48 AM
Hall of Fame
Group: General Forum Members
Last Login: Yesterday @ 12:01 PM
Points: 3,582,
Visits: 5,130
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
Paul White
Paul White
Posted Thursday, September 16, 2010 8:01 AM
SSChampion
Group: General Forum Members
Last Login: Today @ 1:03 AM
Points: 10,990,
Visits: 10,543
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
Christian Buettner-167247
Christian Buettner-167247
Posted Thursday, September 16, 2010 8:11 AM
SSCrazy
Group: General Forum Members
Last Login: 2 days ago @ 6:12 AM
Points: 2,526,
Visits: 3,620
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 »
16 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
