Skip to content
May 22, 2013

Database index design and optimization: Some guidelines

Well-designed indexes are an important part of database optimization because they are the key factor in achieving optimal query performance and response time. In the meantime, poorly designed indexes, such as missing or excessive indexes on tables, indexes placed on the wrong column or inadequate index maintenance strategies, can be a source of impaired query and database performance.

Checkout my article here, in which I shared I some guidelines, which you can follow to make indexes more effective, and improve performance during the creation, implementation and maintenance of indexes.

This article is published on SearchSQLServer.techtarget.com.

Leave a Comment
May 22, 2013

SQL Server Transactions and Locking (Part 1)

In many situations, data modification requires several steps. For example, you may need to change the values ​​in two separate tables. You can use transactions to complete these two operations as a unit, or if an error occurs, does not change any of the tables. Another key consideration is that most databases must be compatible with many operations simultaneously. You have several options to configure how data is locked while it is being modified by a user.

Checkout the part-1 of my two part article series on SQL Server Transactions and Locking here, in which you will learn fundamentals about SQL Server transactions, how they work and how to manage them, and how to write procedures that use SQL Server transactions.

This article is published on SQL-SERVER-PERFORMANCE.COM.

Leave a Comment
May 22, 2013

Designing and Implementing Online Analytical Processing (OLAP) Architecture (Part 1)

The well-designed online analytical processing (OLAP) solution is fundamental to organizations analysis capabilities. That is why, when designing the OLAP solution for your organization, you must ensure that the components of your OLAP solution, including relational data warehouse databases and multidimensional cubes, are designed to meet the business needs of your organization, and provide a solution to users that allows them to locate and analyze the information effectively.

Checkout the part-1 of my two part article series on Designing and Implementing Online Analytical Processing (OLAP) Architecture here, you will learn OLAP database design, options for data warehouse schema design, and key considerations for designing relational data warehouse schema for OLAP applications.

This article is published on SSWUG.org.

Leave a Comment
May 22, 2013

SQL Server index related dynamic management views and functions (Part 3)

With the release of SQL Server 2005 and later releases, Microsoft introduced set of new dynamic management view and function that helps database administrators (DBA) and developers to identify potential index candidates based on query history.

Checkout the part-3 of my three part article series on index-related dynamic management views and function here, in which I discussed these index-related dynamic management views (DMVs), which are useful to identify potential indexes for your queries based representative server activity.

This article is published on SSWUG.org.

Leave a Comment
May 22, 2013

Microsoft SQL Server 2008 Builds (Last Updated May 20, 2013)

The following table lists all builds of SQL Server 2008 known hotfixes, service packs and KB articles that have been released by Microsoft.

Quick Overview:

 Codename RTM/Service Pack Build Number
 Katmai RTM 10.00.1600.22
SP1 10.00.2531
SP2 10.00.4000
SP3 10.00.5500

Microsoft SQL Server 2008 Builds Breakdown:

Build File version KB / Description Release Date
10.00.5840 2007.100.5840.0 2834048 Cumulative update package 11 (CU11) for SQL Server 2008 Service Pack 3 May 20, 2013
10.00.5835 2007.100.5835.0 2814783 Cumulative update package 10 (CU10) for SQL Server 2008 Service Pack 3 March 18, 2013
10.00.5829 2007.100.5829.0 2799883 Cumulative update package 9 (CU9) for SQL Server 2008 Service Pack 3 January 23, 2013
10.00.5828 2007.100.5828.0 2771833 Cumulative update package 8 (CU8) for SQL Server 2008 Service Pack 3 November 19, 2012
10.00.5826 2007.100.5826.0 2716435 Microsoft Security Bulletin MS12-070 October 9, 2012
10.00.5794 2007.100.5794.0 2738350 Cumulative update package 7 (CU7) for SQL Server 2008 Service Pack 3 September 21, 2012
10.00.5788 2007.100.5788.0 2715953 Cumulative update package 6 (CU6) for SQL Server 2008 Service Pack 3 July 16, 2012
10.00.5785 2007.100.5785.0 2696626 Cumulative update package 5 (CU5) for SQL Server 2008 Service Pack 3 May 19, 2012
10.00.5775 2007.100.5775.0 2673383 Cumulative update package 4 (CU4) for SQL Server 2008 Service Pack 3 March 20, 2012
10.00.5770 2007.100.5770.0 2648098 Cumulative update package 3 (CU3) for SQL Server 2008 Service Pack 3 January 16, 2012
10.00.5768 2007.100.5768.0 2633143 Cumulative update package 2 (CU2) for SQL Server 2008 Service Pack 3 November 22, 2011
10.00.5766 2007.100.5766.0 2617146 Cumulative update package 1 (CU1) for SQL Server 2008 Service Pack 3 October 18, 2011
10.00.5512 2007.100.5512.0 Microsoft Security Bulletin MS12-070 October 9, 2012
10.00.5500 2007.100.5500.0 SQL Server 2008 Service Pack 3 (SP3) October 6, 2011
10.00.5416 2007.100.5416.0 SQL Server 2008 Service Pack 3 CTP August 22, 2011
10.00.4371 2007.100.4371.0 Microsoft Security Bulletin MS12-070 October 9, 2012
10.00.4333 2007.100.4333.0 2715951 Cumulative update package 11 (CU11) for SQL Server 2008 Service Pack 2 July 16, 2012
10.00.4332 2007.100.4332.0 2696625 Cumulative update package 10 (CU10) for SQL Server 2008 Service Pack 2 May 20, 2012
10.00.4330 2007.100.4330.0 2673382 Cumulative update package 9 (CU9) for SQL Server 2008 Service Pack 2 March 19, 2012
10.00.4326 2007.100.4326.0 2648096 Cumulative update package 8 (CU8) for SQL Server 2008 Service Pack 2 January 30, 2012
10.00.4323 2007.100.4323.0 2617148 Cumulative update package 7 (CU7) for SQL Server 2008 Service Pack 2 November 21, 2011
10.00.4321 2007.100.4321.0 2582285 Cumulative update package 6 (CU6) for SQL Server 2008 Service Pack 2 September 20, 2011
10.00.4316 2007.100.4316.0 2555408 Cumulative update package 5 (CU5) for SQL Server 2008 Service Pack 2 July 18, 2011
10.00.4285 2007.100.4285.0 2527180 Cumulative update package 4 (CU4) for SQL Server 2008 Service Pack 2 May 16, 2011
10.00.4279 2007.100.4279.0 2498535 Cumulative update package 3 (CU3) for SQL Server 2008 Service Pack 2 March 11, 2011
10.00.4272 2007.100.4272.0 2467239 Cumulative update package 2 (CU2) for SQL Server 2008 Service Pack 2 February 10, 2011
10.00.4266 2007.100.4266.0 2289254 Cumulative update package 1 (CU1) for SQL Server 2008 Service Pack 2 November 15, 2010
10.00.4067 2007.100.4067.0 Microsoft Security Bulletin MS12-070 October 9, 2012
10.00.4064 2007.100.4064.0 2494089 MS11-049: Description of the security update for SQL Server 2008 Service Pack 2 GDR: June 14, 2011 June 14, 2011
10.00.4000 2007.100.4000.0 SQL Server 2008 Service Pack 2 (SP2) September 29, 2010
10.00.3798 2007.100.3798.0 SQL Server 2008 Service Pack 2 CTP July 7, 2010
10.00.2850 2007.100.2850.0 2582282 Cumulative update package 16 (CU16) for SQL Server 2008 Service Pack 1 September 19, 2011
10.00.2847 2007.100.2847.0 2555406 Cumulative update package 15 (CU15) for SQL Server 2008 Service Pack 1 July 18, 2011
10.00.2821 2007.100.2821.0 2527187 Cumulative update package 14 (CU14) for SQL Server 2008 Service Pack 1 May 16, 2011
10.00.2816 2007.100.2816.0 2497673 Cumulative update package 13 (CU13) for SQL Server 2008 Service Pack 1 March 22, 2011
10.00.2808 2007.100.2808.0 2467236 Cumulative update package 12 (CU12) for SQL Server 2008 Service Pack 1 February 10, 2011
10.00.2804 2007.100.2804.0 2413738 Cumulative update package 11 (CU11) for SQL Server 2008 Service Pack 1 November 15, 2010
10.00.2799 2007.100.2799.0 2279604 Cumulative update package 10 (CU10) for SQL Server 2008 Service Pack 1 September 21, 2010
10.00.2789 2007.100.2789.0 2083921 Cumulative update package 9 (CU9) for SQL Server 2008 Service Pack 1 July 21, 2010
10.00.2787 2007.100.2787.0 2231277 FIX: The Reporting Services service stops unexpectedly after you apply SQL Server 2008 SP1 CU 7 or CU8 July 30, 2010
10.00.2775 2007.100.2775.0 981702 Cumulative update package 8 (CU8) for SQL Server 2008 Service Pack 1 May 17, 2010
10.00.2766 2007.100.2766.0 979065 Cumulative update package 7 (CU7) for SQL Server 2008 Service Pack 1 March 26, 2010
10.00.2757 2007.100.2757.0 977443 Cumulative update package 6 (CU6) for SQL Server 2008 Service Pack 1 January 18, 2010
10.00.2746 2007.100.2746.0 975977 Cumulative update package 5 (CU5) for SQL Server 2008 Service Pack 1 November 16, 2009
10.00.2740 2007.100.2740.0 976761 FIX: Error message when you perform a rolling upgrade in a SQL Server 2008 cluster : “18401, Login failed for user SQLTEST\AgentService. Reason: Server is in script upgrade mode. Only administrator can connect at this time.[SQLState 42000]“ November 24, 2009
10.00.2734 2007.100.2734.0 973602 Cumulative update package 4 (CU4) for SQL Server 2008 Service Pack 1 September 22, 2009
10.00.2723 2007.100.2723.0 971491 Cumulative update package 3 (CU3) for SQL Server 2008 Service Pack 1 July 21, 2009
10.00.2714 2007.100.2714.0 970315 Cumulative update package 2 (CU2) for SQL Server 2008 Service Pack 1 May 18, 2009
10.00.2712 2007.100.2712.0 970507 FIX: Error message in SQL Server 2008 when you run an INSERT SELECT statement on a table: “Violation of PRIMARY KEY constraint ‘<PrimaryKey>’. Cannot insert duplicate key in object ‘<TableName>’” July 21, 2009
10.00.2710 2007.100.2710.0 969099 Cumulative update package 1 (CU1) for SQL Server 2008 Service Pack 1 April 16, 2009
10.00.2573 2007.100.2573.0 2494096 MS11-049: Description of the security update for SQL Server 2008 Service Pack 1 GDR: June 14, 2011 June 14, 2011
10.00.2531 2007.100.2531.0 SQL Server 2008 Service Pack 1 (SP1) April 7, 2009
10.00.2520 2007.100.2520.0 SQL Server 2008 Service Pack 1 – CTP February 23, 2009
10.00.1835 2007.100.1835.0 979064 Cumulative update package 10 (CU10) for SQL Server 2008 March 15, 2010
10.00.1828 2007.100.1828.0 977444 Cumulative update package 9 (CU9) for SQL Server 2008 January 18, 2010
10.00.1823 2007.100.1823.0 975976 Cumulative update package 8 (CU8) for SQL Server 2008 November 16, 2009
10.00.1818 2007.100.1818.0 973601 Cumulative update package 7 (CU7) for SQL Server 2008 September 21, 2009
10.00.1812 2007.100.1812.0 971490 Cumulative update package 6 (CU6) for SQL Server 2008 July 21, 2009
10.00.1806 2007.100.1806.0 969531 Cumulative update package 5 (CU5) for SQL Server 2008 May 18, 2009
10.00.1798 2007.100.1798.0 963036 Cumulative update package 4 (CU4) for SQL Server 2008 March 17, 2009
10.00.1787 2007.100.1787.0 960484 Cumulative update package 3 (CU3) for SQL Server 2008 January 19, 2009
10.00.1779 2007.100.1779.0 958186 Cumulative update package 2 (CU2) for SQL Server 2008 November 19, 2008
10.00.1771 2007.100.1771.0 958611 FIX: You may receive incorrect results when you run a query that references three or more tables in the FROM clause in SQL Server 2008 October 29, 2008
10.00.1763 2007.100.1763.0 956717 Cumulative update package 1 (CU1) for SQL Server 2008 October 28, 2008
10.00.1750 2007.100.1750.0 956718 FIX: A MERGE statement may not enforce a foreign key constraint when the statement updates a unique key column that is not part of a clustering key that has a single row as the update source in SQL Server 2008 August 25, 2008
10.00.1600 2007.100.1600.22 SQL Server 2008 RTM August 7, 2008
10.00.1442 2007.100.1442.32 Microsoft SQL Server 2008 RC0 June 5, 2008
10.00.1300 2007.100.1300.13 Microsoft SQL Server 2008 CTP, February 2008 February 19, 2008
10.00.1075 2007.100.1075.23 Microsoft SQL Server 2008 CTP, November 2007 November 18, 2007
10.00.1049 2007.100.1049.14 SQL Server 2008 CTP, July 2007 July 31, 2007
10.00.1019 2007.100.1019.17 SQL Server 2008 CTP, June 2007 May 21, 2007

Note: RTM stands for release to market edition, which is the first supported version of SQL Server 2008, and SP stands for service pack. All SQL Server service packs and hotfixes are cumulative, meaning that each new service pack and hotfixes contains all the fixes that are included with previous service packs, hotfixes and new fixes issues.

Please use comment section, if you find build that is not listed here.

Leave a Comment
May 8, 2013

Microsoft SQL Server 2012 Builds

The following table lists all builds of SQL Server 2012 known hotfixes, service packs and KB articles that have been released by Microsoft.

Quick Overview:

 Codename RTM/Service Pack Build Number
Denali RTM 11.00.2100.60
  SP1 11.00.3000

Microsoft SQL Server 2012 Builds Breakdown:

 
Build File version KB / Description Release Date
11.00.9000 2011.110.9000.5 Microsoft SQL Server 2012 With Power View For Multidimensional Models Customer Technology Preview (CTP3) November 27, 2012
11.00.3350 2011.110.3350.0 2832017 FIX: You can’t create or open SSIS projects or maintenance plans after you apply Cumulative Update 3 for SQL Server 2012 SP1 April 17, 2013 *new
11.00.3349 2011.110.3349.0 2812412 Cumulative update package 3 (CU3) for SQL Server 2012 Service Pack 1 March 18, 2013
11.00.3339 2011.110.3339.0 2790947 Cumulative update package 2 (CU2) for SQL Server 2012 Service Pack 1 January 25, 2013
11.00.3335 2011.110.3335.0 2800050 FIX: Component installation process fails after you install SQL Server 2012 SP1 January 14, 2013
11.00.3321 2011.110.3321.0 2765331 Cumulative update package 1 (CU1) for SQL Server 2012 Service Pack 1 November 20, 2012
11.00.3128 2011.110.3128.0 2793634 Windows Installer starts repeatedly after you install SQL Server 2012 SP1 January 3, 2013
11.00.3000 2011.110.3000.0 SQL Server 2012 Service Pack 1 (SP1) November 6, 2012
11.00.2845 2011.110.2845.0 SQL Server 2012 Service Pack 1 Customer Technology Preview 4 (CTP4) September 20, 2012
11.00.2809 2011.110.2809.24 SQL Server 2012 Service Pack 1 Customer Technology Preview 3 (CTP3) July 5, 2012
11.00.2405 2011.110.2405.0 2823247 Cumulative update package 7 (CU7) for SQL Server 2012 April 15, 2013 *new
11.00.2401 2011.110.2401.0 2728897 Cumulative update package 6 (CU6) for SQL Server 2012 February 18, 2013
11.00.2395 2011.110.2395.0 2777772 Cumulative update package 5 (CU5) for SQL Server 2012 December 18, 2012
11.00.2383 2011.110.2383.0 2758687 Cumulative update package 4 (CU4) for SQL Server 2012 October 18, 2012
11.00.2376 2011.110.2376.0 Microsoft Security Bulletin MS12-070 October 9, 2012
11.00.2332 2011.110.2332.0 2723749 Cumulative update package 3 (CU3) for SQL Server 2012 August 29, 2012
11.00.2325 2011.110.2325.0 2703275 Cumulative update package 2 (CU2) for SQL Server 2012 June 18, 2012
11.00.2316 2011.110.2316.0 2679368 Cumulative update package 1 (CU1) for SQL Server 2012 April 12, 2012
11.00.2218 2011.110.2218.0 Microsoft Security Bulletin MS12-070 October 9, 2012
11.00.2214 2011.110.2214.0 2685308 FIX: SSAS uses only 20 cores in SQL Server 2012 Business Intelligence April 6, 2012
11.00.2100 2011.110.2100.60 SQL Server 2012 RTM March 6, 2012
11.00.1913 2011.110.1913.37 Microsoft SQL Server 2012 Release Candidate 1 (RC1) December 16, 2011
11.00.1750 2011.110.1750.32 Microsoft SQL Server 2012 Release Candidate 0 (RC0) November 17, 2011
11.00.1440 2010.110.1440.19 Microsoft SQL Server 2012 (codename Denali) Community Technology Preview 3 (CTP3) July 11, 2011
11.00.1103 2010.110.1103.9 Microsoft SQL Server 2012 (codename Denali) Community Technology Preview 1 (CTP1) November 8, 2010

 

Note: RTM stands for release to market edition, which is the first supported version of SQL Server 2012 R2, and SP stands for service pack. All SQL Server service packs and hotfixes are cumulative, meaning that each new service pack and hotfixes contains all the fixes that are included with previous service packs, hotfixes and new fixes issues.

Please use comment section, if you find build that is not listed here.

Leave a Comment
May 8, 2013

Microsoft SQL Server 2008 R2 Builds

The following table lists all builds of SQL Server 2008 R2 known hotfixes, service packs and KB articles that have been released by Microsoft.

Quick Overview:

 Codename RTM/Service Pack Build Number
 Kilimanjaro RTM 10.50.1600.1
SP1 10.50.2500
SP2 10.50.4000

Microsoft SQL Server 2008 R2 Builds Breakdown:

Build File version KB / Description Release Date
10.50.4279 2009.100.4279.0 2830140 Cumulative update package 6 (CU) for SQL Server 2008 R2 Service Pack 2 April 15, 2013 *new
10.50.4276 2009.100.4276.0 2797460 Cumulative update package 5 (CU5) for SQL Server 2008 R2 Service Pack 2 February 18, 2013
10.50.4270 2009.100.4270.0 2777358 Cumulative update package 4 (CU4) for SQL Server 2008 R2 Service Pack 2 December 17, 2012
10.50.4266 2009.100.4266.0 2754552 Cumulative update package 3 (CU3) for SQL Server 2008 R2 Service Pack 2 October 15, 2012
10.50.4263 2009.100.4263.0 2740411 Cumulative update package 2 (CU2) for SQL Server 2008 R2 Service Pack 2 August 29, 2012
10.50.4260 2009.100.4260.0 2720425 Cumulative update package 1 (CU1) for SQL Server 2008 R2 Service Pack 2 August 1, 2012
10.50.4000 2009.100.4000.0 SQL Server 2008 R2 Service Pack 2 (SP2) July 26, 2012
10.50.3720 2009.100.3720.0 SQL Server 2008 R2 Service Pack 2 Community Technology Preview (CTP) May 13, 2012
10.50.2874 2009.100.2874.0 2828727 Cumulative update package 12 (CU12) for SQL Server 2008 R2 Service Pack 1 April 15, 2013 *new
10.50.2861 2009.100.2861.0 Microsoft Security Bulletin MS12-070 October 9, 2012
10.50.2869 2009.100.2869.0 2812683 Cumulative update package 11 (CU11) for SQL Server 2008 R2 Service Pack 1 February 18, 2013
10.50.2868 2009.100.2868.0 2783135 Cumulative update package 10 (CU10) for SQL Server 2008 R2 Service Pack 1 December 17, 2012
10.50.2866 2009.100.2866.0 2756574 Cumulative update package 9 (CU9) for SQL Server 2008 R2 Service Pack 1 November 6, 2012
10.50.2861 2009.100.2861.0 2716439 MS12-070: Description of the security update for SQL Server 2008 R2 Service Pack 1 QFE: October 9, 2012 October 9, 2012
10.50.2822 2009.100.2822.0 2723743 Cumulative update package 8 (CU8) for SQL Server 2008 R2 Service Pack 1 August 29, 2012
10.50.2817 2009.100.2817.0 2703282 Cumulative update package 7 (CU7) for SQL Server 2008 R2 Service Pack 1 June 18, 2012
10.50.2811 2009.100.2811.0 2679367 Cumulative update package 6 (CU6) for SQL Server 2008 R2 Service Pack 1 April 16, 2012
10.50.2807 2009.100.2807.0 2675522 FIX: Access violation when you run DML statements against a table that has partitioned indexes in SQL Server 2008 R2 March 12, 2012
10.50.2806 2009.100.2806.0 2659694 Cumulative update package 5 (CU5) for SQL Server 2008 R2 Service Pack 1 February 22, 2012
10.50.2799 2009.100.2799.0 2633357 FIX: “Non-yielding Scheduler” error might occur when you run a query that uses the CHARINDEX function in SQL Server 2008 R2 February 22, 2012
10.50.2796 2009.100.2796.0 2633146 Cumulative update package 4 (CU4) for SQL Server 2008 R2 Service Pack 1 December 20, 2011
10.50.2789 2009.100.2789.0 2591748 Cumulative update package 3 (CU3) for SQL Server 2008 R2 Service Pack 1 October 17, 2011
10.50.2776 2009.100.2776.0 2606883 FIX: Slow performance when an AFTER trigger runs on a partitioned table in SQL Server 2008 R2 October 18, 2011
10.50.2772 2009.100.2772.0 2567714 Cumulative update package 2 (CU2) for SQL Server 2008 R2 Service Pack 1 August 15, 2011
10.50.2769 2009.100.2769.0 2544793 Cumulative update package 1 (CU1) for SQL Server 2008 R2 Service Pack 1 July 18, 2011
10.50.2550 2009.100.2550.0 Microsoft Security Bulletin MS12-070 October 9, 2012
10.50.2500 2009.100.2500.0 SQL Server 2008 R2 Service Pack 1 (SP1) July 11, 2011
10.50.1817 2009.100.1817.0 2703280 Cumulative update package 14 (CU14) for SQL Server 2008 R2 June 18, 2012
10.50.1815 2009.100.1815.0 2679366 Cumulative update package 13 (CU13) for SQL Server 2008 R2 April 17, 2012
10.50.1810 2009.100.1810.0 2659692 Cumulative update package 12 (CU12) for SQL Server 2008 R2 February 21, 2012
10.50.1809 2009.100.1809.0 2633145 Cumulative update package 11 (CU11) for SQL Server 2008 R2 January 9, 2012
10.50.1807 2009.100.1807.0 2591746 Cumulative update package 10 (CU10) for SQL Server 2008 R2 October 19, 2011
10.50.1804 2009.100.1804.0 2567713 Cumulative update package 9 (CU9) for SQL Server 2008 R2 August 16, 2011
10.50.1800 2009.100.1800.0 2574699 FIX: Database data files might be incorrectly marked as sparse in SQL Server 2008 R2 or in SQL Server 2008 even when the physical files are marked as not sparse in the file system October 18, 2011
10.50.1797 2009.100.1797.0 2534352 Cumulative update package 8 (CU8) for SQL Server 2008 R2 June 20, 2011
10.50.1790 2009.100.1790.0 2494086 MS11-049: Description of the security update for SQL Server 2008 R2 QFE: June 14, 2011 June 17, 2011
10.50.1777 2009.100.1777.0 2507770 Cumulative update package 7 (CU7) for SQL Server 2008 R2 June 16, 2011
10.50.1769 2009.100.1769.0 2520808 FIX: Non-yielding scheduler error when you run a query that uses a TVP in SQL Server 2008 or in SQL Server 2008 R2 if SQL Profiler or SQL Server Extended Events is used April 18, 2011
10.50.1765 2009.100.1765.0 2489376 Cumulative update package 6 (CU6) for SQL Server 2008 R2 February 21, 2011
10.50.1753 2009.100.1753.0 2438347 Cumulative update package 5 (CU5) for SQL Server 2008 R2 December 23, 2010
10.50.1746 2009.100.1746.0 2345451 Cumulative update package 4 (CU4) for SQL Server 2008 R2 October 18, 2010
10.50.1734 2009.100.1734.0 2261464 Cumulative update package 3 (CU3) for SQL Server 2008 R2 August 20, 2010
10.50.1720 2009.100.1720.0 2072493 Cumulative update package 2 (CU2) for SQL Server 2008 R2 June 25, 2010
10.50.1702 2009.100.1702.0 981355 Cumulative update package 1 (CU1) for SQL Server 2008 R2 May 18, 2010
10.50.1617 2009.100.1617.0 2494088 MS11-049: Description of the security update for SQL Server 2008 R2 GDR: June 14, 2011 June 14, 2011
10.50.1600 2009.100.1600.1 SQL Server 2008 R2 RTM April 21, 2010
10.50.1352 2009.100.1352.12 Microsoft SQL Server 2008 R2 November Community Technology Preview (CTP) November 12, 2009
10.50.1092 2009.100.1092.20 Microsoft SQL Server 2008 R2 August Community Technology Preview (CTP) June 30, 2009

Note: RTM stands for release to market edition, which is the first supported version of SQL Server 2008 R2, and SP stands for service pack. All SQL Server service packs and hotfixes are cumulative, meaning that each new service pack and hotfixes contains all the fixes that are included with previous service packs, hotfixes and new fixes issues.

Please use comment section, if you find build that is not listed here.

Leave a Comment
« Older Entries
Follow

Get every new post delivered to your Inbox.

Join 74 other followers