Browse by Tags

• component
• cursor
• dmv
• hints
• package
• performance
• requirement
• rowcount
• sql server
• ssis
• usage

How to get rowcount efficiently within a SSIS package?
05 September 07 01:50 AM | SQL Master | 2 Comments   

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 Read More...

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

SQL Server Cursors usage and performance - cursed
19 June 07 07:34 AM | SQL Master | 1 Comments   

If you have a requirement to poll through 'n' number of rows then immediately you would think about Cursors in SQL Server. As the solution using any programming language that loops recordsets to build the attendance list that works ok, but really say Read More...

Filed under: performance, sql server, dmv, databases, table, hints, usage, cursor