Are the posted questions getting worse?
-
Craig Farrell (10/27/2010)
Steve, I did a search (honestly, a brief one) about basic troubleshooting/optimizations for queries that I think would save a lot of headaches if I could just link some folks to it.However, the only articles I seemed to find in the search were #932 and #938... and I'm getting Errors.
I assume there would be a need for an article of that nature? I know Paul White and a number of others have gotten very in depth with deep optimization about a specific thing, but I can't find a generic "Start here, check this, then that, then that" type of thing that a lot of newbie/volunteered DBA's could use.
I'll think about the list you've already posted and see if there's something in there I can tackle intelligently.
Hmm, me too. What were the titles? We have a versioning system and they may have been superceeded. Or dropped. Things below 2k or so were likely migrated from the old system
-
Steve Jones - SSC Editor (10/27/2010)
Hmm, me too. What were the titles? We have a versioning system and they may have been superceeded. Or dropped. Things below 2k or so were likely migrated from the old systemSearch on 'optimization', articles only. They're on the second page.
- Craig FarrellNever stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA -
Grant Fritchey (10/27/2010)
Jeff Moden (10/26/2010)
Again... I was thinking the same thing about missing your session. It's a real bugger that they scheduled us at the same time. I did that review on one of your books and read the other cover-to-cover. It would be good to see you in action.Ya know? We could swap remote live sessions between our two groups. Any interest there? Roy Ernest and I did pretty good on just such a session...
And I was never worthy of such a wonderful review. Thanks though.
Sure, sounds good. Plan that for January or later next year? I think I might have a presentation for December already.
January or February sounds good. Just to be on the safe side, I'll make sure I'm ready for December just in case.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Trey Staker (10/26/2010)
@Gail, how's that difficult contract going?Today's Dilbert made me think of it:
Heh... you have no idea how appropriate that is for me lately. Thanks for the great laugh... I really needed it.:-P
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Steve Jones - SSC Editor (10/27/2010)
Grant Fritchey (10/27/2010)
Look for the tall bald guy in a red vest.Or the hairy legs under a short
skirtkiltGAH!!!! 😀
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Steve Jones - SSC Editor (10/27/2010)
BTW, speaking of technical stuff....I wonder if any of you would be interested in writing to fill holes? I keep finding posts here, and elsewhere that someone answers a question about and we don't have an article on. Like our joyous person today that thinks there is some magical tool to audit the last time a table was accessed.
If you see something like that, and don't have an SSC reference, I'd love a 1 pager that solves the problem for future reference.
Great idea. As a side bar... you may not be able to tell the last time a table was accessed but... you should be able to tell the last time one of the indexes on the table was used which would equate to the same thing.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Brandie Tarvin (10/27/2010)
Steve Jones - SSC Editor (10/27/2010)
Whew, for a second I thought I was going to learn something on The Thread.OMG, someone grab the paramedics. Steve's going into shock because he almost learned something on The Thread!
I learned something QUITE valuable... be careful about Steve's posts... he might talk about tall ugly dudes (heh... sorry Grant :hehe:) in skirts and you have to protect your mind's eye from such, ummmm.... visions. 😉
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Steve Jones - SSC Editor (10/27/2010)
I'll drop some topics out here for you. Here's a couple that I have saved up:- Finding/changing the default backup location
- scheduling a trace
- duplicating the default trace, but larger in size.
- read db files, get logical name, automate restore
- How distinct works in a query with multiple columns
- Ordering months by number (1, 2, 3), but displaying name in a query (Jan, Feb, etc.)
- Find top xx results for each group of a result set. So perhaps top 3 finishers in a race for each class, where the data is in one table and there are multiple classes
First come, first server
I'll be happy to do the "Ordering months by number" thing. Like Lynn says, though, it would really be helpful if we knew what the original post was, if possible.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Alvin Ramard (10/27/2010)
Steve Jones - SSC Editor (10/27/2010)
Whew, for a second I thought I was going to learn something on The Thread.I'm assuming you meant learn something technical, becuase I'm sure you've already learned a few things in here. If nothing else, you learned a few things to avoid. 😀
Hey, and you should have learned a few good jokes too. 😛
From whom, exactly?
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
-
Jeff Moden (10/27/2010)
I'll be happy to do the "Ordering months by number" thing. Like Lynn says, though, it would really be helpful if we knew what the original post was, if possible.Not sure where it is, but I've seen it a few times this year and dropped it on a list. People for some reason don't get the datepart/datename thing. a simple one pager, make up a common example, would suffice. Some code, explain how the functions work, the ordering, etc.
-
Jeff Moden (10/27/2010)
Great idea. As a side bar... you may not be able to tell the last time a table was accessed but... you should be able to tell the last time one of the indexes on the table was used which would equate to the same thing.Doh! (headsmack)
-
BTW, SSC usually has a blogger at the blogger table during the PASS Summit. Usually it's me, someone that can take notes during keynotes and post them. Since I won't be there....
any of you rapid posters want to lug a laptop to the keynote each day and take some notes and post a blog? One a day is fine, more are better, but up to you.
Ping me if you want the spot.
-
OK, sign up for articles. Please just pick one, then another when you finish.
If you have ideas, feel free to post them, but try to pick things you see a couple times in the forums.
-
So, you want fresh topics in that forum, rather then responses to the pinned topic? Just confirming from what I see. When I read the pinned item it seemed more simplistic.
Nice idea though, should get some value there.
- Craig FarrellNever stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA -
Steve Jones - SSC Editor (10/27/2010)
OK, sign up for articles. Please just pick one, then another when you finish.If you have ideas, feel free to post them, but try to pick things you see a couple times in the forums.
As a side bar, I notice you were able to pin a post at the beginning of the new forum. It would be really cool if you could pin a post with links to the two forum "How to post/etiquette" articles by Gail and myself.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Viewing 15 posts - 20,911 through 20,925 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply