Cumulative Update – 6 for SQL Server 2012 Service Pack 1 Is Now Available !
The 6th cumulative update release for SQL Server 2012 Service Pack 1 is now available. Cumulative Update 6 contains all the hotfixes released since the initial release of SQL Server 2012 SP1.
Those who are facing severe issues with their environment, they can plan to test CU6 in test environment & then move to Production after satisfactory results.
To other, I suggest to wait for SP2 final release to deploy on your production environment, to have consolidate build.
KB Article For CU6 of SQL Server 2012 SP1
§ CU#6 KB Article: http://support.microsoft.com/kb/2874879
Previous Cumulative Update KB Articles of SQL Server 2012 SP1
§ CU#5 KB Article: http://support.microsoft.com/kb/2861107
§ CU#4 KB Article: http://support.microsoft.com/kb/2833645
§ CU#3 KB Article: http://support.microsoft.com/kb/2812412
§ CU#2 KB Article: http://support.microsoft.com/kb/2790947
§ CU#1 KB Article: http://support.microsoft.com/kb/2765331
If you liked this post, do like on Facebook at http://www.facebook.com/mssqlfun
Reference : Rohit Garg (http://mssqlfun.com/)
How to Check SQL Server Evaluation Version Expire Date ?
SQL Server Evaluation Edition is available free of cost. It’s a trial version & valid for limited time of period. The expiration date is always 180 days from the initial installation date.
The following query will give you the expiration date of evaluation instance :
SELECT
@@SERVERNAME SERVERNAME,
CREATE_DATE ‘INSTALALTIONDATE’,
SERVERPROPERTY(‘EDITION’) ‘Version’,
DATEADD(DD, 180, CREATE_DATE) AS ‘EXPIRY DATE’
FROM SYS.SERVER_PRINCIPALS
WHERE SID = 0X010100000000000512000000
SID 0X010100000000000512000000 is associated with login “NT AUTHORITYSYSTEM” & which is created at the time of installation only.
If you liked this post, do like on Facebook at http://www.facebook.com/mssqlfun
Reference : Rohit Garg (http://mssqlfun.com/)
DMV-14 : Which Table has Max. rows & Size……..sys.dm_db_partition_stats
sys.dm_db_partition_stats DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms187737.aspx
Returns page and row-count information for every partition in the current database.
This DMV gives useful information about rowcount, free & reserved space of each table in database. It can be used for analysis purpose while adding new indexes, doing index Maintenance or checking the biggest table of database.
Query 1 : Details of table with row count & space used
SELECT
SS.NAME AS SCHEMANAME,
SO.NAME AS OBJECTNAME,
SI.NAME AS INDEXNAME,
PS.RESERVED_PAGE_COUNT*8 TOTAL_SPACE_CONSUMED_KB,
PS.USED_PAGE_COUNT*8 USED_SPACE_KB,
(PS.RESERVED_PAGE_COUNT – PS.USED_PAGE_COUNT)*8 FREE_SPACE_KB,
CASE
WHEN PS.INDEX_ID IN (0,1) THEN PS.ROW_COUNT
ELSE NULL
END AS ROW_COUNT
FROM
SYS.DM_DB_PARTITION_STATS PS
INNER JOIN SYS.OBJECTS SO ON SO.OBJECT_ID = PS.OBJECT_ID
INNER JOIN SYS.SCHEMAS SS ON SS.SCHEMA_ID = SO.SCHEMA_ID
LEFT JOIN SYS.INDEXES SI ON SI.OBJECT_ID = PS.OBJECT_ID
AND SI.INDEX_ID = PS.INDEX_ID
WHERE
SO.IS_MS_SHIPPED = 0
Sample Result
1. To use this DMV, User required VIEW DATABASE STATE permission on the server.
If you liked this post, do like on Facebook at http://www.facebook.com/mssqlfun
Reference : Rohit Garg (http://mssqlfun.com/)