Get all the tables with a count of their records with the following query:
CREATE TABLE #Temp ( TableName VARCHAR(MAX), Rows INT ); EXEC sp_MSForEachTable @command1 = 'INSERT INTO #Temp(TableName, Rows) SELECT ''?'', COUNT(*) FROM ?' SELECT * FROM #Temp ORDER BY Temp.Rows DESC; DROP TABLE #Temp;
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
