Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««4,3644,3654,3664,3674,368»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Friday, April 4, 2014 6:15 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Today @ 2:10 PM
Points: 680, Visits: 6,854
Revenant (4/3/2014)
TomThomson (4/3/2014)
Lynn Pettis (4/3/2014)
TomThomson (4/3/2014)
You can have it fast, cheap, or right - pick only one of the three.

I thought that was 2 of 3? When did this change? I don't remember seeing the memo?

Well, there is an interesting paradox: if you pick "right" as the one of the three you insist on, you stand a chance of getting it fast and cheap, so you can sometimes get all three. But if you start from cheap it will go wrong, and take a long time to fix, which may ead to budget overruns so aiming for cheap won't deliver fast or right and is rather unlikely to deliver cheap, and if you start from "fast" and want 2 man years work done in 2 days and put hundreds of people on it with no time to plan the work or coordinate the many teams you are pretty well guaranteed an expensive and buggy result that isn't available until long after you wanted it. So the only one of the three you should pick is "right" and then you may get the other two as well, whereas if you pick either of the others you will probably get none of the three.

However, non-technical managers (and most technical managers too, in fact) don't understand this, so they have to be offered the choice - and allowing them to pick two of the three guarantees failure, so they should only be allowed to choose one so that there's at least some chance of success. I've even known an accountant pick "get it right" as his preferred option, so there's always some chance if you restrict them to one of the three.

I am printing this in size 36p font and putting it on the wall of my office.


If it needs to be Right in the end, choosing Right many times lead to the proper planning to get to this point in the Fastest, most cost effective manner. Rework and broken processes can be very costly.

Many times in the data world, those who are in the spotlight the least are doing their jobs very well.
If the Rock Star developed the code, then is praised for the many fixes, are they better than the one in the background whose code always goes into production seamlessly?
I know which one I would want on my team.....
Post #1558461
Posted Friday, April 4, 2014 7:10 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:05 PM
Points: 13,327, Visits: 12,820
dwain.c (4/3/2014)
Sean Lange (4/3/2014)
Greg Edwards-268690 (4/3/2014)
it was clear they had no idea what they wanted or needed.
But finish it by Friday.


This is an everyday occurrence at my job.


If it happens every day and each needs to be completed by Friday, doesn't that mean your backlog builds geometrically?


So you see my paradox then?


_______________________________________________________________

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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1558487
Posted Friday, April 4, 2014 7:11 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:05 PM
Points: 13,327, Visits: 12,820
TomThomson (4/3/2014)
Steve Jones - SSC Editor (4/3/2014)
Revenant (4/3/2014)
Sean Lange (4/3/2014)
Greg Edwards-268690 (4/3/2014)
it was clear they had no idea what they wanted or needed.
But finish it by Friday.


This is an everyday occurrence at my job.

That's OK as long as there is sufficient padding in the budget.


You can have it fast or cheap...

Not if you want it right.

You can have it fast, cheap, or right - pick only one of the three.

EDIT: fix quotes - I hate this site's "I'll quote the wrong message feature but not tell you" feature about as much as I hate the "you've expired so we've thrown your typing away" feature.


I usually limit the list to two choices: "right" or "right now".


_______________________________________________________________

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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1558488
Posted Friday, April 4, 2014 7:26 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 3:20 PM
Points: 18,064, Visits: 16,099
dwain.c (4/3/2014)
Many thanks to Steve for syndicating my blogs on SSC:

DwainCSQL

And my apologies for making you work so hard at it.


Well well well, another blog to read. I don't know how I missed it. Looks like you have plenty of articles up there in a short time.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1558494
Posted Friday, April 4, 2014 7:29 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 3:20 PM
Points: 18,064, Visits: 16,099
Sean Lange (4/4/2014)
TomThomson (4/3/2014)
Steve Jones - SSC Editor (4/3/2014)
Revenant (4/3/2014)
Sean Lange (4/3/2014)
Greg Edwards-268690 (4/3/2014)
it was clear they had no idea what they wanted or needed.
But finish it by Friday.


This is an everyday occurrence at my job.

That's OK as long as there is sufficient padding in the budget.


You can have it fast or cheap...

Not if you want it right.

You can have it fast, cheap, or right - pick only one of the three.

EDIT: fix quotes - I hate this site's "I'll quote the wrong message feature but not tell you" feature about as much as I hate the "you've expired so we've thrown your typing away" feature.


I usually limit the list to two choices: "right" or "right now".


Good solid choices. Tough call. Eeny meeny miney mo!




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1558495
Posted Friday, April 4, 2014 7:41 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Today @ 2:10 PM
Points: 680, Visits: 6,854
SQLRNNR (4/4/2014)
Sean Lange (4/4/2014)
TomThomson (4/3/2014)
Steve Jones - SSC Editor (4/3/2014)
Revenant (4/3/2014)
Sean Lange (4/3/2014)
Greg Edwards-268690 (4/3/2014)
it was clear they had no idea what they wanted or needed.
But finish it by Friday.


This is an everyday occurrence at my job.

That's OK as long as there is sufficient padding in the budget.


You can have it fast or cheap...

Not if you want it right.

You can have it fast, cheap, or right - pick only one of the three.

EDIT: fix quotes - I hate this site's "I'll quote the wrong message feature but not tell you" feature about as much as I hate the "you've expired so we've thrown your typing away" feature.


I usually limit the list to two choices: "right" or "right now".


Good solid choices. Tough call. Eeny meeny miney mo!


Right Now implies you drop everything to do my special project.
Right Now by its very nature implies Fast.
Time is Money.
It seems the list is limited to one choice.
I can see at some point in the near future, you being tarred an feathered for slowing the process by offering such a ridiculous option as "Right".
Post #1558502
Posted Friday, April 4, 2014 7:51 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 1:43 AM
Points: 6,890, Visits: 14,254
SQLRNNR (4/4/2014)
Sean Lange (4/4/2014)
TomThomson (4/3/2014)
Steve Jones - SSC Editor (4/3/2014)
Revenant (4/3/2014)
Sean Lange (4/3/2014)
Greg Edwards-268690 (4/3/2014)
it was clear they had no idea what they wanted or needed.
But finish it by Friday.


This is an everyday occurrence at my job.

That's OK as long as there is sufficient padding in the budget.


You can have it fast or cheap...

Not if you want it right.

You can have it fast, cheap, or right - pick only one of the three.

EDIT: fix quotes - I hate this site's "I'll quote the wrong message feature but not tell you" feature about as much as I hate the "you've expired so we've thrown your typing away" feature.


I usually limit the list to two choices: "right" or "right now".


Good solid choices. Tough call. Eeny meeny miney mo!


"We've aligned our IT strategy with the CEO's dating strategy"


“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

For 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
Exploring Recursive CTEs by Example Dwain Camps
Post #1558514
Posted Friday, April 4, 2014 7:53 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:05 PM
Points: 13,327, Visits: 12,820
Greg Edwards-268690 (4/4/2014)
SQLRNNR (4/4/2014)
Sean Lange (4/4/2014)
TomThomson (4/3/2014)
Steve Jones - SSC Editor (4/3/2014)
Revenant (4/3/2014)
Sean Lange (4/3/2014)
Greg Edwards-268690 (4/3/2014)
it was clear they had no idea what they wanted or needed.
But finish it by Friday.


This is an everyday occurrence at my job.

That's OK as long as there is sufficient padding in the budget.


You can have it fast or cheap...

Not if you want it right.

You can have it fast, cheap, or right - pick only one of the three.

EDIT: fix quotes - I hate this site's "I'll quote the wrong message feature but not tell you" feature about as much as I hate the "you've expired so we've thrown your typing away" feature.


I usually limit the list to two choices: "right" or "right now".


Good solid choices. Tough call. Eeny meeny miney mo!


Right Now implies you drop everything to do my special project.
Right Now by its very nature implies Fast.
Time is Money.
It seems the list is limited to one choice.
I can see at some point in the near future, you being tarred an feathered for slowing the process by offering such a ridiculous option as "Right".


LOL Greg. I do sometimes get seen as the obstinate one who doesn't want to play by the same rules as everyone else. I am the guy who always asks the hard questions which sometimes makes me seem the pessimist. My canned response to being told I am the pessimistic one? "What is the difference between an optimist and pessimist?" Experience.


_______________________________________________________________

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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1558517
Posted Friday, April 4, 2014 7:55 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:05 PM
Points: 13,327, Visits: 12,820
ChrisM@Work (4/4/2014)
SQLRNNR (4/4/2014)
Sean Lange (4/4/2014)
TomThomson (4/3/2014)
Steve Jones - SSC Editor (4/3/2014)
Revenant (4/3/2014)
Sean Lange (4/3/2014)
Greg Edwards-268690 (4/3/2014)
it was clear they had no idea what they wanted or needed.
But finish it by Friday.


This is an everyday occurrence at my job.

That's OK as long as there is sufficient padding in the budget.


You can have it fast or cheap...

Not if you want it right.

You can have it fast, cheap, or right - pick only one of the three.

EDIT: fix quotes - I hate this site's "I'll quote the wrong message feature but not tell you" feature about as much as I hate the "you've expired so we've thrown your typing away" feature.


I usually limit the list to two choices: "right" or "right now".


Good solid choices. Tough call. Eeny meeny miney mo!


"We've aligned our IT strategy with the CEO's dating strategy"


Quantity over Quality I guess.


_______________________________________________________________

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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1558519
Posted Friday, April 4, 2014 8:28 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:23 PM
Points: 20,860, Visits: 32,883
Sean Lange (4/4/2014)
Greg Edwards-268690 (4/4/2014)
SQLRNNR (4/4/2014)
Sean Lange (4/4/2014)
TomThomson (4/3/2014)
Steve Jones - SSC Editor (4/3/2014)
Revenant (4/3/2014)
Sean Lange (4/3/2014)
Greg Edwards-268690 (4/3/2014)
it was clear they had no idea what they wanted or needed.
But finish it by Friday.


This is an everyday occurrence at my job.

That's OK as long as there is sufficient padding in the budget.


You can have it fast or cheap...

Not if you want it right.

You can have it fast, cheap, or right - pick only one of the three.

EDIT: fix quotes - I hate this site's "I'll quote the wrong message feature but not tell you" feature about as much as I hate the "you've expired so we've thrown your typing away" feature.


I usually limit the list to two choices: "right" or "right now".


Good solid choices. Tough call. Eeny meeny miney mo!


Right Now implies you drop everything to do my special project.
Right Now by its very nature implies Fast.
Time is Money.
It seems the list is limited to one choice.
I can see at some point in the near future, you being tarred an feathered for slowing the process by offering such a ridiculous option as "Right".


LOL Greg. I do sometimes get seen as the obstinate one who doesn't want to play by the same rules as everyone else. I am the guy who always asks the hard questions which sometimes makes me seem the pessimist. My canned response to being told I am the pessimistic one? "What is the difference between an optimist and pessimist?" Experience.


I call an experienced optimist a pragmatist.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1558531
« Prev Topic | Next Topic »

Add to briefcase «««4,3644,3654,3664,3674,368»»»

Permissions Expand / Collapse