Browse by Tags

All Tags » performance » tsql » usage
  • TSQL cursors vs API cursors - poor cursor usage

    Cursors are based for a definitive purpose, but heavy usage of such methods will prove as costly expense on database performance. The process of cursor is prolonged, as a cursor first has to be defined with its features set, then populated after positioning (scrolled) to a set of record(s) and fetched every time. Finally once the process is ...
    Posted to SQL Server Aggregator (Weblog) by Anonymous on August 27, 2007