Browse by Tags

• cursor
• databases
• hints
• memory
• performance
• sql server
• table
• troubleshoot

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