Browse Blog Posts by Tags

All Tags » performance » optimization (RSS)

MVP WordPress Blogs

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

Performance and Optimization Isn’t Evil

Donald Knuth is a fairly amazing guy. I consider him one of the most influential contributors to computer science of all time. Unfortunately, most of the time I hear his name, I cringe. This is because it’s typically somebody quoting...

Posted to Reed Copsey, Jr. by on Fri, Sep 9 2011
Filed under: Filed under: Algorithms, Performance, Optimization
SQL Server optimization series - query recompilation gotchas

What causes the query to recompile? Is it a good sign or bad sign for performance? How frequently should I recompile the stored procedures? Does a reindex cause SP to recompile when it is executed next time? These are quick questions raised in the recent...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Apr 5 2011
Filed under: Filed under: sql server, performance, optimization, best practices, stored procedure, query plan, recompile, benchmarking, statiscs age
SQL Server Performance series: Parametrized Index optimization to handle each fragmentation group

As a DBA handling SQL Server platform performance issues is not an easy task in a multi-server and multi-database environment, in order to keep up the availability and scalability it is important to manage the database fragmentation on SQL Server in addition...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sun, Jan 9 2011
Filed under: Filed under: sql server, performance, dba, optimization, best practice, update statistics, index rebuild, reorg
Indexes and UPDATE STATISTICS differences and undocumented options - SQL Server 2005

During an Usergroup meeting one user asked the question that why my query is affected with slow performance when the statistics are upto-date? When asked about the indexes the reply was why do you need indexes when you have updated statistics on all the...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Jan 16 2009
Filed under: Filed under: sql server, performance, indexes, query, optimization, procedure, update statistics, monitoring
Quick tips & tricks on fine tuning performance problem on a SQL Server instance.

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

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Oct 6 2008
Filed under: Filed under: sql server, performance, query, optimization, best practices, hints, knowledge, performance monitoring, engine
SQL Server Performance - consideration on unique index or filtered index.

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

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Sep 25 2008
Filed under: Filed under: sql server, performance, indexes, optimization, indexed view, statiscs age, filtered, dml
New whitepaper available on Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques

Got this update from SQLCAT blog on MSDN about new whitepaper on Analysis Services many-to-many dimensions that helps in MDX query performance optimization steps you need to take care. Many-to-many dimension relationships in SQL Server 2005 Analysis Services...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Jan 2 2008
Filed under: Filed under: sql server, performance, msdn, bi, download, optimization, whitepaper, Analysis Services, sqlcat
Considering Parallel plans and forcing plans for better performance

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

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Oct 23 2007
Filed under: Filed under: sql server, performance, optimization, cache, index, cpu, partition, guide, parallel execution, force
Disk Space Requirements for Index DDL Operations

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

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Sep 28 2007
Filed under: Filed under: sql server, performance, indexes, dba, optimization, disk space, best practice, hardware, disks, sorting, reindexing
XLOCK Hint is ignored even though specifying explictly?

Interesting newbie question on the forums to share. I am selecting a value from a table(column).I do not want any 2 users can select same value at the same time..in other word 1 value only be selected by individual user. in order to do it I am simply...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Sep 11 2007
Filed under: Filed under: sql server, performance, optimization, hints, statistics, locking, results, xlock
FULLTEXT catalogs and BACKUP - behaviour in SQL Server 2005

There should be no special consideration to perform BACKUP activities within your SQL Server environment. But if you are using FTS with full-text indexes/catalogs then you should be concerned about point-in time recoverability with the backups. You may...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Aug 2 2007
Filed under: Filed under: performance, backup, optimization, disk space, full-text
Usage and good practices with UPDATE STATISTICS feature in SQL 2005

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

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Jul 23 2007
Filed under: Filed under: performance, security, dmv, query, optimization, tsql, statistics, update statistics

Page 1 of 1 (12 items)

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.