Tuesday, May 1, 2012

SQL DBA

Topic-1:

Version HISTORY

---------------------
6.50.201        SQL Server 6.5 RTM
6.50.213        SQL Server 6.5 with Service Pack 1
6.50.240        SQL Server 6.5 with Service Pack 2
6.50.258        SQL Server 6.5 with Service Pack 3
6.50.281        SQL Server 6.5 with Service Pack 4
6.50.415        SQL Server 6.5 with Service Pack 5
6.50.416        SQL Server 6.5 with Service Pack 5a

7.00.623        SQL Server 7.0 (MSDE 1.0 RTM)
7.00.699        SQL Server 7.0 with Service Pack 1
7.00.842        SQL Server 7.0 with Service Pack 2
7.00.961        SQL Server 7.0 with Service Pack 3
7.00.1063      SQL Server 7.0 with Service Pack 4

8.00.194        SQL Server 2000 (8.0) RTM---------- - November 2000
8.00.384        SQL Server 2000 with Service Pack 1
8.00.534        SQL Server 2000 with Service Pack 2
8.00.760        SQL Server 2000 with Service Pack 3
8.00.760        SQL Server 2000 with Service Pack 3a
8.00.2039      SQL Server 2000 with Service Pack 4 - May 2005

9.00.194        SQL Server 2005 (9.0) Yukon-------- - November 2005 CTP
9.00.1399      SQL Server 2005 RTM---------------- - January 2006
9.00.2047      SQL Server 2005 with Service Pack 1 - April 2006
9.00.3042.00  SQL Server 2005 with Service Pack 2 - February 2007 
9.00.3330      SQL Server 2005 with Service Pack 2 - Aug 2009 - total 11 paches
9.00.4035      SQL Server 2005 with Service Pack 3 - with Hot Fix  Novmeber 2008
9.00.4325      SQL Server 2005 with Service Pack 3 - March 21 2011 - total 16 paches
9.00.5000      SQL Server 2005 with Service Pack 4 - December 17 2010
9.00.5266      SQL Server 2005 with Service Pack 4 - March 21 2011 total 5 paches
9.00.3054      KB934458 - Fixes maintenance plans losing details

10.00.1075.23SQL Server 2008 (10.0) Katmai------ - November CTP
10.00.1600    SQL Server 2008 RTM--------------- - August 2008
10.00.1763    SQL Server 2008 with Service Pack 0 - September 2008
10.00.1835    SQL Server 2008 with Service Pack 0 - March 15, 2010
10.00.2531    SQL Server 2008 with Service Pack 1 - April 2009
10.00.2816    SQL Server 2008 with Service Pack 1 - April 2009 total 15 paches
10.00.4000    SQL Server 2008 with Service Pack 2 - September 29, 2010
10.00.4279    SQL Server 2008 with Service Pack 2 - March 21, 2011 total 5 paches
10.50.1600.1  SQL Server 2008 R2 RTM------------ - April 21, 2010

11.00.1103    SQL Server 2012 Denali------------- - November 8, 2011

2 comments:

Unknown said...

give some features about the 2008 r2 edition

SQLDBA-HUB said...

if u have any other details add here i will upadate its usefull for all