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 12345»»»

Free Advice or Free Consulting Expand / Collapse
Author
Message
Posted Wednesday, May 12, 2010 8:40 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:48 AM
Points: 14,802, Visits: 27,278
Comments posted to this topic are about the item Free Advice or Free Consulting

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #920945
Posted Wednesday, May 12, 2010 10:52 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 4:00 PM
Points: 35,967, Visits: 30,258
Heh... Crap! This forum wouldn't let me give this article any more than 5 stars and it wouldn't let me vote more than once.

On all fronts, well said, Grant.


--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." -- 04 August 2013
(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #920989
Posted Thursday, May 13, 2010 12:56 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 2:13 AM
Points: 1,865, Visits: 368
very well said... absolutely correct...
Post #921025
Posted Thursday, May 13, 2010 2:11 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, March 17, 2014 6:21 AM
Points: 1,073, Visits: 6,477
Steve should ban those words (URGENT or IMMEDIATE HELP or NOW) to appear in the title.

-------------------------------------------------------------
"It takes 15 minutes to learn the game and a lifetime to master"
"Share your knowledge. It's a way to achieve immortality."


Post #921060
Posted Thursday, May 13, 2010 2:47 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 7:47 AM
Points: 1,174, Visits: 2,635
D.Oc (5/13/2010)
Steve should ban those words (URGENT or IMMEDIATE HELP or NOW) to appear in the title.


Particularly when they are in upper case.


Nice editorial Grant, a polite rant if ever I saw one

Now, if only the appropriate people would read it. Along with the one that says, " ... to help us help you please provide DDL, example data, results ..."


--
Nigel
Useful Links:
How to post data/code on a forum to get the best help
The "Numbers" or "Tally" Table - Jeff Moden

Post #921077
Posted Thursday, May 13, 2010 2:48 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:59 AM
Points: 41,530, Visits: 34,447
Consultants don't want to work for free? How unfair of them. They should remember there are people stuck in jobs they can't do, and drop everything to give these people everything. Jobs may be at stake! </sarcasm>


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #921078
Posted Thursday, May 13, 2010 3:22 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, May 31, 2013 4:37 PM
Points: 66, Visits: 73
Olá,
não me parece que seja tão drástico colocar "Urgent" nos pedidos; aliás, desta forma, pode-se sempre tentar ajudar as pessoas com alguma ordem de prioridade.
No entanto, acho que muitas vezes as pessoas abusam da ajuda, pensam que os outros são criados deles e querem a toda a força que lhes façam o trabalho.
Assim não dá! Para isso que paguem a uma empresa.

In other words, if people wants the job done totaly and imediatly they must pay. nobody is slave!
Post #921101
Posted Thursday, May 13, 2010 4:42 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:12 AM
Points: 6,545, Visits: 8,762
Very well done Grant! There was a lot of "yeah!" moments in there.

Thanks!


Wayne
Microsoft Certified Master: SQL Server 2008
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #921131
Posted Thursday, May 13, 2010 6:00 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 9:51 AM
Points: 230, Visits: 692
As long as you "send ... some coffee and a tasty snack " I would be happy to negoiate a price!! Truthfully being one of those dreaded <sarcasm> consultants who want to get paid I would happily negoiate a price for someone else to pay!

About FTEs and consultants who "want to get paid"? FTEs are getting paid for their advice also, they are just not being paid by the person who benefits. Either way, the asker should understand the reality of the situation.

Great article Grant.


<><
Livin' down on the cube farm. Left, left, then a right.
Post #921164
Posted Thursday, May 13, 2010 6:04 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:52 AM
Points: 6,932, Visits: 12,663
Excellent job, Grant!
The only question that remains open is: Where to draw the line?
But I guess it's almost impossible to answer...
Interview questions, test/homework, almost complete projects, several hundred lines of uncommented and unformatted code, urgent request and the like are easy to put in the "no-go box". But where should consulting begin instead of forum assistance?




Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question
How to post performance related questions
Links for Tally Table , Cross Tabs and Dynamic Cross Tabs , Delimited Split Function
Post #921166
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse