Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 49,711 through 49,725 (of 66,712 total)

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

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 1

Lynn Pettis (7/28/2015)
Okay, time for a Chicken Dentist 'cause I'm done trying to pull teeth on thread where someone thinks a loop is the only way to accomplish a one off report without even looking at possible alternatives.

Gotta link?

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

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

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

SQLRNNR (7/29/2015)
WayneS (7/29/2015)
BL0B_EATER (7/29/2015)
WayneS (7/28/2015)
I love it when I learn something in an area where I thought I knew it all.
You have made me very curious. What was the subject?
Table Variables. They automatically use a nolock query hint.
(Please Thread, don't smite me for posting code here...)
DECLARE @X TABLE (Col1 INT);
SELECT Col1
FROM @X
OPTION (RECOMPILE, QUERYTRACEON 3604, QUERYTRACEON 8607);
Oh and TF 3604 is typically used for certain console commands to output to screen. In this case, it is used to send the output of TF 8607 to screen.

STOP IT!

My job today is chase bad data (I already know the cause), NOT LAARN NEW THINGS!!!

😉

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.

WayneS SSC Guru Points: 95460 More actions · Answer 3

Jeff Moden (7/29/2015)
Lynn Pettis (7/28/2015)
Okay, time for a Chicken Dentist 'cause I'm done trying to pull teeth on thread where someone thinks a loop is the only way to accomplish a one off report without even looking at possible alternatives.
Gotta link?

Sure. link.

I think the OP is now ignoring the thread though.

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 4

Brandie Tarvin (7/29/2015)
SQLRNNR (7/29/2015)
WayneS (7/29/2015)
BL0B_EATER (7/29/2015)
WayneS (7/28/2015)
I love it when I learn something in an area where I thought I knew it all.
You have made me very curious. What was the subject?
Table Variables. They automatically use a nolock query hint.
(Please Thread, don't smite me for posting code here...)
DECLARE @X TABLE (Col1 INT);
SELECT Col1
FROM @X
OPTION (RECOMPILE, QUERYTRACEON 3604, QUERYTRACEON 8607);
Oh and TF 3604 is typically used for certain console commands to output to screen. In this case, it is used to send the output of TF 8607 to screen.
STOP IT!
My job today is chase bad data (I already know the cause), NOT LAARN NEW THINGS!!!
😉

It's a wasted day if you don't laarn something...

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 5

WayneS (7/29/2015)
Jeff Moden (7/29/2015)
Lynn Pettis (7/28/2015)
Okay, time for a Chicken Dentist 'cause I'm done trying to pull teeth on thread where someone thinks a loop is the only way to accomplish a one off report without even looking at possible alternatives.
Gotta link?
Sure. link.
I think the OP is now ignoring the thread though.

hmmm...

Interesting.

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

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

Oh Silver Spoon, how do you manage to keep a job when you keep asking such basic questions. At least you found the answer to one of your questions on your own.

jonathan.crawford SSCertifiable Points: 6612 More actions · Answer 7

Lynn Pettis (7/29/2015)
Oh Silver Spoon, how do you manage to keep a job when you keep asking such basic questions. At least you found the answer to one of your questions on your own.

one would assume because a) everyone else is worse where they work or b) someone keeps answering the questions.

-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

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

Lynn Pettis (7/29/2015)
Oh Silver Spoon, how do you manage to keep a job when you keep asking such basic questions. At least you found the answer to one of your questions on your own.

Cannot help humming this whenever you mention Silver Spoon

😎

It is only a ~~paper moon~~ Silver Spoon

Sailing over a cardboard sea

But it wouldn't be make believe

If you believed in me

jonathan.crawford SSCertifiable Points: 6612 More actions · Answer 9

Eirikur Eiriksson (7/29/2015)
Lynn Pettis (7/29/2015)
Oh Silver Spoon, how do you manage to keep a job when you keep asking such basic questions. At least you found the answer to one of your questions on your own.
Cannot help humming this whenever you mention Silver Spoon
😎
It is only a ~~paper moon~~ Silver Spoon
Sailing over a cardboard sea
But it wouldn't be make believe
If you believed in me

Yes, it's only a canvas sky,

floating over a muslin tree,

but it wouldn't be a make believe

if you believed in me

*sing it Nat!*

-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

jonathan.crawford (7/29/2015)
Lynn Pettis (7/29/2015)
Oh Silver Spoon, how do you manage to keep a job when you keep asking such basic questions. At least you found the answer to one of your questions on your own.
one would assume because a) everyone else is worse where they work or b) someone keeps answering the questions.

And the cat's in the cradle and the silver spoon
Little boy blue and the man in the moon

Or the alternative version

There's a cat in the kettle at the Peking Moon,
The place that I eat every day at noon.

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 11

And in breaking news...

The thread is about to turn 50,000.

Let the countdown begin.

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