Home Forums SQL Server 2008 SQL Server Newbies Report Performance RE: Report Performance
Bhushan Kulkarni
SSCrazy
Points: 2829
More actions
January 29, 2015 at 2:39 am
#1773917
CREATE TABLE #Temp
(
TableName VARCHAR(500),
CountOf INT
)
INSERT #Temp
EXEC sp_msForEachTable
'SELECT PARSENAME(''?'', 1),
COUNT(*) FROM ? WITH (NOLOCK)'
SELECT TableName , CountOf
FROM #Temp
DROP TABLE #Temp