September 29, 2010 at 6:26 pm
Jeff Moden (9/29/2010)
Steve Jones - Editor (9/29/2010)
Speaking of stirring, new rice cooker coming today. Excited to be able to walk away and let it cook so I can only worry about stirring the pineapple curry my wife loves.Maybe I'm just lucky but I've never even thought of buying a rice cooker. I bring the properly measured water to a rolling boil and throw in a bit of salt to taste. As soon as the rolling boil returns (usually just a couple of seconds after that), I throw in the pre-measured rice, give it a quick stir, cover the pot, and let cook until it returns to a full rolling boil (usually just a minute or so). Then, I turn off the heat and go away for 30 minutes without moving the pan or uncovering it to even just look. When I come back 30-35 minutes later... perfect rice every time.
I tend to struggle a bit, especially as my wife and I like brown rice. Harder to get right, and each time I burn the bottom of the pan I'm annoyed. Probably I multi-task too much when cooking, but that's the nature of life on the ranch.
Had a Japanese girlfriend that had one and it was great. We could leave rice in there for a couple days, have rice anytime and enjoyed it. We had one last year, but my oldest took the pan somewhere and lost it. Plus it didn't do brown rice well. Got a nice Panasonic with fuzzy logic 🙂
September 29, 2010 at 6:48 pm
Brandie Tarvin (9/29/2010)
Now that's a little unfair, Tom. I happen to know some seriously good BAs and PMs at my current workplace who are all about the communication and trying to understand everyone's needs. In fact, several of them are very good at facilitating projects.
Yes, of course it's overstated and unfair, it's not true that everyone with that jobe is a disaster. But human nature ensures that almopst everyone in that jobs is the problem, not the solution: think of it: someone who is neither a developer nor a user is given this wonderful job of ensuring that the two grouops communicate; quite naturally this person decides that he has to control the communications between the two groups; next he realises that if the two groupe communicate independently of him, the are doing it outsuide his control; so he tries to prevent that happening, and when he fails he complains to upper management - and they, having not a clue what it's about but seeing the text of his job description, issue an edict that users and developers shall not communicate except using this guy as an intermediary. This soon develops into a rule that developers and users can't meet - each can meet with the business analyst, but ey can't meet with each other -m they can't even meet together with the business analyst present, because that might reduce his power and hence his status.
Despite that normal human reaction there are good business analysts who don't crate such a communication block but instead improved communication between developers and users. You are right, such people exist. I contend however that they are very rare.
Tom
September 29, 2010 at 7:03 pm
GilaMonster (9/29/2010)
Right now I'm feeling the pain of project managers rather than BAsGot a project manager that holds a weekly meeting in which does the following:
* Asks the developers what they are currently busy with
* Updates his % completed on project plan
* Raises concerns that we are behind schedule (we know, the deadline we were given is an impossible one)
* Reminds us that the deadline can't be moved.
Other than wasting an hour of my time each week, how is that helping the project?
Gail, you are extremely lucky that this nonsense only wastes an hour of your time each week! I've lost far more time than that to it (but I've never been sure whether my mission in life is to get sane development standards or to eliminat insane management standards - aswell as losing time to that sort of meeting I've lost time to explaining to developers that code that will only work some of the time and only that if they are lucky is not particularly useful).
Tom
September 29, 2010 at 7:16 pm
Jeff Moden (9/29/2010)
CirquedeSQLeil (9/29/2010)
So even though we can demonstrate to him that his approach is slower than another approach or takes more locks or whatever, he just dismisses it as "not invented in my brain."Sounds like mister self-appointed has a longer line of BS than the boss has for a spine. If you folks are constantly proving him wrong, get folks to start keeping a diary on it and then get mister spineless to fire the booger.
In almost nine years they've fired, to my knowledge, five people from IT. And I know that two of them were for stealing. The other three involved HR for... something... not sure what. They don't fire people where I work for something as silly as gross incompetence.
"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
September 29, 2010 at 7:28 pm
GilaMonster (9/29/2010)
Grant Fritchey (9/29/2010)
GilaMonster (9/29/2010)
Just found out that the PM promised the users that they can see the reports on monday (as in next week). Fat bloody chance in hell, I'm still revising the DB design.They'll probably just end up doing what we do around here. They'll release a piece of functionality or do a demo and declare the project "delivered on time." Then go back & finish it up.
The project isn't due until the end of next month. Why someone promised the user that he could see an end-to-end demo next week is absolutely beyond me. The database is still in flux, there's nothing more than test data in there, the data imports aren't finished and won't be for at least another week and we've just had to redesign a portion of database and front end.
When in doubt, ask yourself "What would Dilbert do?"[/url]
Also, with respect to the whole man/woman/male/female thing.....
I'm a man.
__________________________________________________
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 29, 2010 at 7:35 pm
The Dixie Flatline (9/29/2010)
GilaMonster (9/29/2010)
Grant Fritchey (9/29/2010)
GilaMonster (9/29/2010)
Just found out that the PM promised the users that they can see the reports on monday (as in next week). Fat bloody chance in hell, I'm still revising the DB design.They'll probably just end up doing what we do around here. They'll release a piece of functionality or do a demo and declare the project "delivered on time." Then go back & finish it up.
The project isn't due until the end of next month. Why someone promised the user that he could see an end-to-end demo next week is absolutely beyond me. The database is still in flux, there's nothing more than test data in there, the data imports aren't finished and won't be for at least another week and we've just had to redesign a portion of database and front end.
When in doubt, ask yourself "What would Dilbert do?"[/url]
Also, with respect to the whole man/woman/male/female thing.....
I'm a man.
And you can prove that on Kilt Wednesday at the Summit.
"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
September 29, 2010 at 8:40 pm
Jeff Moden (9/29/2010)
Grant Fritchey (9/29/2010)
So even though we can demonstrate to him that his approach is slower than another approach or takes more locks or whatever, he just dismisses it as "not invented in my brain."Sounds like mister self-appointed has a longer line of BS than the boss has for a spine. If you folks are constantly proving him wrong, get folks to start keeping a diary on it and then get mister spineless to fire the booger.
Just fixing the quote and crediting Grant with his quote 😉
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 29, 2010 at 8:43 pm
Steve Jones - Editor (9/29/2010)
Jeff Moden (9/29/2010)
Steve Jones - Editor (9/29/2010)
Speaking of stirring, new rice cooker coming today. Excited to be able to walk away and let it cook so I can only worry about stirring the pineapple curry my wife loves.Maybe I'm just lucky but I've never even thought of buying a rice cooker. I bring the properly measured water to a rolling boil and throw in a bit of salt to taste. As soon as the rolling boil returns (usually just a couple of seconds after that), I throw in the pre-measured rice, give it a quick stir, cover the pot, and let cook until it returns to a full rolling boil (usually just a minute or so). Then, I turn off the heat and go away for 30 minutes without moving the pan or uncovering it to even just look. When I come back 30-35 minutes later... perfect rice every time.
I tend to struggle a bit, especially as my wife and I like brown rice. Harder to get right, and each time I burn the bottom of the pan I'm annoyed. Probably I multi-task too much when cooking, but that's the nature of life on the ranch.
Had a Japanese girlfriend that had one and it was great. We could leave rice in there for a couple days, have rice anytime and enjoyed it. We had one last year, but my oldest took the pan somewhere and lost it. Plus it didn't do brown rice well. Got a nice Panasonic with fuzzy logic 🙂
Fuzzy logic is easy
just leave the rice in the pan for 3 weeks - it'll become fuzzy
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 29, 2010 at 8:45 pm
Grant Fritchey (9/29/2010)
The Dixie Flatline (9/29/2010)
GilaMonster (9/29/2010)
Grant Fritchey (9/29/2010)
GilaMonster (9/29/2010)
Just found out that the PM promised the users that they can see the reports on monday (as in next week). Fat bloody chance in hell, I'm still revising the DB design.They'll probably just end up doing what we do around here. They'll release a piece of functionality or do a demo and declare the project "delivered on time." Then go back & finish it up.
The project isn't due until the end of next month. Why someone promised the user that he could see an end-to-end demo next week is absolutely beyond me. The database is still in flux, there's nothing more than test data in there, the data imports aren't finished and won't be for at least another week and we've just had to redesign a portion of database and front end.
When in doubt, ask yourself "What would Dilbert do?"[/url]
Also, with respect to the whole man/woman/male/female thing.....
I'm a man.
And you can prove that on Kilt Wednesday at the Summit.
If Buck Woody can pull it off, well anybody can.
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 30, 2010 at 2:48 am
Totally different topic: how big was the biggest SQL statement you had to deal with?
This is a statement generated by our BI front-end.
Surprisingly enough, after 4 minutes of parsing, it executes in 10 seconds.
Stats:
17.020 lines
1.314.344 bytes
:exclamation:!!!WARNING!!!:exclamation:
The link takes you to a 7 MB html formatted query. Don't click if your pc can't handle it.
-- Gianluca Sartori
September 30, 2010 at 3:51 am
Gianluca Sartori (9/30/2010)
Totally different topic: how big was the biggest SQL statement you had to deal with?This is a statement generated by our BI front-end.
Surprisingly enough, after 4 minutes of parsing, it executes in 10 seconds.
Stats:
17.020 lines
1.314.344 bytes
You must be kidding. I've seen some really bad stuff in my life, but this trumps it all.
September 30, 2010 at 3:55 am
Gianluca Sartori (9/30/2010)
Totally different topic: how big was the biggest SQL statement you had to deal with?This is a statement generated by our BI front-end.
Surprisingly enough, after 4 minutes of parsing, it executes in 10 seconds.
Stats:
17.020 lines
1.314.344 bytes
Hope you have forced parameterization on for plan re-use 😀
September 30, 2010 at 4:01 am
Dave Ballantyne (9/30/2010)
Gianluca Sartori (9/30/2010)
Totally different topic: how big was the biggest SQL statement you had to deal with?This is a statement generated by our BI front-end.
Surprisingly enough, after 4 minutes of parsing, it executes in 10 seconds.
Stats:
17.020 lines
1.314.344 bytes
Hope you have forced parameterization on for plan re-use 😀
(Un?)fortunately, this monster runs in Oracle.
This happens when the user tries to generate a new report filtering the results with a previously generated report. As you can see, the BI engine inserts the whole original report in the query as IN list.
I'm still surprised that the optimizer doesn't give up.
-- Gianluca Sartori
September 30, 2010 at 6:11 am
Grant Fritchey (9/29/2010)
Jeff Moden (9/29/2010)
CirquedeSQLeil (9/29/2010)
So even though we can demonstrate to him that his approach is slower than another approach or takes more locks or whatever, he just dismisses it as "not invented in my brain."Sounds like mister self-appointed has a longer line of BS than the boss has for a spine. If you folks are constantly proving him wrong, get folks to start keeping a diary on it and then get mister spineless to fire the booger.
In almost nine years they've fired, to my knowledge, five people from IT. And I know that two of them were for stealing. The other three involved HR for... something... not sure what. They don't fire people where I work for something as silly as gross incompetence.
I'm still struggling to understand what people *don't* get fired for. Yes, there's a personal story, way worse than stealing, no, not sharing.
---------------------------------------------------------
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."
September 30, 2010 at 6:59 am
Jeff Moden (9/29/2010)
Heh... nah... there are other places other than Alaska where such a thing occurs. 😉
East side of Michigan - anywhere between Detroit and Port Huron? That's the only one my recollection of time-wasting trivia quizzes 45 years ago calls up, except that the west side of Point Roberts WA fits the bill too, but if that had been it you would surely have mentioned Canada as next country to the West as well as North, South and East.
Tom
Viewing 15 posts - 19,501 through 19,515 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply