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,3714,3724,3734,3744,375»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Saturday, April 19, 2014 6:32 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Yesterday @ 6:47 PM
Points: 23,396, Visits: 32,229
It is amazing what crap advice people (Gail NOT included) give to others when they ask for help regarding suspect databases.


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 #1563246
Posted Saturday, April 19, 2014 7:42 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 7:53 AM
Points: 1,245, Visits: 6,684
Lynn Pettis (4/19/2014)
It is amazing what crap advice people (Gail NOT included) give to others when they ask for help regarding suspect databases.


I particularly like the fact that the thread was 6 years old.
And why it went suspect was key to how to plan recovery.
I wonder if a check engine light comes on, if some of them just pull the motor and get one out of a junk yard as a first attempt to fix?

Steve -
Although attention to details is part of or job, I wonder if something could be done at some time to at least pop up a message that the thread is so old when someone goes to reply.
Hate to see something that old churning up that kind of advice.
Especially on top of the correct starting point.

Hope everyone enjoys the Holiday weekend, if it is one they celebrate.
Post #1563250
Posted Saturday, April 19, 2014 7:49 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Yesterday @ 6:47 PM
Points: 23,396, Visits: 32,229
Greg Edwards-268690 (4/19/2014)
Lynn Pettis (4/19/2014)
It is amazing what crap advice people (Gail NOT included) give to others when they ask for help regarding suspect databases.


I particularly like the fact that the thread was 6 years old.
And why it went suspect was key to how to plan recovery.
I wonder if a check engine light comes on, if some of them just pull the motor and get one out of a junk yard as a first attempt to fix?

Steve -
Although attention to details is part of or job, I wonder if something could be done at some time to at least pop up a message that the thread is so old when someone goes to reply.
Hate to see something that old churning up that kind of advice.
Especially on top of the correct starting point.

Hope everyone enjoys the Holiday weekend, if it is one they celebrate.


Check Engine Light? First stop is AutoZone to have them tell me what the problem is. Costs me nothing at that point.



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 #1563252
Posted Saturday, April 19, 2014 8:04 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 7:53 AM
Points: 21,744, Visits: 15,436
Lynn Pettis (4/19/2014)
Greg Edwards-268690 (4/19/2014)
Lynn Pettis (4/19/2014)
It is amazing what crap advice people (Gail NOT included) give to others when they ask for help regarding suspect databases.


I particularly like the fact that the thread was 6 years old.
And why it went suspect was key to how to plan recovery.
I wonder if a check engine light comes on, if some of them just pull the motor and get one out of a junk yard as a first attempt to fix?

Steve -
Although attention to details is part of or job, I wonder if something could be done at some time to at least pop up a message that the thread is so old when someone goes to reply.
Hate to see something that old churning up that kind of advice.
Especially on top of the correct starting point.

Hope everyone enjoys the Holiday weekend, if it is one they celebrate.


Check Engine Light? First stop is AutoZone to have them tell me what the problem is. Costs me nothing at that point.


Why wouldn't you just go change all your tires and gas tank for that?




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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1563256
Posted Saturday, April 19, 2014 8:10 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Yesterday @ 6:47 PM
Points: 23,396, Visits: 32,229
SQLRNNR (4/19/2014)
Lynn Pettis (4/19/2014)
Greg Edwards-268690 (4/19/2014)
Lynn Pettis (4/19/2014)
It is amazing what crap advice people (Gail NOT included) give to others when they ask for help regarding suspect databases.


I particularly like the fact that the thread was 6 years old.
And why it went suspect was key to how to plan recovery.
I wonder if a check engine light comes on, if some of them just pull the motor and get one out of a junk yard as a first attempt to fix?

Steve -
Although attention to details is part of or job, I wonder if something could be done at some time to at least pop up a message that the thread is so old when someone goes to reply.
Hate to see something that old churning up that kind of advice.
Especially on top of the correct starting point.

Hope everyone enjoys the Holiday weekend, if it is one they celebrate.


Check Engine Light? First stop is AutoZone to have them tell me what the problem is. Costs me nothing at that point.


Why wouldn't you just go change all your tires and gas tank for that?


Had a car once that got 50 MPG, at one point the car was down to getting only 40 MPG, solution? Replaced the original spark plugs, wires, rotor and cap and miraculously the car went back to 50 MPG. Of course I did this at 105,521 miles on the car.



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 #1563258
Posted Saturday, April 19, 2014 8:40 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 7:53 AM
Points: 1,245, Visits: 6,684
Lynn Pettis (4/19/2014)
SQLRNNR (4/19/2014)
Lynn Pettis (4/19/2014)
Greg Edwards-268690 (4/19/2014)
Lynn Pettis (4/19/2014)
It is amazing what crap advice people (Gail NOT included) give to others when they ask for help regarding suspect databases.


I particularly like the fact that the thread was 6 years old.
And why it went suspect was key to how to plan recovery.
I wonder if a check engine light comes on, if some of them just pull the motor and get one out of a junk yard as a first attempt to fix?

Steve -
Although attention to details is part of or job, I wonder if something could be done at some time to at least pop up a message that the thread is so old when someone goes to reply.
Hate to see something that old churning up that kind of advice.
Especially on top of the correct starting point.

Hope everyone enjoys the Holiday weekend, if it is one they celebrate.


Check Engine Light? First stop is AutoZone to have them tell me what the problem is. Costs me nothing at that point.


Why wouldn't you just go change all your tires and gas tank for that?


Had a car once that got 50 MPG, at one point the car was down to getting only 40 MPG, solution? Replaced the original spark plugs, wires, rotor and cap and miraculously the car went back to 50 MPG. Of course I did this at 105,521 miles on the car.


I once bought a 1966 GTO for $800 that had a miss.
Car only had 15,600 miles on it.
Spark plug wires, not the valve job the guy was thinking.
So it pays to diagnose things.
Wish I still had that one.
Post #1563263
Posted Saturday, April 19, 2014 11:30 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 12:38 AM
Points: 33,267, Visits: 15,436
Greg Edwards-268690 (4/19/2014)

Steve -
Although attention to details is part of or job, I wonder if something could be done at some time to at least pop up a message that the thread is so old when someone goes to reply.
Hate to see something that old churning up that kind of advice.
Especially on top of the correct starting point.

Hope everyone enjoys the Holiday weekend, if it is one they celebrate.


A good idea. I get caught by this sometimes myself. I'll add this to the list.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1563271
Posted Saturday, April 19, 2014 2:38 PM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Yesterday @ 11:19 PM
Points: 37,075, Visits: 31,636
Steve Jones - SSC Editor (4/19/2014)
Greg Edwards-268690 (4/19/2014)

Steve -
Although attention to details is part of or job, I wonder if something could be done at some time to at least pop up a message that the thread is so old when someone goes to reply.
Hate to see something that old churning up that kind of advice.
Especially on top of the correct starting point.

Hope everyone enjoys the Holiday weekend, if it is one they celebrate.


A good idea. I get caught by this sometimes myself. I'll add this to the list.


I actually don't care how old a post is. If I think additional information or a better solution is required, I'll post it no matter how old the post is. If someone resurrects a post with crap advice, let them do so at their own risk. There's better things to burn precious Developer time on, like getting rid of the IFCode Shortcuts to the left of the post creation window in favor of making them clickable icons at the top of the edit window. It would also be damned handy if the text color and highlight selections had a clickable color wheel (or at least a set of standard colors) to pick from instead of having to type "RED" for the color or some god awful RGB code.

Another set of niceties would be to update the code colorizer and move the smileys from the right of the edit window up to the menu bar, as well as the IFCodes .


--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 #1563290
Posted Sunday, April 20, 2014 2:28 AM


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: Yesterday @ 8:29 PM
Points: 3,648, Visits: 5,322
Greg Edwards-268690 (4/19/2014)
Lynn Pettis (4/19/2014)
SQLRNNR (4/19/2014)
Lynn Pettis (4/19/2014)
Greg Edwards-268690 (4/19/2014)
Lynn Pettis (4/19/2014)
It is amazing what crap advice people (Gail NOT included) give to others when they ask for help regarding suspect databases.


I particularly like the fact that the thread was 6 years old.
And why it went suspect was key to how to plan recovery.
I wonder if a check engine light comes on, if some of them just pull the motor and get one out of a junk yard as a first attempt to fix?

Steve -
Although attention to details is part of or job, I wonder if something could be done at some time to at least pop up a message that the thread is so old when someone goes to reply.
Hate to see something that old churning up that kind of advice.
Especially on top of the correct starting point.

Hope everyone enjoys the Holiday weekend, if it is one they celebrate.


Check Engine Light? First stop is AutoZone to have them tell me what the problem is. Costs me nothing at that point.


Why wouldn't you just go change all your tires and gas tank for that?


Had a car once that got 50 MPG, at one point the car was down to getting only 40 MPG, solution? Replaced the original spark plugs, wires, rotor and cap and miraculously the car went back to 50 MPG. Of course I did this at 105,521 miles on the car.


I once bought a 1966 GTO for $800 that had a miss.
Car only had 15,600 miles on it.
Spark plug wires, not the valve job the guy was thinking.
So it pays to diagnose things.
Wish I still had that one.


I had a '68 GTO that coincidentally I think I paid $800 for.

So we have goats and fish in common.



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 #1563313
Posted Sunday, April 20, 2014 6:52 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 7:53 AM
Points: 1,245, Visits: 6,684
Dwain -

Hope my car is faster, as I can't even stretch a fish lie to make one that big.

Not the '66, but still have a Goat in the garage.
This summer's project.

If you ever make it near Minnesota, look me up.
Post #1563333
« Prev Topic | Next Topic »

Add to briefcase «««4,3714,3724,3734,3744,375»»»

Permissions Expand / Collapse