Browse by Tags

"A significant part of sql server process memory has been paged out. This may result in a performance degradation." - what it is about?

Published 24 July 7 3:25 AM | SSQA.net

As you might come across this BlogPost here but still there are more doubts to be cleared on the reasons for granting Lock Memory in Pages option to the SQL server instance. There is still lot of confusion over there to check whether lock memory in pages...

Filed under: performance, memory, msdn, security, schema, lock, pages

Using Application roles and security - SQL Server 2005

Published 19 June 7 3:30 PM | SSQA.net

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

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