September 23, 2010 at 7:50 am
Dave Ballantyne (9/23/2010)
But his results did get better after removing 90% of the data.
Hmmm - haven't tried that method. I think I will on a couple of our larger tables (insert devil emoticon)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 23, 2010 at 7:51 am
Dave Ballantyne (9/23/2010)
GilaMonster (9/23/2010)
Dave Ballantyne (9/23/2010)
But his results did get better after removing 90% of the data.Yeah, surprising that. (not)
I must add that to my optimisation advice. "Try adding this index. If it doesn't work (or you think it won't work), delete 90% of the data from the table"
Hmm....
Working on a new presentation , "Table truncation for optimization" . Its got a nice ring to it 🙂
Add it to the list of presentationsforPASSSummitt
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 23, 2010 at 7:54 am
Any opinions on just getting rid of say 40% of the data? If you're trying to get a hundred rows out of 150 million, cutting it down to 90 million is bound to help. Right?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2010 at 7:55 am
The Dixie Flatline (9/23/2010)
Any opinions on just getting rid of say 40% of the data? If you're trying to get a hundred rows out of 150 million, cutting it down to 90 million is bound to help. Right?
Not significantly enough;-)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 23, 2010 at 8:25 am
Dave Ballantyne (9/23/2010)
But his results did get better after removing 90% of the data.
Now that's a query tuning hint I had not heard before.
September 23, 2010 at 8:33 am
This has to be one of the best questions I've seen anyone ask the OP.
Q: "Do you have access to the Internet????"
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]
September 23, 2010 at 8:37 am
Alvin Ramard (9/23/2010)
This has to be one of the best questions I've seen anyone ask the OP.Q: "Do you have access to the Internet????"
LOL
It sometimes is the best question. LMGTFY seems to be a frequent occurrence here. Though, I strongly believe that the ability to google the answer or find it in BOL is one of the skills of a senior level person (or one who can become senior level).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 23, 2010 at 8:55 am
Part of the problem is just knowing the terminology. Newbies have to phrase their objective without buzzwords or technical terms of art.
building a comma separated string (concatenate)
converting rows to columns (PIVOT/UNPIVOT/crosstab/CASE)
finding the order row with the latest date for each customer (MAX or TOP)
last sunday in the month (DATEADD, DATEDIFF, calendar table)
The problem with the last three examples above is that you literally have to know what the answer are to search for them. Anybody have any other examples.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2010 at 8:58 am
CirquedeSQLeil (9/23/2010)
The Dixie Flatline (9/23/2010)
Any opinions on just getting rid of say 40% of the data? If you're trying to get a hundred rows out of 150 million, cutting it down to 90 million is bound to help. Right?Not significantly enough;-)
I was being sarcastic, Jason. 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2010 at 9:43 am
The Dixie Flatline (9/23/2010)
CirquedeSQLeil (9/23/2010)
The Dixie Flatline (9/23/2010)
Any opinions on just getting rid of say 40% of the data? If you're trying to get a hundred rows out of 150 million, cutting it down to 90 million is bound to help. Right?Not significantly enough;-)
I was being sarcastic, Jason. 😉
To which I say "Not significantly enough"
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 23, 2010 at 9:47 am
The Dixie Flatline (9/23/2010)
Part of the problem is just knowing the terminology. Newbies have to phrase their objective without buzzwords or technical terms of art.building a comma separated string (concatenate)
converting rows to columns (PIVOT/UNPIVOT/crosstab/CASE)
finding the order row with the latest date for each customer (MAX or TOP)
last sunday in the month (DATEADD, DATEDIFF, calendar table)
The problem with the last three examples above is that you literally have to know what the answer are to search for them. Anybody have any other examples.
You should still get results for those searches because the text or similar text, except maybe "last Sunday in the month", should appear in the body of a blog post or article. Of course, I haven't tried those searches yet.
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
September 23, 2010 at 10:20 am
CirquedeSQLeil (9/23/2010)
The Dixie Flatline (9/23/2010)
CirquedeSQLeil (9/23/2010)
The Dixie Flatline (9/23/2010)
Any opinions on just getting rid of say 40% of the data? If you're trying to get a hundred rows out of 150 million, cutting it down to 90 million is bound to help. Right?Not significantly enough;-)
I was being sarcastic, Jason. 😉
To which I say "Not significantly enough"
I just reported you to Steve for this Jason. I hit the "Report" button instead of "Quote" by mistake, but then thought "Hey, why not?"
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2010 at 10:40 am
Jason, be nice. You're hurting Bob's feelings.
Bob, remember that Jason controls all the slot machines in Las Vegas and you might want to win someday
September 23, 2010 at 11:05 am
Steve Jones - Editor (9/23/2010)
Jason, be nice. You're hurting Bob's feelings.Bob, remember that Jason controls all the slot machines in Las Vegas and you might want to win someday
Slots, tables and eye in the sky 😉
But because of that, I can't gamble 😀
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 23, 2010 at 11:34 am
If I wanted to gamble on slots, Tunica is close enough.
I don't gamble a lot either, Jason, and my preferred game is actually poker for reasonable stakes.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
Viewing 15 posts - 19,201 through 19,215 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply