Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 49,786 through 49,800 (of 66,712 total)

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

Brandie Tarvin SSC Guru Points: 173061 More actions · Answer 1

Cadavre (7/31/2015)
Brandie Tarvin (7/30/2015)
Why oh why oh why do people insist on using WITH (NOLOCK) instead of doing things like setting transaction isolation levels or fixing indexes to resolve performance issues?
Work thing. I've been trying to stamp out WITH (NOLOCK) use and now because things "aren't working" one group is trying to throw it back in.
ARGH!
Well, this is my battle for the week.
EDIT: Seriously, can anyone give me a real reason why WITH (NOLOCK) might be functionally necessary for production code?
In our continuous integration server (TeamCity), one of the configurations installs our database. It then fires a "Validation Tool" that I wrote against the installed database and produces a report. One of the tests is to check for NOLOCK, if it is found then it fails the build and sets off the siren of shame[/url] and sends an e-mail to the person that caused the issue. I thoroughly recommend doing something similar for your own development environment.

Hrm. Interesting idea. We have a lot of old procs that still need cleaned up, though.

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.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

Cadavre (7/31/2015)
Brandie Tarvin (7/30/2015)
Why oh why oh why do people insist on using WITH (NOLOCK) instead of doing things like setting transaction isolation levels or fixing indexes to resolve performance issues?
Work thing. I've been trying to stamp out WITH (NOLOCK) use and now because things "aren't working" one group is trying to throw it back in.
ARGH!
Well, this is my battle for the week.
EDIT: Seriously, can anyone give me a real reason why WITH (NOLOCK) might be functionally necessary for production code?
In our continuous integration server (TeamCity), one of the configurations installs our database. It then fires a "Validation Tool" that I wrote against the installed database and produces a report. One of the tests is to check for NOLOCK, if it is found then it fails the build and sets off the siren of shame[/url] and sends an e-mail to the person that caused the issue. I thoroughly recommend doing something similar for your own development environment.

I like the idea of the siren. We used a howling monkey.

And in other news ... you changed your profile pic.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

rodjkidd (7/31/2015)
Oops. Obviously need more coffee...
Posted this to the wrong thread!
So I am now wondering what a Gummy Bear surgical operation is...

Google: gummy bear plastic surgery

or

gummy bear procedure

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

WayneS SSC Guru Points: 95460 More actions · Answer 4

SQLRNNR (7/31/2015)
rodjkidd (7/31/2015)
Oops. Obviously need more coffee...
Posted this to the wrong thread!
So I am now wondering what a Gummy Bear surgical operation is...
Google: gummy bear plastic surgery
or
gummy bear procedure

Links added

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

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
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

WayneS SSC Guru Points: 95460 More actions · Answer 5

Looks like Luis is answering Oracle questions now.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

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
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

WayneS (7/31/2015)
SQLRNNR (7/31/2015)
rodjkidd (7/31/2015)
Oops. Obviously need more coffee...
Posted this to the wrong thread!
So I am now wondering what a Gummy Bear surgical operation is...
Google: gummy bear plastic surgery
or
gummy bear procedure
Links added

Troublemaker:w00t:

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Jack Corbett SSC Guru Points: 184394 More actions · Answer 7

Cadavre (7/31/2015)
Brandie Tarvin (7/30/2015)
Why oh why oh why do people insist on using WITH (NOLOCK) instead of doing things like setting transaction isolation levels or fixing indexes to resolve performance issues?
Work thing. I've been trying to stamp out WITH (NOLOCK) use and now because things "aren't working" one group is trying to throw it back in.
ARGH!
Well, this is my battle for the week.
EDIT: Seriously, can anyone give me a real reason why WITH (NOLOCK) might be functionally necessary for production code?
In our continuous integration server (TeamCity), one of the configurations installs our database. It then fires a "Validation Tool" that I wrote against the installed database and produces a report. One of the tests is to check for NOLOCK, if it is found then it fails the build and sets off the siren of shame[/url] and sends an e-mail to the person that caused the issue. I thoroughly recommend doing something similar for your own development environment.

Not an expert but I think you could do this with Policy Based Management. It would be nice if this check got added in the Code Analysis rules in SSDT database projects as well.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Luis Cazares SSC Guru Points: 183706 More actions · Answer 8

WayneS (7/31/2015)
Looks like Luis is answering Oracle questions now.

That wasn't the only attempt on that day. Here's a completely lost Oracle user.

But hey, as long as I can help.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Y.B. SSChampion Points: 11649 More actions · Answer 9

Love it when the boss comes out and says you get to leave at 2pm! (we are heading into a long weekend here for context)

SELECT quote FROM brain WHERE original = 1
0 rows returned

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 10

Luis Cazares (7/31/2015)
WayneS (7/31/2015)
Looks like Luis is answering Oracle questions now.
That wasn't the only attempt on that day. Here's a completely lost Oracle user.
But hey, as long as I can help.

I had to walk away from that last one. I expected that one to go one forever.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 11

Ladies and gentlemen, take my advice - pull down your pants and slide on the ice.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

Alvin Ramard (7/31/2015)
Ladies and gentlemen, take my advice - pull down your pants and slide on the ice.

screeeeeeeeeeeeeeeeeeeeeeeeeeech

What?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

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

Alvin Ramard (7/31/2015)
Luis Cazares (7/31/2015)
WayneS (7/31/2015)
Looks like Luis is answering Oracle questions now.
That wasn't the only attempt on that day. Here's a completely lost Oracle user.
But hey, as long as I can help.
I had to walk away from that last one. I expected that one to go one forever.

Here's another one.... I noticed the USING, instead of WITH for the cte.

http://www.sqlservercentral.com/Forums/Topic1706970-3077-1.aspx

__________________________________________________

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

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 14

SQLRNNR (7/31/2015)
Alvin Ramard (7/31/2015)
Ladies and gentlemen, take my advice - pull down your pants and slide on the ice.
screeeeeeeeeeeeeeeeeeeeeeeeeeech
What?

That would be much louder and butted with "il culo rosso":-D

😎

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 15

SQLRNNR (7/31/2015)
Alvin Ramard (7/31/2015)
Ladies and gentlemen, take my advice - pull down your pants and slide on the ice.
screeeeeeeeeeeeeeeeeeeeeeeeeeech
What?

You're not familiar with the saying?

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]