Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 36,271 through 36,285 (of 66,712 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Okay, my google-fu is in suck mode again. Anyone have links to what the effect of using NOLOCK in your queries and why you shouldn't use them? The OP here could use the references. For his knowledge, and perhaps to help educate the database masters where he works.

Mark Cowne One Orange Chip Points: 26952 More actions · Answer 2

Lynn Pettis (5/24/2012)
Okay, my google-fu is in suck mode again. Anyone have links to what the effect of using NOLOCK in your queries and why you shouldn't use them? The OP here could use the references. For his knowledge, and perhaps to help educate the database masters where he works.

Here's one to start with

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/10/1280.aspx

____________________________________________________

Deja View - The strange feeling that somewhere, sometime you've optimised this query before

How to get the best help on a forum

http://www.sqlservercentral.com/articles/Best+Practices/61537

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 3

Lynn Pettis (5/23/2012)
AAARRRRRGGGGGGG!!!!!!!
Really, he just needs to go away. He isn't helpful at all.

Hi, Lynn.

I'm enjoying a cruel chuckle at your expense. 😀

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

The Dixie Flatline (5/24/2012)
Lynn Pettis (5/23/2012)
AAARRRRRGGGGGGG!!!!!!!
Really, he just needs to go away. He isn't helpful at all.
Hi, Lynn.
I'm enjoying a cruel chuckle at your expense. 😀

For some reason, I really do believe you. Glad I could make your day (week, month, year, decade, century, millennium, eon, epoch, ...). :w00t:

RBarryYoung SSC Guru Points: 143329 More actions · Answer 5

GilaMonster (5/23/2012)
dwain.c (5/22/2012)
Stefan Krzywicki (5/22/2012)
Lynn Pettis (5/22/2012)
If people would just format their code they could figure out some of their own problems. Geez.
Many should format it all at once, like with Format C:\
Perhaps the next time someone asks a really silly SQL question, someone will suggest this to solve their problem:
EXEC xp_cmdshell 'format c:\'
No, because chances are someone (the OP or a later visitor) will actually try it.

Heh. You don't know how many times I've almost posted a script to automatically find and drop every stored procedure that has a cursor in it. This is The only thing tthat stops me ... :w00t:

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

RBarryYoung SSC Guru Points: 143329 More actions · Answer 6

Is it my imagination or is Paul getting younger?

😀

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Paul White SSC Guru Points: 150467 More actions · Answer 7

RBarryYoung (5/24/2012)
Is it my imagination or is Paul getting younger?
😀

I wish :Wow:

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 8

http://dilbert.com/strips/comic/2012-05-25/[/url] hehe :hehe:

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

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 9

RBarryYoung (5/24/2012)
Is it my imagination or is Paul getting younger?
😀

Maybe he was experimenting with DBCC TIMEWARP and accidentally restored a backup copy of himself...

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 10

jcrawf02 (5/25/2012)
http://dilbert.com/strips/comic/2012-05-25/[/url] hehe :hehe:

There are days when I wish I could.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 11

Home finally. Lovely trip, but very glad to be back.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 12

GilaMonster (5/25/2012)
Home finally. Lovely trip, but very glad to be back.

Glad you had a good time and made it back. Everything OK, I assume.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 13

Steve Jones - SSC Editor (5/25/2012)
GilaMonster (5/25/2012)
Home finally. Lovely trip, but very glad to be back.
Glad you had a good time and made it back. Everything OK, I assume.

Yup.

My lounge looks like a garden shop. Workmen are busy resealing the balconies, so all my plants were brought inside

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 14

Could I get a few more people to look at the last few posts in this thread please? I want to be sure what I said is possibly the answer to the problem.

Thanks

Revenant SSC-Forever Points: 42467 More actions · Answer 15

Lynn Pettis (5/25/2012)
Could I get a few more people to look at the last few posts in this thread please? I want to be sure what I said is possibly the answer to the problem.
Thanks

Yes, it is, without that "possibly."