March 11, 2014 at 7:30 pm
Jeff Moden (3/11/2014)
Greg Edwards-268690 (3/10/2014)
Luis Cazares (3/10/2014)
Lynn Pettis (3/10/2014)
If any one has some free time this person could use some help. I don't have the free time at the moment.http://www.sqlservercentral.com/Forums/Topic1549023-391-1.aspx
I've wasted a lot of time with that person, but he seems to haven't learn a thing. Maybe someone else.
They know Jeff is one of the best, so they have learned something.
Coming from a data warehouse, running SSAS, it made me cringe a bit.
Maybe more than a bit. :w00t:
Thank you for the kind words. He's been PMing me and I've been telling him I'm not his private consultant. The first PM was to "Geff"... he couldn't even get my 4 letter name right and I let him know about it.
He is good with the compliments but I've not had the time to even run his triple nested, horribly formatted code through a reformatter just to try to figure out what he was doing. I'm tickled that someone like Dwain (or any of the heavy hitters) jumped in on that one. Thanks for the leg up.
Jeff - I think you can be thankful you bugged out of this one. If you look at the final solution I posted (which he marked as "met his requirements") it produces some really weird output. Not to mention the 2 PMs he sent me asking me to look again.
Are the posted questions lately dripping with entitlement?
Oops, sorry! :hehe: Didn't mean to actually try and get The Thread back on track. 😛
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
March 11, 2014 at 8:19 pm
dwain.c (3/11/2014)
Jeff Moden (3/11/2014)
Greg Edwards-268690 (3/10/2014)
Luis Cazares (3/10/2014)
Lynn Pettis (3/10/2014)
If any one has some free time this person could use some help. I don't have the free time at the moment.http://www.sqlservercentral.com/Forums/Topic1549023-391-1.aspx
I've wasted a lot of time with that person, but he seems to haven't learn a thing. Maybe someone else.
They know Jeff is one of the best, so they have learned something.
Coming from a data warehouse, running SSAS, it made me cringe a bit.
Maybe more than a bit. :w00t:
Thank you for the kind words. He's been PMing me and I've been telling him I'm not his private consultant. The first PM was to "Geff"... he couldn't even get my 4 letter name right and I let him know about it.
He is good with the compliments but I've not had the time to even run his triple nested, horribly formatted code through a reformatter just to try to figure out what he was doing. I'm tickled that someone like Dwain (or any of the heavy hitters) jumped in on that one. Thanks for the leg up.
Jeff - I think you can be thankful you bugged out of this one. If you look at the final solution I posted (which he marked as "met his requirements") it produces some really weird output. Not to mention the 2 PMs he sent me asking me to look again.
Are the posted questions lately dripping with entitlement?
Oops, sorry! :hehe: Didn't mean to actually try and get The Thread back on track. 😛
And 5 or 6 lines of MDX likely solves the whole thing if you build a cube.
Or use PowerPivot in Excel to let the user play with the data.
March 11, 2014 at 10:09 pm
Greg Edwards-268690 (3/11/2014)
And 5 or 6 lines of MDX likely solves the whole thing if you build a cube.Or use PowerPivot in Excel to let the user play with the data.
What fun would that be if I started to use such things? People wouldn't be able to accuse me of being a Luddite if I did. 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
March 12, 2014 at 6:04 am
Jeff Moden (3/11/2014)
Greg Edwards-268690 (3/11/2014)
And 5 or 6 lines of MDX likely solves the whole thing if you build a cube.Or use PowerPivot in Excel to let the user play with the data.
What fun would that be if I started to use such things? People wouldn't be able to accuse me of being a Luddite if I did. 😛
More time with the Potato Cannon and Pork Chop Launcher. 😀
I do like seeing the code and that it can be done.
Just seems there are some easier ways to quickly get the user to the same results.
March 12, 2014 at 6:32 am
Am I slow today, or was this a little tricky to figure out? http://www.sqlservercentral.com/Forums/Topic1550137-1292-1.aspx
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
March 12, 2014 at 6:40 am
GilaMonster (3/12/2014)
Am I slow today, or was this a little tricky to figure out? http://www.sqlservercentral.com/Forums/Topic1550137-1292-1.aspx
No, that one was weird.
"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
March 12, 2014 at 7:02 am
dwain.c (3/11/2014)
Are the posted questions lately dripping with entitlement?
Yes, they seem to have that attitude. Provide no DDL, no data, scant specs and sometimes don't even ask a question. Well, where's the response? It should have been posted already, so let's state the same thing a couple more times and post the same question in another thread.
March 12, 2014 at 7:43 am
Ed Wagner (3/12/2014)
dwain.c (3/11/2014)
Are the posted questions lately dripping with entitlement?Yes, they seem to have that attitude. Provide no DDL, no data, scant specs and sometimes don't even ask a question. Well, where's the response? It should have been posted already, so let's state the same thing a couple more times and post the same question in another thread.
Or like this
I don't feel they understood AVG as they claimed.
And then we bring it upon ourselves supplying a CTE.
I like that they supplied some data and ddl, but then supply an example in Excel using another set of data.
Maybe I'm wrong, but I still think the user would have been better off with the basics.
A good handle on them takes you pretty far.
March 12, 2014 at 4:13 pm
I have a database. It doesn't work. Please advise.
Thanks in advance.
P.S. Please don't ask for DDL and sample data as I've already said that it doesn't work.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 12, 2014 at 4:15 pm
The Dixie Flatline (3/12/2014)
I have a database. It doesn't work. Please advise.Thanks in advance.
P.S. Please don't ask for DDL and sample data as I've already said that it doesn't work.
Dear expert, you should drop your database.
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
March 12, 2014 at 4:18 pm
The Dixie Flatline (3/12/2014)
I have a database. It doesn't work. Please advise.Thanks in advance.
P.S. Please don't ask for DDL and sample data as I've already said that it doesn't work.
I'm sure we can help. Here's a possible solution for you:
March 12, 2014 at 4:46 pm
SQLRNNR (3/12/2014)
The Dixie Flatline (3/12/2014)
I have a database. It doesn't work. Please advise.Thanks in advance.
P.S. Please don't ask for DDL and sample data as I've already said that it doesn't work.
Dear expert, you should drop your database.
Okay, I dropped the database but it still doesn't work. Someone on another website says I should do a backup, but wouldn't tell me how. Would you agree that this is a good idea? If so, could you give me instructions? If you don't agree, could you talk to him about this for me?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 12, 2014 at 4:53 pm
The Dixie Flatline (3/12/2014)
SQLRNNR (3/12/2014)
The Dixie Flatline (3/12/2014)
I have a database. It doesn't work. Please advise.Thanks in advance.
P.S. Please don't ask for DDL and sample data as I've already said that it doesn't work.
Dear expert, you should drop your database.
Okay, I dropped the database but it still doesn't work. Someone on another website says I should do a backup, but wouldn't tell me how. Would you agree that this is a good idea? If so, could you give me instructions? If you don't agree, could you talk to him about this for me?
hmmm, maybe try formatting the Z drive where your data files are.
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
March 12, 2014 at 6:08 pm
Luis Cazares (3/12/2014)
The Dixie Flatline (3/12/2014)
I have a database. It doesn't work. Please advise.Thanks in advance.
P.S. Please don't ask for DDL and sample data as I've already said that it doesn't work.
I'm sure we can help. Here's a possible solution for you:
BWAHAHAHAHAHAA!
Nice one Luis!
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
March 12, 2014 at 6:30 pm
dwain.c (3/12/2014)
Luis Cazares (3/12/2014)
The Dixie Flatline (3/12/2014)
I have a database. It doesn't work. Please advise.Thanks in advance.
P.S. Please don't ask for DDL and sample data as I've already said that it doesn't work.
I'm sure we can help. Here's a possible solution for you:
BWAHAHAHAHAHAA!
Nice one Luis!
I've been tempted to do something like this several times (I might have done it).
In another order of ideas, today I had a good experience to prove your quote about indexing and cat food. A process with an insert and update to the same table was taking almost 2 hours to finish and the update used 90 minutes. After trying to create an index that would work for this query, I proposed to remove the update and include the value in the insert. The insert didn't take longer and we could deliver the information one and a half hour faster each day. 😀
Viewing 15 posts - 43,276 through 43,290 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply