Browse by Tags

• best practice
• management
• monitoring
• optimization
• package
• performance
• public
• query
• server state
• sql server
• ssms
• statistics
• tsql
• update statistics
• users
• view

SQL Server 2005: Deny Server-Level Dynamic Management Views to public group
21 December 07 06:47 AM | SQL Master | 2 Comments   

As you are aware DMV - Dynamic management views are very good to provide server-level information and some of them with detailed information on the execution environment of the database engine. Just to introduce about DMVs, there are two types of dynamic Read More...

Filed under: performance, sql server, security, package, dmv, users, view, best practice, monitoring, public, server state

Usage and good practices with UPDATE STATISTICS feature in SQL 2005
23 July 07 03:39 AM | SQL Master | 1 Comments   

UPDATE STATISTICS is very helpful to get the performance by updating the distribution of key values for one or more statistics groups or set of collections in the specified table or indexed view. So how this is handled within the SQL Server, you may be Read More...

Filed under: performance, security, query, dmv, optimization, tsql, statistics, update statistics

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