Browse by Tags

• best practice
• blogs
• dba
• dmf
• microsoft
• performance
• security
• slow query
• sql server
• ssms
• technet

SQL Server: How do I identify the queries that are worth tuning?
16 November 07 06:02 AM | SQL Master | 2 Comments   

Have you ever asked this question about how do I identify the queries that worth tuning? The simple answer it is neither easy or hard to obtain such information if you have managed your SQL Server by deploying industry best practices (wherever possible). Read More...

Filed under: performance, sql server, microsoft, management, dmv, dba, best practice, blogs, technet, slow query

How to find list of DMVs & DMFs?
31 May 07 07:22 AM | SQL Master | 1 Comments   

As most of blogs in this section travels through usage of Dynamic Management Views (DMV) & Dynamic Management Functions (DMF) I have had an email asking What is DMV & DMF and how to find list of them from a SQL Server instance. The internal mechanism Read More...

Filed under: performance, sql server, microsoft, management, dmv, dmf, dba

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