Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
Note: Forums will be making significant UX changes to address key usability improvements surrounding search, discoverability and navigation. To learn more about these changes please visit the announcement which can be found HERE.
SQL Server Developer Center >
> 
> 
Query Processing Architecture - SQL Server 2005 Vs 2008

Answered Query Processing Architecture - SQL Server 2005 Vs 2008

  • Friday, January 23, 2009 3:54 PM
     
     
    Sign In to Vote
    0

    Hi,

    1. Are there any changes in query processing architecture in 2008 as compared to SS 2005 ? As i read something about PATITIONED table and INDEXES changes. Other than these, Are there any more changes ?
    2. Are there any improvements OR enhancements in SS 2008 to process the SELECT and DML statements more efficently ? If so then would these changes create any effect on Queries, Stored Procedure and funtions written in SS 2005 ?

    Thanks

     

    Think positive, to see the world more positive. Believe in ONE.
     

All Replies

  • Tuesday, January 27, 2009 12:24 AM
     
     
    Sign In to Vote
    0

    Hello moderator,

    kindly put some light and comment on this topic.

     

    Many thanks.

    Think positive, to see the world more positive. Believe in ONE.
     
  • Tuesday, February 10, 2009 12:47 PM
     
     
    Sign In to Vote
    0
    Getting bored and disappointed about this topic.

    Is there any problem understanding my question then let me know.

    Thanks
    Think positive, to see the world more positive. Believe in ONE.
     
  • Friday, February 13, 2009 12:27 PM
     
     Answered
    Sign In to Vote
    0
    First of all you are in the incorrect forum for this; perhaps the data engine forum is more appropriate. Secondly the answers are more appropriately found via a google search, or checking what's new in Books on Line.

    looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
    • Marked As Answer by iBarNor Friday, March 27, 2009 4:07 PM
    •  
     
  • Friday, January 14, 2011 1:52 AM
     
     
    Sign In to Vote
    0
    First of all you are in the incorrect forum for this; perhaps the data engine forum is more appropriate. Secondly the answers are more appropriately found via a google search, or checking what's new in Books on Line.

    looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

    Thanks for your message! Indeed it's easy to make such mistakes.