February 28, 2011 at 7:59 am
I am trying to find some good books to read about sql server performance. I am interested in learning about it so that when I write queries I know how to write it so that it won't take long to run it and doesn't take much resources. Please let me know.
February 28, 2011 at 8:09 am
Read articles from http://www.sql-server-performance.com/ ..It has all useful info on writing tuned queries.
February 28, 2011 at 8:10 am
Grant Fritchey has written a very good one
February 28, 2011 at 11:00 am
Writing the queries is only half of the equation. The other half (and arguably the more important half) is the database design itself.
The probability of survival is inversely proportional to the angle of arrival.
February 28, 2011 at 1:15 pm
In terms of queries, the most important thing would be to write them well to begin with. I'd take a look at Itzik Ben-Gan's TSQL Querying book. There are some excellent articles here on SSC and over on simple-talk.com.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply