Browse by Tags

• api
• blocking
• cursor
• heavy
• high cpu
• msdn
• oltp
• query
• queue
• roles
• security
• sql server
• table
• tsql
• usage
• wait

Performance - check whether it is affecting application or system, don't blame SQL Server alone
03 September 07 07:42 AM | SQL Master | 2 Comments   

Its a general assumption that whenever performance is degraded, the finger will be pointed to SQL Server, pretty easy eh!? If you look at any of the SQL Server related forums then 3 in 10 questions asks same question and nothing but shove blame on SQL Read More...

Filed under: performance, sql server, security, query, wait, blocking, table, application, oltp, high cpu, queue

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

Using Application roles and security - SQL Server 2005
19 June 07 01:30 PM | SQL Master | 1 Comments   

In SQL Server, you can create database roles for easier administration of permissions in a database. Instead of granting individual permissions to each user separately, you can group users with the same permission needs by making them members of the same Read More...

Filed under: performance, sql server, security, roles, msdn, application