rcdamaSQL

SELECT session_id, command, blocking_session_id, wait_type, wait_time, wait_resource, t.TEXT FROM sys.dm_exec_requests CROSS apply sys.dm_e...

SELECT     FK_Table = FK.TABLE_NAME,     FK_Column = CU.COLUMN_NAME,     PK_Table = PK.TABLE_NAME,     PK_Column = PT.COLUMN_NAME,     Cons...

DECLARE @cols AS NVARCHAR(MAX),     @query  AS NVARCHAR(MAX) select @cols = STUFF((SELECT ',' + QUOTENAME(ColumnName)              ...

Approach 1: SELECT       QUOTENAME(SCHEMA_NAME(sOBJ.schema_id)) + '.' + QUOTENAME(sOBJ.name) AS [TableName]       , SUM(sPTN.Rows...

EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'  EXEC sp_MSForEachTable 'ALTER TABLE ? DISABLE TRIGGER ALL'  ...

Create Table ##temp (     DatabaseName sysname,     Name sysname,     physical_name nvarchar(500),     size decimal (18,2),     FreeSpace d...

Microsoft has changed the way they deal with identity values in SQL Server 2012 and as a result of this you can see identity gaps betwee...