May 27, 2009 at 5:25 am
Lynn Pettis (5/26/2009)
OMG, you really have to be kidding here...
As a complete and totally unrelated aside: -
There's a character called Trigger in the BBC comedy Only Fools 'n' Horses http://www.bbc.co.uk/comedy/onlyfools/uncovered/trigger.shtml
Why 'Trigger' - I always thought it was because he was sooo intellectually quick witted.
May 27, 2009 at 6:52 am
Well, Trigger is something I am always vary off... I have seen people write whole business logic on triggers on a high transaction DBs and mess up the performance.... Maybe we should all be vary of people with the name Trigger... :hehe:
-Roy
May 27, 2009 at 6:53 am
Paul White (5/27/2009)
Right then.Given the wealth of knowledge and talent around these parts, who's up for writing the perfect collaborative-effort book on indexing?
We could all get fabulously rich!!! :w00t:
Paul
How would we go about starting this particular project? I think it would be a great idea. 😉
May 27, 2009 at 6:56 am
Paul White (5/27/2009)
Right then.Given the wealth of knowledge and talent around these parts, who's up for writing the perfect collaborative-effort book on indexing?
We could all get fabulously rich!!! :w00t:
Paul
You guys write a book on indexing and performance tuning, You have the first customer to buy it... Thats me. I know little about indexing and performance tuning. Not much. So I would love to learn more on it.
-Roy
May 27, 2009 at 7:27 am
Roy Ernest (5/27/2009)
Paul White (5/27/2009)
Right then.Given the wealth of knowledge and talent around these parts, who's up for writing the perfect collaborative-effort book on indexing?
We could all get fabulously rich!!! :w00t:
Paul
You guys write a book on indexing and performance tuning, You have the first customer to buy it... Thats me. I know little about indexing and performance tuning. Not much. So I would love to learn more on it.
Roy have you forgot about the books from Grant Fritchey - "SQL Server 2008 Query Performance Tuning Distilled" and "Dissecting SQL Server Execution Plans"
-------------------------------------------------------------
"It takes 15 minutes to learn the game and a lifetime to master"
"Share your knowledge. It's a way to achieve immortality."
May 27, 2009 at 7:31 am
Doc (5/27/2009)
Roy have you forgot about the books from Grant Fritchey - "SQL Server 2008 Query Performance Tuning Distilled" and "Dissecting SQL Server Execution Plans"
Gail was still right. There is not a single source for detailed information about indexes and indexing. Certainly that kind of serious detail won't be found in my books.
But hey, if all of you want to buy a copy (or seven) of the books, please, feel free.
"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
May 27, 2009 at 7:39 am
Grant Fritchey (5/27/2009)
Gail was still right. There is not a single source for detailed information about indexes and indexing. Certainly that kind of serious detail won't be found in my books.
And the problem is I doubt most publishers would want to touch something like that. It's a very specialised topic and not too many people (relatively) would want a book on nothing but indexing. More likely would buy something like your perf book, that has a bit on indexing (enough for most cases) and lots of other stuff.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 27, 2009 at 7:39 am
Hey Grant, I did not know that you brew your own beer... :w00t:
I was planning to write another article (Another miserable try 🙂 ) but that will have to wait. I want to read the "Dissecting SQL Server Execution Plans" first. 🙂
-Roy
May 27, 2009 at 7:50 am
GilaMonster (5/27/2009)
And the problem is I doubt most publishers would want to touch something like that. It's a very specialised topic and not too many people (relatively) would want a book on nothing but indexing. More likely would buy something like your perf book, that has a bit on indexing (enough for most cases) and lots of other stuff.
Actually, I do know of a publisher that tackles those specialized little books. They've put out one on Profiler and one on execution plans. I suspect they might be interested in doing one on indexes, especially if the right names were attached.
HOWEVER, I'm not volunteering for this (right now anyway). I promised the family, no book projects until after the summer. Apparently I get cranky while I'm working on a book.
"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
May 27, 2009 at 7:52 am
There's a response in this thread that maybe we should use more often.
😎
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 27, 2009 at 7:55 am
Grant Fritchey (5/27/2009)
Actually, I do know of a publisher that tackles those specialized little books. They've put out one on Profiler and one on execution plans. I suspect they might be interested in doing one on indexes, especially if the right names were attached.
Oh, them. Hmmm
HOWEVER, I'm not volunteering for this (right now anyway). I promised the family, no book projects until after the summer. Apparently I get cranky while I'm working on a book.
I wouldn't mind giving it a shot, however it's ramping up to the busy time of the year, TechEd in Aug and PASS in Nov, and usually work picks up massively just after TechEd. Plus there's a 'project' I'm involved in that's going to suck up a fair bit of July.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 27, 2009 at 8:00 am
May 27, 2009 at 8:01 am
May 27, 2009 at 8:05 am
GilaMonster (5/27/2009)
Grant Fritchey (5/27/2009)
Actually, I do know of a publisher that tackles those specialized little books. They've put out one on Profiler and one on execution plans. I suspect they might be interested in doing one on indexes, especially if the right names were attached.Oh, them. Hmmm
HOWEVER, I'm not volunteering for this (right now anyway). I promised the family, no book projects until after the summer. Apparently I get cranky while I'm working on a book.
I wouldn't mind giving it a shot, however it's ramping up to the busy time of the year, TechEd in Aug and PASS in Nov, and usually work picks up massively just after TechEd. Plus there's a 'project' I'm involved in that's going to suck up a fair bit of July.
I've never written a book. What would be the process of doing a group project like this? I wouldn't mind assisting in some way to make it happen, just don't know where to start.
May 27, 2009 at 8:06 am
GilaMonster (5/27/2009)
I wouldn't mind giving it a shot, however it's ramping up to the busy time of the year, TechEd in Aug and PASS in Nov, and usually work picks up massively just after TechEd. Plus there's a 'project' I'm involved in that's going to suck up a fair bit of July.
Assuming someone else doesn't take it on (Gus, Paul, Jeff), after November I might consider trying to help a bit. I'm not sure I've got the level of knowledge required, but I'm crazy enough to try anyway.
"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 15 posts - 4,876 through 4,890 (of 66,749 total)
You must be logged in to reply to this topic. Login to reply