SQL performance tuning is probably one of those things you can do to really make a HUGE difference in performance. Let’s put this in perspective: take a typical application, if you can improve the performance by 100% then you really made a huge improvement. You can improve a SQL query by 1000% with 2 lines of code (sometimes all you have to do is ...

Note from my manager: ''All, It looks like we have some book money left for this year that we can spend. Please select 2 books each that you have wanted and send the titles to me and I’ll get them on the list.'' Very nice, I picked the following two books below. The Art of SQL SQL Server 2005 Practical Troubleshooting: The Database Engine What ...

I am a big fan of Inside Microsoft SQL Server 2005 The Storage Engine so when I saw that yet another book got published in this series I just had to check it out. Inside Microsoft SQL Server 2005: Query Tuning and Optimization is very well written gets to the point and give you the answers that you need. I decided to contact Kalen to see if she ...