Browse by Tags

• best practice
• best practices
• cache
• cpu
• dba
• disk space
• disks
• dml
• dmv
• engine
• filtered
• force
• guide
• hardware
• hints
• index
• indexed view
• indexes
• knowledge
• parallel execution
• partition
• performance monitoring
• query
• reindexing
• security
• sorting
• sql server
• statiscs age
• statistics
• tsql
• update statistics

Quick tips & tricks on fine tuning performance problem on a SQL Server instance.
06 October 08 02:51 AM | SQL Master | 2 Comments   

Few months ago I had an excellent opportunity to learn and share the knowledge within SQL Server performance tuning, Tech-Ed Online talks [remember Tech-ed Online Panel: Leveraging ... ]. Same in the series Amit Bansal, SQL Server MVP from India and myself Read More...

Filed under: performance, sql server, query, optimization, hints, performance monitoring, best practices, knowledge, engine

SQL Server Performance - consideration on unique index or filtered index.
25 September 08 12:46 AM | satyaskj | 2 Comments   

It is no doubt that when a database consists ' well-designed ' indexes can reduce disk I/O operations and consume fewer system resources therefore improving query performance. You might be wondering I'm going back to basics for indexes! So when the database Read More...

Filed under: performance, sql server, indexes, optimization, indexed view, statiscs age, dml, filtered

Considering Parallel plans and forcing plans for better performance
23 October 07 06:55 AM | SQL Master | 2 Comments   

Parameterizing T-SQL queries are a well-known task such as database programming and best practice in some tasks. It allows query plan reuse and eliminates the need of recompilation for multiple invocations of the same query that simply has different parameter Read More...

Filed under: performance, sql server, cache, optimization, cpu, index, partition, parallel execution, force, guide

Disk Space Requirements for Index DDL Operations
28 September 07 06:38 AM | SQL Master | 3 Comments   

Are you watching your disk space during the indexes operations where these database objects are stored? Recently I was stumped on a database that is only 5GB had reindexing process failure due to 10% of disk free space was available. For your information Read More...

Filed under: performance, sql server, indexes, optimization, dba, hardware, disks, best practice, reindexing, disk space, sorting

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