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 «««3,9163,9173,9183,9193,920»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Monday, March 18, 2013 2:32 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:10 PM
Points: 6,139, Visits: 7,193
SQLRNNR (3/15/2013)
Lynn Pettis (3/15/2013)
Lynn Pettis (3/15/2013)
I am really trying not say anything more over ther, but is really difficult. Group time at the TitD.

Hi, My name is Lynn and I am a troll, and not a cute one at that.



Sorry group, but I was forced to speak up again. I really don't like being called a her or she when I am a him or he.


Whatever you cutey


For some reason that has me thinking of River Song from Dr. Who.



- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1432340
Posted Monday, March 18, 2013 4:48 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:05 PM
Points: 5,566, Visits: 24,734
Can I brag, can I boast ..... can I pat myself on my own back ... wether I can or can not .. I will

My one hundreth QOD has been accepted for publication on 20 Mar -21 Mar 2013


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1432398
Posted Monday, March 18, 2013 5:30 PM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 7:07 PM
Points: 36,735, Visits: 31,185
bitbucket-25253 (3/18/2013)
Can I brag, can I boast ..... can I pat myself on my own back ... wether I can or can not .. I will

My one hundreth QOD has been accepted for publication on 20 Mar -21 Mar 2013


Absolutely awesome, Ron. That's incredible!


--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."

(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 #1432407
Posted Monday, March 18, 2013 5:35 PM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 7:07 PM
Points: 36,735, Visits: 31,185
Evil Kraig F (3/18/2013)
SQLRNNR (3/15/2013)
Lynn Pettis (3/15/2013)
Lynn Pettis (3/15/2013)
I am really trying not say anything more over ther, but is really difficult. Group time at the TitD.

Hi, My name is Lynn and I am a troll, and not a cute one at that.



Sorry group, but I was forced to speak up again. I really don't like being called a her or she when I am a him or he.


Whatever you cutey


For some reason that has me thinking of River Song from Dr. Who.


At least is wasn't "Deliverance".


--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."

(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 #1432408
Posted Monday, March 18, 2013 6:17 PM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 2:28 PM
Points: 33,062, Visits: 15,174
Thanks, Ron. Appreciate the support and questions from you.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1432420
Posted Tuesday, March 19, 2013 4:27 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:10 PM
Points: 6,139, Visits: 7,193
bitbucket-25253 (3/18/2013)
My one hundreth QOD has been accepted for publication on 20 Mar -21 Mar 2013


Rock on, my man. Rock on.



- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1432556
Posted Wednesday, March 20, 2013 12:06 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:55 PM
Points: 6,582, Visits: 8,860
Can you tell what days Steve featured one of my blog posts in the newsletter? Thanks Steve!



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 Attachments 
BlogCounter.jpg (220 views, 20.28 KB)
Post #1433392
Posted Wednesday, March 20, 2013 12:41 PM


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 @ 2:44 PM
Points: 42,443, Visits: 35,498
I'm getting the string impression, out of his depth and doesn't know it.
http://www.sqlservercentral.com/Forums/Topic1431330-1292-1.aspx



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 #1433418
Posted Wednesday, March 20, 2013 11:46 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 8:11 PM
Points: 23,003, Visits: 31,494
I am really wondering how some people manage to get into contracting when they have no idea how to write good, performing code and expect a free forum staffed by volunteers to help him write code to meet the clients requirements.



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 #1433593
Posted Wednesday, March 20, 2013 11:54 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 6:01 PM
Points: 3,609, Visits: 5,222
Lynn Pettis (3/20/2013)
I am really wondering how some people manage to get into contracting when they have no idea how to write good, performing code and expect a free forum staffed by volunteers to help him write code to meet the clients requirements.


I can think of two reasons:

1. Nobody knows they write poor performing code until their contract is up.
2. They get paid for the time they spend posting questions to the forum.




My mantra: No loops! No CURSORs! No RBAR! Hoo-uh!

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?
Since random numbers are too important to be left to chance, let's generate some!
Learn to understand recursive CTEs by example.
Splitting strings based on patterns can be fast!
Post #1433595
« Prev Topic | Next Topic »

Add to briefcase «««3,9163,9173,9183,9193,920»»»

Permissions Expand / Collapse