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

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

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.

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