- Details
- Written by: Stanko Milosev
- Category: SQL
- Hits: 5308
SELECT so.name as TableName, ddps.row_count as [RowCount]
FROM sys.objects so
JOIN sys.indexes si ON si.OBJECT_ID = so.OBJECT_ID
JOIN sys.dm_db_partition_stats AS ddps
ON si.OBJECT_ID = ddps.OBJECT_ID AND si.index_id = ddps.index_id
WHERE si.index_id < 2 AND so.is_ms_shipped = 0
ORDER BY ddps.row_count DESC
Taken from here
- Details
- Written by: Stanko Milosev
- Category: SQL
- Hits: 6126
If you are receiving error like:
Failed to add rule 'xxx.xxx.xxx.xxx to xxx.xxx.xxx.xxx' to firewall. Please add it manually.
Then first go to SQL databases, like on the picture:
After go to servers, and click on the server which you want to configure:
Then click configure:
And here you can add your rule:
 