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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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