Are the posted questions getting worse?
-
GilaMonster (10/31/2010)
Just noticed that I missed spotting a milestone. Better (a little) late than neverFreakin' awesome, Gail! If you see a glow in the NorthEast tonight, you know I got a bit carried away with the celebration! 😛 Well done! That and keeping up your own blog, as well. :hehe:
--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) -
jcrawf02 (11/1/2010)
Greg Edwards-268690 (11/1/2010)
jcrawf02 (11/1/2010)
Well, that's kinda the point. I don't know what I don't know yet. It would be nice to have a way to dig through the data by pulling out some elements that I know I'll use detail on if I find something, then mess with those on a aggregate level to see what I can find. For instance, one of the focus studies at work changed direction some, and I thought it might be a bad idea, but until they came up with the final focus list of patients, I wasn't able to really show them WHY it was a bad idea. Now we're stuck in a place where we asked patients to work with us in a study, and yet that study as designed won't accomplish what it is set out to, because we're looking at the wrong set of patients.I suppose that knowing all the elements I'd want to see at the detail level, I should just request IT to have those present in their cube, but I have a hunch that they'll tell me it'll take a year to get them there. And a BRD. And Project approval from on high, because it wasn't in their project list originally, nor was it in the list under review for 2011.
As for the subsets of data, that's true, we have regions/counties/age groups/etc, but I'm not even sure what I'll want to go looking for at this point, and those things may cross those boundaries.
growing pains for me, I've not had the chance to ask fun questions before, always been stuck running the next report, so this is a good thing really. Latest bit of fun was comparing the NYU ED Algorithm against our patient data and seeing how relevant it really is. (hint - not so much, when it's adopted wholesale and not adjusted to fit)
Maybe it's just me - a cube is for aggregate data, which you drill down into the interesting points.
Grid is for mucking around at the lowest levels.
What we do here is expose a couple of hundred attributes as dimensions, with just a few hierarchies, and maybe 500 or 600 measures. Then you have a drill to detail which we've tailored some views on as to what fields to include. I wouldn't think that would be a huge deal for them to expose the fields you might be interested in. But I don't work there.
I did test 2007 at home - x64 bit, 4GB RAM. 121,000 rows, 17 columns out of AW db, about 50/50 dim and measure mix.
Worked subsecond with several roll ups.
Stupid question - are you aware that double clicking on any total cell brings up a new sheet with all the details?
Greg E
-
Greg Edwards-268690 (11/2/2010)
jcrawf02 (11/1/2010)
Greg Edwards-268690 (11/1/2010)
jcrawf02 (11/1/2010)
Well, that's kinda the point. I don't know what I don't know yet. It would be nice to have a way to dig through the data by pulling out some elements that I know I'll use detail on if I find something, then mess with those on a aggregate level to see what I can find. For instance, one of the focus studies at work changed direction some, and I thought it might be a bad idea, but until they came up with the final focus list of patients, I wasn't able to really show them WHY it was a bad idea. Now we're stuck in a place where we asked patients to work with us in a study, and yet that study as designed won't accomplish what it is set out to, because we're looking at the wrong set of patients.I suppose that knowing all the elements I'd want to see at the detail level, I should just request IT to have those present in their cube, but I have a hunch that they'll tell me it'll take a year to get them there. And a BRD. And Project approval from on high, because it wasn't in their project list originally, nor was it in the list under review for 2011.
As for the subsets of data, that's true, we have regions/counties/age groups/etc, but I'm not even sure what I'll want to go looking for at this point, and those things may cross those boundaries.
growing pains for me, I've not had the chance to ask fun questions before, always been stuck running the next report, so this is a good thing really. Latest bit of fun was comparing the NYU ED Algorithm against our patient data and seeing how relevant it really is. (hint - not so much, when it's adopted wholesale and not adjusted to fit)
Maybe it's just me - a cube is for aggregate data, which you drill down into the interesting points.
Grid is for mucking around at the lowest levels.
What we do here is expose a couple of hundred attributes as dimensions, with just a few hierarchies, and maybe 500 or 600 measures. Then you have a drill to detail which we've tailored some views on as to what fields to include. I wouldn't think that would be a huge deal for them to expose the fields you might be interested in. But I don't work there.
I did test 2007 at home - x64 bit, 4GB RAM. 121,000 rows, 17 columns out of AW db, about 50/50 dim and measure mix.
Worked subsecond with several roll ups.
Stupid question - are you aware that double clicking on any total cell brings up a new sheet with all the details?
Greg E
Yes, I'm aware of that one, but with half the RAM, not helping me much. Cubes have been under-utilized here, mostly because it takes so much effort to change things to be useful. Guess I need to work on making that process easier with IT.
---------------------------------------------------------
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."
-
Gianluca earns Sainthood points here.
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden -
Chris Morris-439714 (11/2/2010)
Gianluca earns Sainthood points here.I'll be the first to admit that I usually do not have that much patience.
Alvin Ramard
Memphis PASS Chapter[/url]All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.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]
-
For those who don't know, several of our locals are up for an award at SQLServerPedia for blog posts done over the last year. Gail is in three different categories and looks good to win two of them. I'm in two and actually possibly a contender in one. Please support us, or whoever you think is better, and go vote.
Thanks.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Grant Fritchey (11/2/2010)
For those who don't know, several of our locals are up for an award at SQLServerPedia for blog posts done over the last year. Gail is in three different categories and looks good to win two of them. I'm in two and actually possibly a contender in one. Please support us, or whoever you think is better, and go vote.Thanks.
Both of you seem to have a clear lead in at least one category each. Good luck and congratulations.
Alvin Ramard
Memphis PASS Chapter[/url]All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.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]
-
Alvin Ramard (11/2/2010)
Grant Fritchey (11/2/2010)
For those who don't know, several of our locals are up for an award at SQLServerPedia for blog posts done over the last year. Gail is in three different categories and looks good to win two of them. I'm in two and actually possibly a contender in one. Please support us, or whoever you think is better, and go vote.Thanks.
Both of you seem to have a clear lead in at least one category each. Good luck and congratulations.
I wouldn't say that. There's still a week of voting and the down votes make changes happen quick. Someone can vote up another guy and vote me down and the switch is 2 points in that direction. This one, really doesn't matter, but I'm with Hudson, I like winning, it's better than losing.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
jcrawf02 (11/2/2010)
Greg Edwards-268690 (11/2/2010)
jcrawf02 (11/1/2010)
Greg Edwards-268690 (11/1/2010)
jcrawf02 (11/1/2010)
Yes, I'm aware of that one, but with half the RAM, not helping me much. Cubes have been under-utilized here, mostly because it takes so much effort to change things to be useful. Guess I need to work on making that process easier with IT.Our biggest issues are changing names and making them easy for the user to naturally understand all of them.
Designing a cube to be useful can have it's challenges.
Hopefully they can find the way.
Greg E
-
Ha! This one is for Lynn and others who ref soccer - what NOT to do for the kickoff:
http://runningahospital.blogspot.com/2010/10/sad-news-on-soccer-pitch.html
It's also a good blog by the CEO of Beth Israel in Boston about healthcare in general, Massachusetts in particular, and running a hospital (hence the name)
---------------------------------------------------------
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."
-
jcrawf02 (11/2/2010)
Ha! This one is for Lynn and others who ref soccer - what NOT to do for the kickoff:http://runningahospital.blogspot.com/2010/10/sad-news-on-soccer-pitch.html
Well, if he didn't want to hear the answer, he shouldn't have asked the question!! @=)
-
jcrawf02 (11/2/2010)
Ha! This one is for Lynn and others who ref soccer - what NOT to do for the kickoff:http://runningahospital.blogspot.com/2010/10/sad-news-on-soccer-pitch.html
It's also a good blog by the CEO of Beth Israel in Boston about healthcare in general, Massachusetts in particular, and running a hospital (hence the name)
Now that is funny! Thanks for the laugh (and the advice, I'll be sure I always have a flipping coin with me).
-
Lynn Pettis (11/2/2010)
jcrawf02 (11/2/2010)
Ha! This one is for Lynn and others who ref soccer - what NOT to do for the kickoff:http://runningahospital.blogspot.com/2010/10/sad-news-on-soccer-pitch.html
It's also a good blog by the CEO of Beth Israel in Boston about healthcare in general, Massachusetts in particular, and running a hospital (hence the name)
Now that is funny! Thanks for the laugh (and the advice, I'll be sure I always have a flipping coin with me).
Stupid ref! He should have said: "... closest without going over ..." 😀
I guess he doesn't watch The Price is Right. 😛
Alvin Ramard
Memphis PASS Chapter[/url]All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.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]
-
jcrawf02 (11/2/2010)
Ha! This one is for Lynn and others who ref soccer - what NOT to do for the kickoff:http://runningahospital.blogspot.com/2010/10/sad-news-on-soccer-pitch.html
It's also a good blog by the CEO of Beth Israel in Boston about healthcare in general, Massachusetts in particular, and running a hospital (hence the name)
He asked 11/12-year-olds to guess the age of someone over 20? And was surprised by the results?
I remember being 10 and thinking high school seniors were "adults"!
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
-
GSquared (11/2/2010)
I remember being 10 and thinking high school seniors were "adults"!Heh... they should all leave home while they still think they are. 😛
--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 - 21,076 through 21,090 (of 66,749 total)
You must be logged in to reply to this topic. Login to reply