MS-SQL Server Tuning Books

Any recommendations?

[woop01]

I’ve got a 1GB MS-SQL Server database (much more when counting the transaction logs) that I manage myself for my website. I had absolutely no training in DBA when this database began growing from the 2MB Access preemie that it was two years ago, into this monster that continues to grow every day. To make a long story short, I need to get better at server tuning. I know how to make stored procedures and the basics of how to change indexes based on query analyzer results but I need a lot better info.

Does anybody have a recommendation for a book that focuses primarily on MS-SQL Server tuning and not just basic database management?

[webdevsf]

you are entering a dark, evil world. Good luck. :)

#1. Start by reading every article on sql-server-performance.com

#2. Buy Karen Delaney's book: Inside Sql Server 2000 and read it cover to cover 3x.

#3. Read microsoft.public.sqlserver.* (especially .programming) every day.

#4. Sql For Smarties by Joe Celko is good for getting a good sense of set based programming (very important for optimizing sql)

#5. the Books on Line (BOL) has a lot of good info tucked away in there.