Tutorial for speeding up SQL queries? | ansaurus

tags:

views:

45

answers:

2

Q:

Tutorial for speeding up SQL queries?

Is there a good tutorial out there how to speed up/refactor SQL Queries? I googled a bit, but did not find anything useful.

Thanks :-)

+2 A:

SQL performance tuning By Peter Gulutzan, Trudy Pelzer

SQL Performance and Tuning Considerations

Pranay Rana 2010-09-13 08:01:55

A:

A good general knowledge book is:

The Art of SQL by Stephane Faroult

Rawheiser 2010-09-13 15:23:54

related questions

Backup SQL Schema Only?

Sql to query a dbs scheme

Timer-based event triggers

Sql query, count and group by

Paging SQL Server 2005 Results

SQL 2005 For XML Explicit - Need help formatting

How do I use T-SQL Group By

What all do I need to escape when sending a (My)SQL query?

Split String in SQL

Datatable vs Dataset

ASP.NET MVC "CRUD" Database Sample

Convert HashBytes to VarChar

Best Book for a new Database Developer

What is the best way to avoid SQL injection attacks?

What language do you use for Postgresql triggers and stored procedures?

What is the best way to handle multiple permission types?

How do I index a database field

Swap unique indexed column values in database.

cx_Oracle - what is the best way to iterate over a result set?

cx_Oracle - How do I access Oracle from Python?

Is there a version control system for database structure changes?

How to export data from SQL Server 2005 to MySQL

ASP.NET Site Maps

Decoding T-SQL CAST in C#/VB.net

Flat File Databases in PHP