I need to sharpen my performance tuning skills... fast. Does anyone know of
a good book for this? I don't need a book to tell me where to put Indexes. I
need a book that will tell me "if you see this in the Graphical Eecution
Plan, re-write your code like this". Is there such a thing?
Also, is it possible to be a top notch query tuner without being a top notch
Developer? Im not a top notch Developer, but the query tuning is defiantley
on my shoulders. Ive always gotten by... but want to take these skills to
the next level.
TIA, ChrisR"ChrisR" <noemail@.bla.com> wrote in message
news:#Qidm24ZFHA.3596@.tk2msftngp13.phx.gbl...
> I need to sharpen my performance tuning skills... fast. Does anyone know
of
> a good book for this? I don't need a book to tell me where to put Indexes.
I
> need a book that will tell me "if you see this in the Graphical Eecution
> Plan, re-write your code like this". Is there such a thing?
> Also, is it possible to be a top notch query tuner without being a top
notch
> Developer? Im not a top notch Developer, but the query tuning is
defiantley
> on my shoulders. Ive always gotten by... but want to take these skills to
> the next level.
>
> TIA, ChrisR
>
I don't know of any good books...
This site is excellent however.
http://www.sql-server-performance.com
Rick Sawtell
MCT, MCSD, MCDBA|||I would recomment SQL Server Query Performance Tuning Distilled (orginally
from Curlingstone publishers, now from Apress I think).
I found that an excellent book. I think the way you get to the next level is
through experience, you wont get that in any book. Books can only take you s
o
far, they are excellent to a point.
Also, for those kind of questions "if you see this in the Graphical Eecution
> Plan, re-write your code like this" you'll get the best advice from forums like th
is one.
"ChrisR" wrote:
> I need to sharpen my performance tuning skills... fast. Does anyone know o
f
> a good book for this? I don't need a book to tell me where to put Indexes.
I
> need a book that will tell me "if you see this in the Graphical Eecution
> Plan, re-write your code like this". Is there such a thing?
> Also, is it possible to be a top notch query tuner without being a top not
ch
> Developer? Im not a top notch Developer, but the query tuning is defiantle
y
> on my shoulders. Ive always gotten by... but want to take these skills to
> the next level.
>
> TIA, ChrisR
>
>|||Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook
Ken England
http://search.barnesandnoble.com/bo...555582419&itm=5
"ChrisR" <noemail@.bla.com> wrote in message
news:%23Qidm24ZFHA.3596@.tk2msftngp13.phx.gbl...
> I need to sharpen my performance tuning skills... fast. Does anyone know
of
> a good book for this? I don't need a book to tell me where to put Indexes.
I
> need a book that will tell me "if you see this in the Graphical Eecution
> Plan, re-write your code like this". Is there such a thing?
> Also, is it possible to be a top notch query tuner without being a top
notch
> Developer? Im not a top notch Developer, but the query tuning is
defiantley
> on my shoulders. Ive always gotten by... but want to take these skills to
> the next level.
>
> TIA, ChrisR
>|||Great book... it has practical examples that illustrate the material
covered.
I recommend it also!
"NH" <NH@.discussions.microsoft.com> wrote in message
news:AF77B42A-4151-4611-B56A-05C3A4FA94EF@.microsoft.com...
> I would recomment SQL Server Query Performance Tuning Distilled (orginally
> from Curlingstone publishers, now from Apress I think).
> I found that an excellent book. I think the way you get to the next level
is
> through experience, you wont get that in any book. Books can only take you
so
> far, they are excellent to a point.
> Also, for those kind of questions "if you see this in the Graphical
Eecution
forums like this one.
> "ChrisR" wrote:
>
of
Indexes. I
notch
defiantley
to|||I think I'm gonna go with this one. I was just reading Amazon reviews on
this and several other books on this topic. A lot of reviews for this book
mention that screen prints are provided of the Exec Plan, Profiler, etc.
Therefore its not just theoretical, but practical. Too much theory puts me
to sleep.
Thanks guys.
"Armando Prato" <aprato@.REMOVEMEkronos.com> wrote in message
news:u5dAkH7ZFHA.3400@.tk2msftngp13.phx.gbl...
> Great book... it has practical examples that illustrate the material
> covered.
> I recommend it also!
> "NH" <NH@.discussions.microsoft.com> wrote in message
> news:AF77B42A-4151-4611-B56A-05C3A4FA94EF@.microsoft.com...
(orginally
level
> is
you
> so
> Eecution
> forums like this one.
know
> of
> Indexes. I
Eecution
> notch
> defiantley
> to
>
sql
