January 21, 2016 at 6:01 am
Though I am happy to hear that he feels that he has heard enough to be able to solve it, I am at the same time concerned. Based on his words, I do not really understand what he is going to do now. And based on his combined posts, I am concerned with what the end result will be...
But perhaps I am just worrying too much?
January 21, 2016 at 6:05 am
Hugo Kornelis (1/21/2016)
Though I am happy to hear that he feels that he has heard enough to be able to solve it, I am at the same time concerned. Based on his words, I do not really understand what he is going to do now. And based on his combined posts, I am concerned with what the end result will be...But perhaps I am just worrying too much?
Nah. I suspect the solution is likely to be non-standard. Ah well...
"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
January 21, 2016 at 6:23 am
Two years from now he or his successor are going to be very irritated about their design.
January 21, 2016 at 6:25 am
Brandie Tarvin (1/21/2016)
Two years from now he or his successor are going to be very irritated about their design.
I love a good understatement.
I get very irritated when we run out of milk for my coffee. When I inherit a FUBAR solution, I get ******* *******.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
January 21, 2016 at 6:40 am
Grant Fritchey (1/21/2016)
Hugo Kornelis (1/21/2016)
Though I am happy to hear that he feels that he has heard enough to be able to solve it, I am at the same time concerned. Based on his words, I do not really understand what he is going to do now. And based on his combined posts, I am concerned with what the end result will be...But perhaps I am just worrying too much?
Nah. I suspect the solution is likely to be non-standard. Ah well...
I suspect the 'solution' is going to be 'ask elsewhere until someone gives the answer that's wanted'
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
January 21, 2016 at 8:14 am
GilaMonster (1/21/2016)
Grant Fritchey (1/21/2016)
Hugo Kornelis (1/21/2016)
Though I am happy to hear that he feels that he has heard enough to be able to solve it, I am at the same time concerned. Based on his words, I do not really understand what he is going to do now. And based on his combined posts, I am concerned with what the end result will be...But perhaps I am just worrying too much?
Nah. I suspect the solution is likely to be non-standard. Ah well...
I suspect the 'solution' is going to be 'ask elsewhere until someone gives the answer that's wanted'
1 table, database per month, 10000 tables, aggregated reports, no indexes.
But I have 5 columns that define a unique record.
Seems like stepping back and possibly architecting a solution is totally off the table.
I just wonder if there is a relationship between the 5 columns and aggregation?
Can someone check the crystal ball?
It seems he has an elephant on the menu, and a 6 quart pot to cook it in.
But refuses to start carving up the elephant.
January 21, 2016 at 8:41 am
^ Nice analogy. We're gonna need a bigger boat... ummm, I mean a bigger knife.
January 21, 2016 at 9:59 am
Greg Edwards-268690 (1/21/2016)
It seems he has an elephant on the menu, and a 6 quart pot to cook it in.But refuses to start carving up the elephant.
dinner's gonna be late
January 21, 2016 at 10:11 am
Hugo Kornelis (1/21/2016)
Me, too
Well, if Hugo did his best, I won't even look. 😉
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
January 21, 2016 at 12:28 pm
Steve Jones - SSC Editor (1/21/2016)
Greg Edwards-268690 (1/21/2016)
It seems he has an elephant on the menu, and a 6 quart pot to cook it in.But refuses to start carving up the elephant.
dinner's gonna be late
An old company recipe book describes cooking for 5 weeks at 450 degrees after spending 2 months cutting the elephant into bite size pieces. And that it serves about 3000 people.
So have you done this before? 😛
January 21, 2016 at 2:35 pm
Phil Parkin (1/21/2016)
Brandie Tarvin (1/21/2016)
Two years from now he or his successor are going to be very irritated about their design.I love a good understatement.
I get very irritated when we run out of milk for my coffee. When I inherit a FUBAR solution, I get ******* *******.
For some "design" choices, the best advice to give to the person who implements it is to make sure that their successor never finds out where they live.
January 21, 2016 at 2:36 pm
Greg Edwards-268690 (1/21/2016)
Steve Jones - SSC Editor (1/21/2016)
Greg Edwards-268690 (1/21/2016)
It seems he has an elephant on the menu, and a 6 quart pot to cook it in.But refuses to start carving up the elephant.
dinner's gonna be late
An old company recipe book describes cooking for 5 weeks at 450 degrees after spending 2 months cutting the elephant into bite size pieces. And that it serves about 3000 people.
So have you done this before? 😛
Centigrade or Fahrenheit?
(always be specific!)
January 21, 2016 at 2:41 pm
Hugo Kornelis (1/21/2016)
Greg Edwards-268690 (1/21/2016)
Steve Jones - SSC Editor (1/21/2016)
Greg Edwards-268690 (1/21/2016)
It seems he has an elephant on the menu, and a 6 quart pot to cook it in.But refuses to start carving up the elephant.
dinner's gonna be late
An old company recipe book describes cooking for 5 weeks at 450 degrees after spending 2 months cutting the elephant into bite size pieces. And that it serves about 3000 people.
So have you done this before? 😛
Centigrade or Fahrenheit?
(always be specific!)
Kelvin of course. 😉
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
January 21, 2016 at 3:19 pm
Greg Edwards-268690 (1/21/2016)
Steve Jones - SSC Editor (1/21/2016)
Greg Edwards-268690 (1/21/2016)
It seems he has an elephant on the menu, and a 6 quart pot to cook it in.But refuses to start carving up the elephant.
dinner's gonna be late
An old company recipe book describes cooking for 5 weeks at 450 degrees after spending 2 months cutting the elephant into bite size pieces. And that it serves about 3000 people.
So have you done this before? 😛
😎
January 21, 2016 at 5:56 pm
Eirikur Eiriksson (1/21/2016)
Greg Edwards-268690 (1/21/2016)
Steve Jones - SSC Editor (1/21/2016)
Greg Edwards-268690 (1/21/2016)
It seems he has an elephant on the menu, and a 6 quart pot to cook it in.But refuses to start carving up the elephant.
dinner's gonna be late
An old company recipe book describes cooking for 5 weeks at 450 degrees after spending 2 months cutting the elephant into bite size pieces. And that it serves about 3000 people.
So have you done this before? 😛
😎
Mine must have been for a small elephant, as it was only 1 400 gallon kettle.
Viewing 15 posts - 52,321 through 52,335 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply