October 28, 2010 at 12:39 pm
Brandie Tarvin (10/28/2010)
I should have sent Grant some of my eyeballs. Then he'd feel like he was being watched.Or he would have been too busy eating them to talk. @=)
Yeah, I stumble over the word "statistics" badly enough without having a mouth full of sugar.
However, I appreciate the thought.
"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
October 28, 2010 at 12:45 pm
Chad Crawford (10/28/2010)
Steve Jones - SSC Editor (10/27/2010)
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.
Steve,
Which of these is correct:
DELETE FROM Steve WHERE Location = 'Summit'
or
DELETE FROM Summit WHERE Location = 'Blogger Table' AND PersonFullName = 'Steve Jones'
I'm hoping the second, not the first.
Chad
Unfortunately it's the first.
"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
October 28, 2010 at 1:24 pm
Grant Fritchey (10/28/2010)
Brandie Tarvin (10/28/2010)
Waving to Grant across the interwebs while listening to him present on execution plans!Oh, that was you? Sorry I didn't wave back. Man, I need to work on my examples a bit.
I hate talking to a wall for presentations.
Any chance the presentation was recorded. I couldn't watch at work today 🙁
Thanks,
-Luke.
October 28, 2010 at 1:37 pm
Grant Fritchey (10/28/2010)
Chad Crawford (10/28/2010)
Steve Jones - SSC Editor (10/27/2010)
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.
Steve,
Which of these is correct:
DELETE FROM Steve WHERE Location = 'Summit'
or
DELETE FROM Summit WHERE Location = 'Blogger Table' AND PersonFullName = 'Steve Jones'
I'm hoping the second, not the first.
Chad
Unfortunately it's the first.
Drat.
Nice way to ruin my day.
October 28, 2010 at 1:39 pm
Hm, with all the Star Wars avatars around here I'm going to have to dig up a few Star Trek ones.
I believe the Picard Facepalm will be the first I should start with. :rolleyes:
Never 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
October 28, 2010 at 2:02 pm
trying to figure out what I *should* be doing to be most efficient when I want to go digging through some of our data. Don’t know if there are cubes that already exist that I can browse through Excel (as a front-end), or if I should think about creating local SSAS cubes on my machine when I want to go digging (seems like that might be overkill)
Currently trying to extract and analyze about 115k records for emergency room claims in CY2009, which Excel 2007 can hold. However, each record has about 17 fields, which means when I try to pivot that data, I am manipulating almost 2million data fields, and Excel stops working. (assuming the number of fields is why, no formulas involved at all)
I suppose I could look to Access, but I really don’t like Access, so wondering if I can jump up a level and either do what I’m trying to do directly from the DW cubes (which may not have all the elements I need, and I don’t want to go starting a project with IT to fix that, I’m just fishing for data at this point), or potentially create my own cubes in SSAS, which is installed on my box, and run them locally to go digging.
I guess my other option is to create a ton of little pivots, each looking at one or two elements, definitely not a time-saver. Alternately, I just play with it in SQL, without all the pretty colors and pi-charts
Any advice appreciated.
Thanks,
Jon
---------------------------------------------------------
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."
October 28, 2010 at 2:24 pm
jcrawf02 (10/28/2010)
trying to figure out what I *should* be doing to be most efficient when I want to go digging through some of our data. Don’t know if there are cubes that already exist that I can browse through Excel (as a front-end), or if I should think about creating local SSAS cubes on my machine when I want to go digging (seems like that might be overkill)Currently trying to extract and analyze about 115k records for emergency room claims in CY2009, which Excel 2007 can hold. However, each record has about 17 fields, which means when I try to pivot that data, I am manipulating almost 2million data fields, and Excel stops working. (assuming the number of fields is why, no formulas involved at all)
I suppose I could look to Access, but I really don’t like Access, so wondering if I can jump up a level and either do what I’m trying to do directly from the DW cubes (which may not have all the elements I need, and I don’t want to go starting a project with IT to fix that, I’m just fishing for data at this point), or potentially create my own cubes in SSAS, which is installed on my box, and run them locally to go digging.
I guess my other option is to create a ton of little pivots, each looking at one or two elements, definitely not a time-saver. Alternately, I just play with it in SQL, without all the pretty colors and pi-charts
Any advice appreciated.
Thanks,
Jon
With that much data, I'd go SSAS and SSRS, not Excel.
At the very least, set up Excel on a "real computer" (massive number of CPU cores and obscene amounts of RAM).
- 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
October 28, 2010 at 2:42 pm
Grant Fritchey (10/28/2010)
Yeah, I stumble over the word "statistics" badly enough without having a mouth full of sugar.
At least you didn't take on an hour and a half presentation solely on statistics. First time I did my stats presentation (to the local usergroup) I managed to mangle the word at least half the times I tried saying it.
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
October 28, 2010 at 2:44 pm
jcrawf02 (10/28/2010)
trying to figure out what I *should* be doing to be most efficient when I want to go digging through some of our data. Don’t know if there are cubes that already exist that I can browse through Excel (as a front-end), or if I should think about creating local SSAS cubes on my machine when I want to go digging (seems like that might be overkill)Currently trying to extract and analyze about 115k records for emergency room claims in CY2009, which Excel 2007 can hold. However, each record has about 17 fields, which means when I try to pivot that data, I am manipulating almost 2million data fields, and Excel stops working. (assuming the number of fields is why, no formulas involved at all)
I suppose I could look to Access, but I really don’t like Access, so wondering if I can jump up a level and either do what I’m trying to do directly from the DW cubes (which may not have all the elements I need, and I don’t want to go starting a project with IT to fix that, I’m just fishing for data at this point), or potentially create my own cubes in SSAS, which is installed on my box, and run them locally to go digging.
I guess my other option is to create a ton of little pivots, each looking at one or two elements, definitely not a time-saver. Alternately, I just play with it in SQL, without all the pretty colors and pi-charts
Any advice appreciated.
Thanks,
Jon
It depends....
If you have access to production cubes, seeing what they have available is a good start.
What you see as possibly missing might be a starting point for doing more in Excel.
I'd just see what difference half the columns makes and go from there.
You should be able to determine some are nothing more than very bottom level detail, and not needed for initial exploration.
In SQL, you might want to play with PIVOT depending on your version of SQL.
SSAS locally - depends on how familiar you are with SSAS.
Colors and Pie charts? That comes later - a grid is fine for exploring.
Maybe your local machine could use more RAM. 😛
2 GB seems a pretty bare minimum these days.
Greg E
October 28, 2010 at 2:46 pm
GilaMonster (10/28/2010)
Grant Fritchey (10/28/2010)
Yeah, I stumble over the word "statistics" badly enough without having a mouth full of sugar.At least you didn't take on an hour and a half presentation solely on statistics. First time I did my stats presentation (to the local usergroup) I managed to mangle the word at least half the times I tried saying it.
I have trouble with that word sometimes.
I lead Bible studies quite often and I avoid anything in Thessalonians because I can't say it.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 28, 2010 at 2:50 pm
Jack Corbett (10/28/2010)
GilaMonster (10/28/2010)
Grant Fritchey (10/28/2010)
Yeah, I stumble over the word "statistics" badly enough without having a mouth full of sugar.At least you didn't take on an hour and a half presentation solely on statistics. First time I did my stats presentation (to the local usergroup) I managed to mangle the word at least half the times I tried saying it.
I have trouble with that word sometimes.
I lead Bible studies quite often and I avoid anything in Thessalonians because I can't say it.
Threadalonians? 😛
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]
October 28, 2010 at 2:55 pm
Looks like Celko is at it again.
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
October 28, 2010 at 2:55 pm
Craig Farrell (10/28/2010)
Hm, with all the Star Wars avatars around here I'm going to have to dig up a few Star Trek ones.I believe the Picard Facepalm will be the first I should start with. :rolleyes:
Nice. Now we have Star Trek, Star Wars and Babylon 5 represented
Know which episode that was from?
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
October 28, 2010 at 3:01 pm
Ray K (10/28/2010)
Looks like Celko is at it again.
Why don't you tell him that his first sentence is not Standard English? 😛
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]
October 28, 2010 at 3:05 pm
Ray K (10/28/2010)
Looks like Celko is at it again.
Ouch... Steve, this guy might be good but he is going to scare away OPs. Better have a talk with him. That forum was for Newbies. You cant talk to someone like that...
-Roy
Viewing 15 posts - 20,986 through 21,000 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply