SELECT request_session_id AS spid, OBJECT_NAME(resource_associated_entity_id) AS tableName
FROM sys.dm_tran_locks
WHERE resource_type = 'OBJECT'
AND OBJECT_NAME(resource_associated_entity_id) IS NOT NULL;
SELECT 'kill ' + CAST(request_session_id AS VARCHAR(20)) AS spid
FROM sys.dm_tran_locks
WHERE resource_type = 'OBJECT'
AND OBJECT_NAME(resource_associated_entity_id) IS NOT NULL;
select * from table order by Id offset 0 rows fetch next 10 rows only;
SELECT COUNT(1) FROM TableName WHERE 1 = 1;
SELECT *
FROM (
SELECT ROW_NUMBER() OVER (ORDER BY Id DESC) AS RowId, *
FROM TableName
WHERE 1 = 1
) t
WHERE t.RowId BETWEEN @page AND @limit;