Are the posted questions getting worse?

Question

Post reply

Are the posted questions getting worse?

Viewing 15 posts - 12,811 through 12,825 (of 66,000 total)

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

SQLRNNR SSC Guru Points: 281324 More actions · Answer 1

tstaker (3/16/2010)

The Dixie Flatline (3/16/2010)

...Gail, in ancient Geece you would have been a goddess in the Geek pantheon.

So what you're saying is around 137 BC she'd be a goddess in the Geek pantheon to 42% of the known world?

Precisely

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: 53353 More actions · Answer 2

tstaker (3/16/2010)

The Dixie Flatline (3/16/2010)

...Gail, in ancient Geece you would have been a goddess in the Geek pantheon.

So what you're saying is around 137 BC she'd be a goddess in the Geek pantheon to 42% of the known world?

Exactly 🙂

The question I have always had is about the "known" part. Known to whom? I mean, after all, 58% of the the world didn't know about the ancient Geeks! I personally see myself as a deity in some minor civilization's pantheon... with a very limited scope of responsibility... maybe the god of function keys... even the tilde key would be nice.

__________________________________________________

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

john.arnott SSChampion Points: 11882 More actions · Answer 3

john.arnott

SSChampion

Points: 11882

March 16, 2010 at 4:19 pm

#1134898

Paul White (3/12/2010)

Jeff Moden (3/12/2010)

We're rootin' for ya!

* snigger *

See the entry for root here

And when you go to London, do you wear a fanny-pack? (Hey. He started it....)

LutzM SSC Guru Points: 107049 More actions · Answer 4

Slightly off-topic:

Anybody interested in helping me out here?

I'm starting (already started?) to leave my comfort-zone and don't want to misguide the OP...

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

john.arnott SSChampion Points: 11882 More actions · Answer 5

john.arnott

SSChampion

Points: 11882

March 16, 2010 at 5:26 pm

#1134917

The question that came to my mind with @SelectDate = getdate() - 365 is that it implies a date-only value. That is, there's nothing there to strip off the clock time.

SQLRNNR SSC Guru Points: 281324 More actions · Answer 6

lmu92 (3/16/2010)

Slightly off-topic:

Anybody interested in helping me out here?

I'm starting (already started?) to leave my comfort-zone and don't want to misguide the OP...

I think that was a good answer.

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

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 7

Paul White (3/16/2010)

GilaMonster (3/16/2010)

I feel another blog rant coming.

See if you can include that http://en.wikipedia.org/wiki/Argument_from_authority link. Very cool.

Other thing that frustrates me, along the same lines, is people insisting that a specific feature is deprecated when it's not.

Heh. Like CONVERT, DBCC SQLPERF, and COALESCE? I think I have read threads claiming all those are deprecated recently...

The thing that bothers me most is getting distracted by dealing with the incorrect claims rather than getting on with answering the OP.

Ah well.

Heh... I wish MS would deprecate deprecation and start supporting some of the undocumented code they use to run SQL Server with.

--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)
Intro to Tally Tables and Functions

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 8

Lynn Pettis (3/16/2010)

[font="Comic Sans MS"]Party at the Tent in the Desert. The Hippo has been alerted that guests will be arriving.[/font]

This post is number 10,001

Freakin' awesome! #4 to ever cross the 10k barrier. Well done, Lynn!

--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)
Intro to Tally Tables and Functions

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 9

Paul White (3/16/2010)

Isn't Bob's/Dixie's article an excellent read today?

Shame about some of the layout, but hopefully that will be fixed soon.

Most enjoyable.

It is, indeed!

--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)
Intro to Tally Tables and Functions

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 10

Paul White (3/16/2010)

jcrawf02 (3/16/2010)

Paul White (3/15/2010)

In fact it is as bad as DATEADD(DAY, DATEDIFF(DAY, 0, CURRENT_TIMESTAMP), 0).

All right Paul, edumacate me. Why is this bad?

Zero is not a date any more than 365 is 😉

Heh... I just can't see writing it this way...

DATEADD(DAY, DATEDIFF(DAY, CAST('19000101' AS DATETIME), CURRENT_TIMESTAMP), CAST('19000101' AS DATETIME))

--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)
Intro to Tally Tables and Functions

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 11

GSquared (3/16/2010)

Paul White (3/16/2010)

jcrawf02 (3/16/2010)

Paul White (3/15/2010)

In fact it is as bad as DATEADD(DAY, DATEDIFF(DAY, 0, CURRENT_TIMESTAMP), 0).

All right Paul, edumacate me. Why is this bad?

Zero is not a date any more than 365 is 😉

Good point. I've used that one. Easy enough to put an explicit date in there. Same way I do when I need to do seconds or minutes in that same kind of calculation.

I assume that by "explicit date" you mean something like '1900-01-01'... and that's not a date either... that's a string that looks like a date. 😛

--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)
Intro to Tally Tables and Functions

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 12

Paul White (3/16/2010)

GSquared (3/16/2010)

Good point. I've used that one. Easy enough to put an explicit date in there. Same way I do when I need to do seconds or minutes in that same kind of calculation.

Yep. I think an arbitrary date makes the purpose of the function easier to see as well. Zero just looks like black magic.

heh... and now we know why I love it. 😀

--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)
Intro to Tally Tables and Functions

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 13

Roy Ernest (3/16/2010)

CirquedeSQLeil (3/16/2010)

Roy Ernest (3/16/2010)

I got my $500 yesterday. If I can write an article there, anyone here can write it for sure. 🙂

You wrote an article for the standard? What's the link so we can go read it.

It has not been published yet. Still more people in front of the queue. 🙂

What is the subject matter for your article, Roy?

--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)
Intro to Tally Tables and Functions

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 14

Roy Ernest (3/16/2010)

I got 3 rounds of back side kicking ... 🙂

Heh... rookies all... pork chops are the only way to go. 😛

--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)
Intro to Tally Tables and Functions

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 15

Roy Ernest (3/16/2010)

137 consistency errors...

Isnt that the number of parameters for DBCC TIMEWARP ?:-D

... and the number on my old beer mug. :hehe:

--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)
Intro to Tally Tables and Functions