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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 15 posts - 4,876 through 4,890 (of 66,000 total)
You must be logged in to reply to this topic. Login to reply