Browse by Tags

Cluster resource 'SQL Server (<SQL Server instance name>)' in Resource Group '<Cluster group name>' failed.
13 March 08 09:05 AM | ssqa.net | with no comments

A common mistake by DBAs for missing to check whether all the functionality of tools are working when a SQL Server Cluster environment is setup, though you may not catch hold of few issues with basic failover/failback testing initially but when the application...

Filed under: sql server, best practices, sqlagent, error log, online, dba, failure, active/passive, cluster

SQL Server scrollable server cursors, use them carefully!
10 March 08 07:09 AM | ssqa.net | with no comments

One sentence, if you haven't used the Cursors sensibly then database performance will be cursed! This is for newbie users and DBAs to be aware that on general recommendation is server side cursors are better than client side one, in this you need to be...

Filed under: api, sql server, server, performance, sample, tsql, data, plan guide, result set, cursors, dba