Browse by Tags

How to get rowcount efficiently within a SSIS package?

Published 5 September 7 3:50 AM | SSQA.net

I would like to call this as how efficiently you can obtain counting rows in SSIS package. Usual thought would come is @@rowcount or COUNT_BIG functions, but this is not that efficient way to obtain the results. SSIS provides the snippet within its components...

Filed under: sql server, package, databases, ssis, component, table, requirement, rowcount

TSQL to return (display) all tables row count in database - think about performance

Published 16 July 7 4:5 AM | SSQA.net

In the forums and newsgroups this is a very common question that how to get all the tables rowcount or to get optimum values. You may be aware using SELECT COUNT(*) statement, but be aware it will make full table scan to return the rowcount and think...

Filed under: sql server, performance, tsql, rowcount, tables, display