I recently come across very interesting white paper written for Microsoft by Solid Quality Mentors. A successful upgrade to SQL Server 2008 R2 should be smooth and trouble-free. To do that smooth transition, you must plan sufficiently for the upgrade and match the complexity of your database application. Otherwise, you risk costly and stressful errors and upgrade problems.
SQL Server 2008 R2 Upgrade Technical Reference Guide is one of the best and comprehensive reference guide I have seen on the subject of SQL Server 2008 R2 upgrade. There are so many various subjects discussed about upgrade which one would always wanted to see.
You can find the link of why one has to upgrade to SQL Server 2008 R2 over here: Why upgrade to SQL Server 2008 R2.
White paper to upgrade to SQL Server 2008 R2 Upgrade Guide.
Here is the quick list of content of the white paper.
1. Upgrade Planning and Deployment
2. Management and Development Tools
3. Relational Databases
4. High Availability
5. Database Security
6. Full-Text Search
7. Service Broker
8. Transact-SQL Queries
9. Notification Services
10. SQL Server Express
11. Analysis Services
12. Data Mining
13. Integration Services
14. Reporting Services
15. Other Microsoft Applications and Platforms
Appendix 1: Version and Edition Upgrade Paths
Appendix 2: Upgrade Planning Deployment and Tasks Checklist
This white paper is indeed huge with 490 pages and 151,956 words.As I said, this is one of the most comprehensive white paper ever published on the subject. Just reading this white paper one can learn a lot about SQL Server.
Reference: Pinal Dave (https://blog.sqlauthority.com)
4 Comments. Leave new
Hai Pinal,
Nice article…!I have come across one question during an interview.The question is can u allocate some specific memory to a particular Query.How can we achieve this?
Regards
varun R
Hi Varun,
For SQL 2005 and onwards:
In general option “min memory per query”, under sys.configurations can be used to allocate the minimum memory allocated per query.
For SQL 2008 and Onwards a new feature is introduced called as Resource Governor. You can read further on “http://technet.microsoft.com/en-us/library/bb895232.aspx”. Through this resources can be governed and allocated as per the requirement.
I hope this helps as starting point for you.
Regards,
Animesh
Hi Pinal,
Wanted a little info. Actually we upgraded SQL Server 2005 to SQL Server 2008 R2. The new instance is working fine, but the older instance is still there. Do we need to manually uninstall the 2005 instance. Kindly mention the things to keep in mind while doing this.
Regards,
Raj
Hi Pinal,
I am trying to upgrade SQL server 2008R2 to SQL server 2012 and before doing that I ran SQL server 2012 upgrade advisor on the server in order to fix things in 2008r2 before the upgrade.
In the upgrade report I am getting an error with respect to SQL server i.e.”User defined CLR objects have been detected. These objects may function differently in CLR version 4.0 when the database compatibility level is raised to 110.”
Could you please let me know how do I fix this issue before the upgrade.
Regards,
Anu