sys.dm_query_stats DMV is extended with additional columns to improve supportabilities over troubleshooting long-running queries.

Dynamic Management Views for increased supportability.

You can also find our forums and other support on the Troubleshooting and Support page. For the latest documentation, view SQL Server 2008 R2 Books Online in the MSDN Library. If you have feedback about SQL Server 2008 R2, please submit it at Microsoft SQL Server Connect Feedback Center. The Readme is available on the installation media and from the Readme page.

This Release Notes document is available only online, not on the installation media, and it is updated periodically.įor information about how to get started with installing SQL Server 2008 R2, see the SQL Server 2008 R2 Readme. This Release Notes document and the KB articles supplement SQL Server 2008 R2 Books Online. This document also provides search tips to help you find more known issues in Knowledge Base (KB) articles on the Microsoft Support site for SQL Server 2008 R2. You can download SQL Server 2008 R2 SP1 Express Edition at. You can download SQL Server 2008 R2 Service Pack 1 ( click here to download it ). This Release Notes document describes known issues that you should read about before you install or troubleshoot SQL Server 2008 R2 SP1.

To read the original and official release notes document, click here. Because this is a wiki, additions or refinements to these release notes might have been made by community members. Any changes you make will be evaluated and then quickly accepted, refined, or reverted. December 2015 Preview (equivalent to 2016 CTP 3.This page is carefully and closely monitored.You can download the three latest releases: I haven't tried to manage 2000 from 2016 but the 2012 SP2 release was able to do so. if you need BIDS 2008 or older SSIS packages). You can manage downlevel versions (I currently use the 2016 version to manage 2005, 2008, 2008 R instances) except in rare compatibility scenarios (e.g. 2012 SP2 was the first version that allows you to freely use the fully functional version of Management Studio (rather than the stripped-down Express version, which is missing all kinds of things, including the entire SQL Server Agent node) without any licensing requirements whatsoever. Really you should be using the most recent version of Management Studio.

Download sql server 2008 r2 download