Are the posted questions getting worse?
-
GilaMonster (7/24/2015)
rodjkidd (7/23/2015)
Gail, well done. Seriously impressive.I hope you are celebrating this weekend?
Taking myself and a good book to an expensive Chinese restaurant tonight. Yes, that's a celebration.
Well it sounds like one to me, enjoy.
Apparently it's Chinese tonight for the Friday night meet the speakers dinner!
Rodders...
-
GilaMonster (7/23/2015)
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Massive well done - but how on Earth do you top that? If you choose to do a PhD, you won't have time for us... :crying:
“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 -
rodjkidd (7/24/2015)
GilaMonster (7/24/2015)
rodjkidd (7/23/2015)
Gail, well done. Seriously impressive.I hope you are celebrating this weekend?
Taking myself and a good book to an expensive Chinese restaurant tonight. Yes, that's a celebration.
Well it sounds like one to me, enjoy.
Apparently it's Chinese tonight for the Friday night meet the speakers dinner!
Rodders...
Why don't we all agree to do Chinese tonight? 🙂
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]
-
So everyone at work is thrilled with me right now for solving a slow-running report issue when I discovered 4 table scans (of the same table) in a proc and two indexes in Dev that hadn't gotten promoted to the other environments. I don't mind the praise, but the problem is two other people did index rebuilds, statistics updates, created / fixed another handful of indexes in the days before me. Which means that my discovery is probably just the last piece of the puzzle rather than being the "real" fix.
Only a handful of people (including my boss) understand this was a team effort. Everyone else is patting me on the back, including one of the developers who was one of those team-effort people. It's making me feel a bit odd about the whole thing, since my effort was maybe 30 minutes worth of work compared to several days that everyone else was putting in.
Has this ever happened to anyone else?
-
Today is National Tequila Day in the US, so all speaker dinners should include that, perhaps with some Latin flavored food.
My kids have declined margaritas, but they have requested enchiladas.
-
It's home made quesadillas here. There may well be room for tequila 🙂
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a PhilosopherHow to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
-
Steve Jones - SSC Editor (7/24/2015)
Today is National Tequila Day in the US, so all speaker dinners should include that, perhaps with some Latin flavored food.My kids have declined margaritas, but they have requested enchiladas.
Not sure how I managed to miss but the half bottle of tequila in the cabinet may need to be visited this evening. 😛
_______________________________________________________________
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/ -
Brandie Tarvin (7/24/2015)
So everyone at work is thrilled with me right now for solving a slow-running report issue when I discovered 4 table scans (of the same table) in a proc and two indexes in Dev that hadn't gotten promoted to the other environments. I don't mind the praise, but the problem is two other people did index rebuilds, statistics updates, created / fixed another handful of indexes in the days before me. Which means that my discovery is probably just the last piece of the puzzle rather than being the "real" fix.Only a handful of people (including my boss) understand this was a team effort. Everyone else is patting me on the back, including one of the developers who was one of those team-effort people. It's making me feel a bit odd about the whole thing, since my effort was maybe 30 minutes worth of work compared to several days that everyone else was putting in.
Has this ever happened to anyone else?
This kind of thing happens all the time. Multiple people spend time on a problem and find a part of the problem, and the one who find that last piece is usually the one that gets the credit. In my opinion, it is only an issue when the person getting the credit just basks in the glory and doesn't deflect it to the rest of the team.
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 -
Brandie Tarvin (7/24/2015)
So everyone at work is thrilled with me right now for solving a slow-running report issue when I discovered 4 table scans (of the same table) in a proc and two indexes in Dev that hadn't gotten promoted to the other environments. I don't mind the praise, but the problem is two other people did index rebuilds, statistics updates, created / fixed another handful of indexes in the days before me. Which means that my discovery is probably just the last piece of the puzzle rather than being the "real" fix.Only a handful of people (including my boss) understand this was a team effort. Everyone else is patting me on the back, including one of the developers who was one of those team-effort people. It's making me feel a bit odd about the whole thing, since my effort was maybe 30 minutes worth of work compared to several days that everyone else was putting in.
Has this ever happened to anyone else?
Yes and I do go out of my way to remind/inform people that didn't participate that it was actually a team effort and to make sure that the people that know (by name) that there were several individual contributors to the success in overcoming the problem. I neither play down nor play up what I did but I do stress the notion of "Team" when a team was a good part of what made it all possible.
--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) -
Brandie Tarvin (7/24/2015)
So everyone at work is thrilled with me right now for solving a slow-running report issue when I discovered 4 table scans (of the same table) in a proc and two indexes in Dev that hadn't gotten promoted to the other environments. I don't mind the praise, but the problem is two other people did index rebuilds, statistics updates, created / fixed another handful of indexes in the days before me. Which means that my discovery is probably just the last piece of the puzzle rather than being the "real" fix.Only a handful of people (including my boss) understand this was a team effort. Everyone else is patting me on the back, including one of the developers who was one of those team-effort people. It's making me feel a bit odd about the whole thing, since my effort was maybe 30 minutes worth of work compared to several days that everyone else was putting in.
Has this ever happened to anyone else?
Yes. It can be pretty hard to correct. You're lucky your boss is one of the handful - that doesn't always happen. It's extremely imortant (as Jeff said) to try, when you are wrongly credited, to correct it.
I found that these things happen both ways over time, sometimes you get more credit than you deserve, sometimes you get less; maybe it balances out in the end. It can happen with blame as well as with credit, too.
Tom
-
rodjkidd (7/24/2015)
Morning all,Now about to leave to catch the train to Manchester. I hope to a few of you there.
Tom don't forget to say hi!
Cheers,
Rodders...
I'm aiming to get there for opening time (08:00). Will be watching out for you - I think your avatar is a real picture with you (and Steve) in it, so I have some idea what you look like.
Tom
-
GilaMonster (7/23/2015)
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Superfluous additional exclamatory congratulations, Gail!
But for some strange reason this is unsurprising.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
TomThomson (7/24/2015)
rodjkidd (7/24/2015)
Morning all,Now about to leave to catch the train to Manchester. I hope to a few of you there.
Tom don't forget to say hi!
Cheers,
Rodders...
I'm aiming to get there for opening time (08:00). Will be watching out for you - I think your avatar is a real picture with you (and Steve) in it, so I have some idea what you look like.
Excellent. I should be there at 7 30 to help out etc. yep that's me next to Steve!
Steve - Neil Hambley is here and so therefore so is Tequila!
Alvin - sounds like a plan, Chinese Is it then 😉
Good first night. The quiz was all Manchester themed. Tough for those of us not from up North. 🙂
Rodders...
-
Hey guys!
What'd I miss? I've been busy.
Achievements Unlocked:
Charlemagne's bones (they wouldn't let me sit in the throne)
Flanders Fields (way too many little white crosses)
Ypres (inside a WWI dugout)
Somme (idiot boy-child picked up a 100 year old, unexploded, Stokes mortar shell on the battlefield)
Bastogne (stood in a fox hole in the woods above Foy)
Waterloo (love the Lion Mound from on top, hate it from on the field, Hougoumont!!!!)
Managed to get a fully-loaded station wagon (four people plus bags) all the way up to 120MPH (195KPH) on the Autobahn.
"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 (7/26/2015)
Managed to get a fully-loaded station wagon (four people plus bags) all the way up to 120MPH (195KPH) on the Autobahn.Don't get caught at that one in France unless (a) one of the other people in the car can drive and (b) you've got enough cash to pay the fine. The French don't have unlimited speed roads, and 195 kph is in the range where the traffic cop will call your licence details are car plates in to HQ and the licence details will be recorded on their police national database as temporarily (not sure how long at 195 - either 1 month or 3 months) not valid in France - and the cop will not allow you to drive away if you don't have someone else to do it.
edit: I must get around to Charlemagne's bones some day.
Tom
Viewing 15 posts - 49,651 through 49,665 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply