Получаем первые 10 записей, а точнее последние созданные.

WITH num_row
AS
(SELECT row_number() OVER (ORDER BY _id DESC) as nom , * FROM [news] WHERE _status='public')
SELECT * FROM num_row WHERE nom BETWEEN (10 - 9) AND 10

-- и так дальше 20, 30, 40 .. до последней страницы.

1 способ

sp_who
или
sp_who2 

1 Способ

С помощью представления sys.databases

   SELECT database_id AS [ID], 
           name AS [Имя DB],
           CONVERT(CHAR(10), create_date, 104) AS [Дата создания],
           state_desc AS [Статус],
           compatibility_level AS [Уровень совместимости],
           recovery_model_desc AS [Модель восстановления]
   FROM sys.databases

USE [dbasename]
SELECT 
    t.NAME AS TableName,
    s.Name AS SchemaName,
    p.rows AS RowCounts,
    SUM(a.total_pages) * 8 AS TotalSpaceKB, 
    CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS TotalSpaceMB,
    SUM(a.used_pages) * 8 AS UsedSpaceKB, 
    CAST(ROUND(((SUM(a.used_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS UsedSpaceMB, 
    (SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB,
    CAST(ROUND(((SUM(a.total_pages) - SUM(a.used_pages)) * 8) / 1024.00, 2) AS NUMERIC(36, 2)) AS UnusedSpaceMB
FROM 
    sys.tables t
INNER JOIN      
    sys.indexes i ON t.OBJECT_ID = i.object_id
INNER JOIN 
    sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNER JOIN 
    sys.allocation_units a ON p.partition_id = a.container_id
LEFT OUTER JOIN 
    sys.schemas s ON t.schema_id = s.schema_id
WHERE 
    t.NAME NOT LIKE 'dt%' 
    AND t.is_ms_shipped = 0
    AND i.OBJECT_ID > 255
	--AND t.NAME LIKE '_InfoRg%' 
	--AND (t.NAME LIKE '_InfoRg104%' 
	--OR t.NAME LIKE '_InfoRg114%')
GROUP BY 
    t.Name, s.Name, p.Rows
ORDER BY 
    TotalSpaceMB DESC, t.Name

Находим таблицы регистров и чистим их

truncate table dbo._InfoRg10450
truncate table dbo._InfoRg11484

declare @t table (name varchar(255), [rows] varchar(255), reserved varchar(255), data varchar(255), index_size varchar(255), unused varchar(255))
delete from @t
insert into @t exec sp_MSforeachtable @command1='EXEC sp_spaceused ''?''',@whereand='or OBJECTPROPERTY(o.id, N''IsSystemTable'') = 1'
select * from @t order by CONVERT(bigint,REPLACE(data,' KB','')) DESC

USE master
GO

 
ALTER DATABASE [database name]
SET OFFLINE WITH ROLLBACK IMMEDIATE

 
ALTER DATABASE [database name]
SET ONLINE