.: Table Type Top Related Articles
1). Eliminating cursor in SQL Server
We all know how cursors are slow and how badly they tend to issue a lock on part of the table, or on the whole table, during its execution. To explain exactly what is going on, and what we can do to optimize the performance, here is an example:
Table t_Customers has 3000 records.
Table t_Orders has 1 to 100 records for each record in t_Customers table, making it a table with 65000 records.
Article tags: sql server, eliminating cursor, table type, table variable