Browse by Tags

• cache
• connect
• databases
• dmv
• drop
• performance
• plan
• query
• schema
• security
• sql server
• studio

The database principal owns a schema in the database, and cannot be dropped'
13 July 07 01:10 AM | SQL Master | 0 Comments   

Check this FAQ post for further resolution. Read More...

Filed under: ssms, security, management, databases, drop, studio, schema

How to find that a query could benefit from an index?
30 April 07 03:48 AM | SQL Master | 0 Comments   

Performance is most required achievement in a multi-user environment, using SQL Server 2005 this can be achieved with a few statments execution. Firstly you need determine the issues by finding which query or queries are causing issues in achieving performance. Read More...

Filed under: ssms, performance, sql server, security, management, dmv

Recompile all the stored procedures
27 April 07 06:42 AM | SQL Master | 0 Comments   

There has been many instances of requests from the Developers to recompile a set of Stored Procedures on one of the mission critical databases, due to the performance issues the relevant SPs have been fine tuned for optimum performance. In order to take Read More...

Filed under: ssms, performance, sql server, connect, management, cache

Execution plans caching and how SQL optimizer reuses for better performance
25 April 07 01:16 PM | SQL Master | 1 Comments   

Memory plays important role in Performance on a windows based platform, SQL Server 2005 features has a pool of memory that is used to store both execution plans and data buffers, only the part of memory is used to store execution plans that we call as Read More...

Filed under: ssms, performance, sql server, management, query, plan