January 11, 2008 at 9:09 am
Has anyone seen any blog entries or white papers documenting any fundamental change to the way 2008 processes queries?
I mean, is it still split into the relational engine and the storage engine? Does the relational engine still use the parser then the algebrizer then the optimizer?
I know there have been optimizations to deal with spatial data types among other things, but I was wondering if the core process was still basicall the same.
----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore Roosevelt
The Scary DBA Author of: SQL Server 2022 Query Performance Tuning, 6th Edition and SQL Server Execution Plans, 3rd Edition
Product Evangelist for Red Gate Software
January 11, 2008 at 11:27 am
You could try Paul Randal's blog: http://www.sqlskills.com/blogs/paul/ Might well be something there.
The impression I've got is that 2008 is a very small change, compared to 6.5-7 or 2000-2005
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 11, 2008 at 11:42 am
Thanks. His blog seems to be offline right now. I'll check on it later.
I understood that there were few if any fundamental changes, but I just wanted the chance to confirm. Thanks again.
----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore Roosevelt
The Scary DBA Author of: SQL Server 2022 Query Performance Tuning, 6th Edition and SQL Server Execution Plans, 3rd Edition
Product Evangelist for Red Gate Software
January 12, 2008 at 9:57 pm
I haven't seen much in my list of blogs (50-60) that I check. There are some good entries with Craig Freedman, but seems to be 2005.
I don't think there are a lot of 2008 changes in this area. It seems like more they've bolted on more things, like DMF, processor limits, etc.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
January 13, 2008 at 4:23 am
Excellent. Thanks Steve.
----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore Roosevelt
The Scary DBA Author of: SQL Server 2022 Query Performance Tuning, 6th Edition and SQL Server Execution Plans, 3rd Edition
Product Evangelist for Red Gate Software
January 26, 2008 at 4:18 pm
There are no changes in this area in SS2008.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply