--Import multiple trace file in sql Table. --All the rollover files will be automatically imported --provide number tracefile to capture...

select schema_name(tab.schema_id) as [schema_name], pk.[name] as pk_name, substring(column_names, 1, len(column_names)-1) as [columns],...

--Execute the following script against the User Database where you need to find DB User permission. DECLARE @sql VARCHAR(2048) ,@sort INT...

--Script to verify snapshot isolation enabled SELECT name , s.snapshot_isolation_state , snapshot_isolation_state_desc ,...

--List of tables with CDC enabled SELECT s.name AS Schema_Name, tb.name AS Table_Name , tb.object_id, tb.type, tb.type_desc,...

--Find Orphan Users in the DB EXEC sp_change_users_login 'Report' --If you already have a login created, map the user to login using the...

SQL Server Script to Change DB Owner to SA for all the user DBs in the Instance. --Script:17 Change DB Owner to SA for all the User DBs...

select top 10 * from sys.fn_dblog(null,null) order by [Current LSN] desc go

SET ANSI_NULLS ON; SET ARITHABORT ON; SET QUOTED_IDENTIFIER ON; SET NOCOUNT ON; Declare @dbname varchar(max) DECLARE @command...

SELECT distinct d.name AS 'Database', SUM(m.size * 8/1024000) OVER (PARTITION BY d.name) AS 'Database Total Size GB' FROM...

-- Get CPU utilization by database WITH DB_CPU_Stats AS (SELECT DatabaseID, DB_Name(DatabaseID) AS [DatabaseName], SUM(total_worker_time)...

-- Recovery model, log reuse wait description, log file size, log usage size -- and compatibility level for all databases on instance...

-- Volume info for all databases on the current instance (SQL Server 2008 R2 SP1 or greater) SELECT DB_NAME(f.database_id) AS...

SELECT DB_NAME([database_id])AS [Database Name], [file_id], name, physical_name, type_desc, state_desc, CONVERT( bigint, size/128000.0)...

-- Get configuration values for instance SELECT name, value, value_in_use, [description] FROM sys.configurations ORDER BY name OPTION...

-- Get processor description from Windows Registry EXEC xp_instance_regread 'HKEY_LOCAL_MACHINE', 'HARDWARE\DESCRIPTION\System\CentralPro...

-- Get System Manufacturer and model number from -- SQL Server Error log. This query might take a few seconds -- if you have not recycled...

SELECT cpu_count AS [Logical CPU Count], hyperthread_ratio AS [Hyperthread Ratio], cpu_count/hyperthread_ratio AS [Physical CPU Count],...

-- SQL Server Services information (SQL Server 2008 R2 SP1 or greater) SELECT servicename, startup_type_desc, status_desc,...

-- Windows information (SQL Server 2008 R2 SP1 or greater) SELECT windows_release, windows_service_pack_level, windows_sku,...