Find largest table in a SQL Server database Monitoring table size over time is very important to the SQL Server Engine. In performance point of view to run queries. At the most optimal and avoid performance issues due to larger table size as it important factor in SQL Server performance There are often many times people ask, how to find the largest tables/objects in a database, so below scripts, will determine which objects in a database are largest. SELECT t.name AS TableName, i.name as indexName, sum(p.rows) as RowCounts, sum(a.total_pages) as TotalPages, sum(a.used_pages) as UsedPages, sum(a.data_pages) as DataPages, (sum(a.total_pages) * 8) / 1024 as TotalSpaceMB, (sum(a.used_pages) * 8) / 1024 as UsedSpaceMB, (sum(a.data_pages) * 8) / 1024 as DataSpaceMB 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 WHERE t.name NOT LIKE 'dt%' AND i.object_id > 255 AND i.index_id <= 1 GROUP BY t.name, i.object_id, i.index_id, i.name ORDER BY TotalSpaceMB DESC

Check Numbers in Filename and Copy specific files

Vikash

How can I get a number from a file name and then copy files to that folder and execute .SQL files using PowerShell or cmd?

Basically users have a folder called SQL Update Scripts. And each file we add has a number at the beginning and a description. Example File Name (688. VW tblUsers) Now, not every user is up to the same numbered file so I want to copy from one folder containing all files to their folder only from the number they are up to and further on and only execute those.

So for example Development is up to file number 688 and the user's file number is up to 650 so I want to copy from development 651-688 and only execute all files within the folder starting at 651-688.

Thank you.