Tuesday, June 19, 2007 - Posts

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

Understanding the latest SQL Server TPC H scores
19 June 07 10:30 AM | SQL Master | 1 Comments   

Cross post from AskASQLGuru site. Read More...

Filed under: performance, upgrade, sql server, tpc

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