Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation.

A call to cursor.rowIdColumns('table_name', None, None, False): passes an empty table name string into the stored proc call on sql server, this doesn't change if I explicitly set the catalog and ...