Browse by Tags

• api
• application
• cursor
• databases
• dmv
• heavy
• hints
• memory
• performance
• table
• troubleshoot
• tsql

TSQL cursors vs API cursors - poor cursor usage
27 August 07 06:54 AM | SQL Master | 2 Comments   

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

Filed under: performance, sql server, usage, cursor, application, tsql, api, heavy

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

Handling and troubleshooting memory issues in a SQL Server 2005 instance
19 June 07 02:29 AM | SQL Master | 2 Comments   

We had a major issue on one of the SQL Server instance with the memory and getting following error message intermittenlty: [DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation. Eventually I was able Read More...

Filed under: performance, sql server, dmv, memory, troubleshoot, usage