SQL Server Performance Tuning

Save Space To Boost SQL Server Performance

It’s easy to become complacent about saving disk space when hard disk sizes keep growing and disk prices keep on dropping, but saving a few bytes here and there can help improve SQL Server’s performance considerably.If you have ever looked at an Execution Plan for a SQL Server query (and if you haven’t, you should!) […]

Upgrade to SQL Server 2000 SP1 for Improved Performance

All service packs includes numerous fixes to resolve various problems that Microsoft has found since the initial release of the product, and the recent release of SP1 for SQL Server 2000 is no different. What many people may not realize is that many of the fixes included with service packs affect performance. So not only […]

Speed Tips For SQL Server SELECT Statements

You can code a SQL SELECT statement in a number of ways to get the same results, but some versions of the same query may perform better than others. In this article we will look at ways to exploit this.Here is a query that I cut-and-pasted straight out of SQL 7 Books Online. The query […]

Use SET STATISTICS IO and SET STATISTICS TIME to Help Tune Your SQL Server Queries

This is not an article on how to tune queries (that subject would take a book), but an article on how to use the often overlooked Transact-SQL SET STATISTICS IO and the SET STATISTICS TIME commands to help us tune our queries.On the surface, the goal of performance tuning a query seems simple enough. Essentially, […]

Speed Up SELECT DISTINCT Queries

Many people use the DISTINCT option in a SELECT statement to filter out duplicate results from a query’s output. Take this simple PUBS database query as an example:SELECT DISTINCTau_fname,au_lnameFROM authorsIn a simple SELECT from one table (like the one above) this is the easiest and quickest way of doing things.However, with a more complex query […]

Eliminate the Use of Temporary Tables For HUGE Performance Gains

As queries become more complex, temporary tables are used more and more. While temporary table may sometimes be unavoidable, they can often be sidestepped by using derived tables instead. In brief, a derived table is the result of using another SELECT statement in the FROM clause of a SELECT statement. By using derived tables instead of […]

Not All SQL Server Indexes Are Created Equal

If you have much experience with indexes at all, you are probably already familiar with the difference between clustered and non-clustered indexes. But this article is not about them. This article is about whether or not the SQL Server Query Optimizer will use your carefully crafted indexes. You may not be aware of this, but […]

Getting The Best From The SQL Server Index Tuning Wizard

The Index Tuning Wizard is a handy tool shipped as part of the SQL Server 7.0 and SQL Server 2000 Profiler that can analyze a set of SQL queries and suggest index changes that could improve their performance. Here, I will take a look at how to get the best results out of using the […]

The Importance of E-Commerce, DSS and OLTP Database End-User Service Level Analysis

This is an interesting article from the president of SQL Power Tools, which produces tools for SQL Server (and other databases) that can be used to measure database end-user service levels. If you don’t know what an end-user database service level is, then you need to read this article. Before reading this article, I was […]

Using XML To Supercharge Website Performance

With the advent of XML, we have the ability to supercharge our websites with huge performance increases. XML allows us to separate code, content, and presentation. Web developers now have three separate files which in turn will create the HTML that we output. Since the content is in a distinct file separate from the code […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |