31 August 2012

Microsoft Product Life cycle - Support Dates


Products Released Lifecycle Start Date Mainstream Support End Date Extended Support End Date Service Pack Support End Date
         
SQL Server Compact 3.5 19/02/2008 09/04/2013 10/04/2018 13/10/2009
SQL Server Compact 3.5 Service Pack 1 for Windows Mobile 11/08/2008 Not Applicable Not Applicable 12/07/2011
SQL Server Compact 3.5 Service Pack 2 29/06/2010 Review Note Review Note  
         
SQL Server Compact 4.0 13/04/2011 12/07/2016 13/07/2021  
SQL Server Notification Services 2.0 Enterprise Edition 26/11/2002 08/01/2008 08/01/2013  
SQL Server Notification Services 2.0 Standard Edition 26/11/2002 08/01/2008 08/01/2013  
         
SQL Server 4.2 for OS/2 Not Available 36342 Not Applicable  
         
SQL Server 6.0 Standard Edition Not Available 36250 Not Applicable  
         
SQL Server 6.5 Enterprise Edition 01/03/1998 38077 Not Applicable  
SQL Server 6.5 Service Pack 1 31/12/1998 Not Applicable Not Applicable 01/01/2002
SQL Server 6.5 Service Pack 2 15/09/2000 Not Applicable Not Applicable  
SQL Server 6.5 Service Pack 3 15/01/2000 Not Applicable Not Applicable  
SQL Server 6.5 Service Pack 4 Not Available Not Applicable Not Applicable 24/03/1999
SQL Server 6.5 Service Pack 5a 24/12/1998 Not Applicable Not Applicable 31/03/2004
SQL Server 6.5 Standard Edition 30/06/1996 37257 Not Applicable  
         
SQL Server 7.0 Enterprise Edition 01/03/1999 31/12/2005 11/01/2011  
SQL Server 7.0 Service Pack 1 25/05/1999 Not Applicable Not Applicable 31/03/2004
SQL Server 7.0 Service Pack 2 20/03/2000 Not Applicable Not Applicable  
SQL Server 7.0 Service Pack 3 Not Available Not Applicable Not Applicable 26/07/2002
SQL Server 7.0 Service Pack 4 26/04/2002 Review Note Review Note  
SQL Server 7.0 Standard Edition 01/03/1999 31/12/2005 11/01/2011  
         
SQL Server 2000 64-bit Edition 30/11/2000 08/04/2008 09/04/2013 11/07/2002
SQL Server 2000 Desktop Engine 30/11/2000 08/04/2008 09/04/2013  
SQL Server 2000 Desktop Engine Release A 29/01/2003 08/04/2008 09/04/2013  
SQL Server 2000 Developer Edition 30/11/2000 08/04/2008 09/04/2013 11/07/2002
SQL Server 2000 Enterprise Edition 30/11/2000 08/04/2008 09/04/2013 11/07/2002
SQL Server 2000 Reporting Services Service Pack 1 22/09/2004 Not Applicable Not Applicable 11/07/2006
SQL Server 2000 Reporting Services Service Pack 2 22/04/2005 Review Note Review Note  
SQL Server 2000 Service Pack 1 12/06/2001 Not Applicable Not Applicable 28/02/2002
SQL Server 2000 Service Pack 2 30/11/2001 Not Applicable Not Applicable 07/04/2003
SQL Server 2000 Service Pack 3a 07/01/2003 Not Applicable Not Applicable 10/07/2007
SQL Server 2000 Service Pack 4 06/05/2005 Review Note Review Note  
SQL Server 2000 Standard Edition 30/11/2000 08/04/2008 09/04/2013 11/07/2002
SQL Server 2000 Windows CE Edition 2.0 16/12/2002 08/01/2008 08/01/2013  
SQL Server 2000 Workgroup Edition 01/06/2005 08/04/2008 09/04/2013  
         
SQL Server 2005 Compact Edition 19/02/2007 12/04/2011 12/04/2016 10/07/2007
SQL Server 2005 Developer Edition 14/01/2006 12/04/2011 12/04/2016 10/07/2007
SQL Server 2005 Enterprise Edition 14/01/2006 12/04/2011 12/04/2016 10/07/2007
SQL Server 2005 Enterprise Edition for Itanium-based Systems 14/01/2006 12/04/2011 12/04/2016 10/07/2007
SQL Server 2005 Enterprise X64 Edition 14/01/2006 12/04/2011 12/04/2016 10/07/2007
SQL Server 2005 Express Edition 01/06/2006 12/04/2011 12/04/2016 10/07/2007
SQL Server 2005 Express Edition with Advanced Services 16/07/2006 12/04/2011 12/04/2016 10/07/2007
SQL Server 2005 Service Pack 1 18/04/2006 Not Applicable Not Applicable 08/04/2008
SQL Server 2005 Service Pack 2 19/02/2007 Not Applicable Not Applicable 12/01/2010
SQL Server 2005 Service Pack 3 15/12/2008 Not Applicable Not Applicable 10/01/2012
SQL Server 2005 Service Pack 4 13/12/2010 Review Note Review Note  
SQL Server 2005 Standard Edition 14/01/2006 12/04/2011 12/04/2016 10/07/2007
SQL Server 2005 Standard Edition for Itanium-based Systems 14/01/2006 12/04/2011 12/04/2016 10/07/2007
SQL Server 2005 Standard X64 Edition 14/01/2006 12/04/2011 12/04/2016 10/07/2007
SQL Server 2005 Workgroup Edition 14/01/2006 12/04/2011 12/04/2016 10/07/2007
         
SQL Server 2008 Developer 06/11/2008 08/07/2014 09/07/2019 13/04/2010
SQL Server 2008 Enterprise 07/11/2008 08/07/2014 09/07/2019 13/04/2010
SQL Server 2008 Express 11/11/2008 08/07/2014 09/07/2019 13/04/2010
SQL Server 2008 Express with Advanced Services 22/11/2008 08/07/2014 09/07/2019 13/04/2010
SQL Server 2008 R2 Datacenter 20/07/2010 08/07/2014 09/07/2019 10/07/2012
SQL Server 2008 R2 Developer 20/07/2010 08/07/2014 09/07/2019 10/07/2012
SQL Server 2008 R2 Enterprise 20/07/2010 08/07/2014 09/07/2019 10/07/2012
SQL Server 2008 R2 Express 20/07/2010 08/07/2014 09/07/2019 10/07/2012
SQL Server 2008 R2 Express with Advanced Services 20/07/2010 08/07/2014 09/07/2019 10/07/2012
SQL Server 2008 R2 Parallel Data Warehouse 09/11/2010 08/07/2014 09/07/2019  
SQL Server 2008 R2 Service Pack 1 12/07/2011 Not Applicable Not Applicable 08/10/2013
SQL Server 2008 R2 Service Pack 2 26/07/2012 Review Note Review Note  
SQL Server 2008 R2 Standard 20/07/2010 08/07/2014 09/07/2019 10/07/2012
SQL Server 2008 R2 Standard Edition for Small Business 20/07/2010 08/07/2014 09/07/2019 10/07/2012
SQL Server 2008 R2 Web 20/07/2010 08/07/2014 09/07/2019 10/07/2012
SQL Server 2008 R2 Workgroup 20/07/2010 08/07/2014 09/07/2019 10/07/2012
SQL Server 2008 Service Pack 1 31/03/2009 Not Applicable Not Applicable 11/10/2011
SQL Server 2008 Service Pack 2 24/09/2010 Not Applicable Not Applicable 09/10/2012
SQL Server 2008 Service Pack 3 06/10/2011 Review Note Review Note  
SQL Server 2008 Standard 06/11/2008 08/07/2014 09/07/2019 13/04/2010
SQL Server 2008 Standard Edition for Small Business 06/11/2008 08/07/2014 09/07/2019 13/04/2010
SQL Server 2008 Web 06/11/2008 08/07/2014 09/07/2019 13/04/2010
SQL Server 2008 Workgroup 06/11/2008 08/07/2014 09/07/2019 13/04/2010
         
SQL Server 2012 Business Intelligence 20/05/2012 11/07/2017 12/07/2022  
SQL Server 2012 Developer 20/05/2012 11/07/2017 12/07/2022  
SQL Server 2012 Enterprise 20/05/2012 11/07/2017 12/07/2022  
SQL Server 2012 Enterprise Core 20/05/2012 11/07/2017 12/07/2022  
SQL Server 2012 Express 20/05/2012 11/07/2017 12/07/2022  
SQL Server 2012 Standard 20/05/2012 11/07/2017 12/07/2022  
SQL Server 2012 Web 20/05/2012 11/07/2017 12/07/2022  
         

More information on http://support.microsoft.com/lifecycle/#ServicePackSupport

22 August 2012

DAC - SQLCMD

sqlcmd -A -d master  -E -S A**T*66

sqlcmd -A -d master  -U sa  -P *****

One More - Script To Shrink Log Files


DBCC SQLPERF(logspace) --Optional
GO
DECLARE @logsize AS INT = 0; -- MB
DECLARE @databasename AS VARCHAR(256);
DECLARE @filename VARCHAR(256);
DECLARE @cmd VARCHAR(MAX);
DECLARE curdb CURSOR FOR
    SELECT f.name AS filename, d.name AS databasename
    FROM msdb.sys.master_files f
        INNER JOIN master.sys.sysdatabases d
        ON d.dbid = f.database_id
    WHERE type = 1 AND state = 0 AND size > @logsize AND database_id > 4  
OPEN curdb
FETCH NEXT FROM curdb INTO @filename, @databasename
WHILE @@FETCH_STATUS = 0
BEGIN
    --PRINT @filename
    SET @cmd = ('USE [' + @databasename + ']; ')
    SET @cmd = @cmd + 'DBCC SHRINKFILE ([' + @filename + '], ' + CAST(@logsize AS VARCHAR) + ');';
    EXEC (@cmd)
    FETCH NEXT FROM curdb INTO @filename, @databasename
END
DEALLOCATE curdb
GO
DBCC SQLPERF(logspace) --Optional If you require to send out put in file
GO

12 August 2012

The row was not found at the Subscriber when applying the replicated command.


Command attempted:
if @@trancount > 0 rollback tran
(Transaction sequence number: 0x000210C100000223000D00000000, Command ID: 8)


Ex:

Step 1 :-

Connect to the Distributor
select * from dbo.MSarticles
where article_id IN (SELECT Article_id from MSrepl_commands
where xact_seqno =  0x000210C100000223000D00000000 )


Step 2 :- 
 
exec sp_browsereplcmds @xact_seqno_start = '0x0013DD67000002EA007F00000000'
,@xact_seqno_end = '0x0013DD67000002EA007F00000000'
,@publisher_database_id = xxx
,@article_id = xxx
,@command_id= '8'
Step 3:- 

If data is in sync, do skip errors




For replication Errors,

select 

From distributor..MSrepl_errors

Select * from MSrepl_commands Where xact_seqno>'0x0000000000000000000000000000'

Which will give the article details and issues.


10 August 2012

SQL Server Memory Management Architecture



Memory Architecture  :-  Describes how SQL Server dynamically manages memory.

Process Address Space  :- Describes the amount of physical and virtual memory available to applications.

Dynamic Memory Management :-  Describes how SQL Server manages memory for the buffer pool.

Effects of min and max server memory :- Describes the effects of the min and max server memory options.

Memory Used by SQL Server Objects Specifications :- Describes the approximate amount of memory used by different objects in SQL Serverr.

Buffer Management :- Contains information about how the buffer manager accesses and updates data pages.

Managing Memory for Large Databases :-  Contains information about specialized memory settings, such as Address Windowing Extensions (AWE) memory, that allow you to take advantage of the latest hardware.


Understanding Non-uniform Memory Access :- Contains information about non-uniform memory access (NUMA) and how SQL Server uses it.


Find More On  http://msdn.microsoft.com/en-us/library/cc280359(v=sql.105).aspx