Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 12,646 through 12,660 (of 66,712 total)

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Lynn Pettis (3/15/2010)
GilaMonster (3/15/2010)
Lynn Pettis (3/15/2010)
Grant Fritchey (3/15/2010)
Lynn Pettis (3/15/2010)
Grant Fritchey (3/15/2010)
GSquared (3/15/2010)
Grant Fritchey (3/15/2010)
Oh cool, tossed under another bus. Thanks Alvin.
What year? (My birthday was yesterday, so I'm curious as to what the actual age difference is.) If you'd rather not say, then don't.
47, three more years before I'm legally dead.
I take exception to this remark, I'm not dead yet!! 😉
Are you sure?
Actually, yes. I am still quite able to eat my favorite spicy foods without getting heartburn or indigestion. A sure sign, in my opinion, that I'm still alive! :w00t:
You could be a ghost. Or a force spirit. Don't see either of them getting indigestion. 😀 :hehe:
Okay, but pretty sure they don't feel pain in their joints (particularly the knees). 😛

Ah, but skeletons do.

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 2

GSquared (3/15/2010)
Roy Ernest (3/15/2010)
Happy B'Day Grant...
And Gus Belated B'day wishes for you.
Thanks. 🙂

Hope you had a good birthday as well.

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

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 3

GSquared (3/15/2010)
Roy Ernest (3/15/2010)
Happy B'Day Grant...
And Gus Belated B'day wishes for you.
Thanks. 🙂

Absolutely. Belated best wishes.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Ron McCullough SSC Guru Points: 63877 More actions · Answer 4

Lynn Pettis (3/15/2010)
Grant Fritchey (3/15/2010)
Lynn Pettis (3/15/2010)
Grant Fritchey (3/15/2010)
GSquared (3/15/2010)
Grant Fritchey (3/15/2010)
Oh cool, tossed under another bus. Thanks Alvin.
What year? (My birthday was yesterday, so I'm curious as to what the actual age difference is.) If you'd rather not say, then don't.
47, three more years before I'm legally dead.
I take exception to this remark, I'm not dead yet!! 😉
Are you sure?
Actually, yes. I am still quite able to eat my favorite spicy foods without getting heartburn or indigestion. A sure sign, in my opinion, that I'm still alive! :w00t: (But that doesn't mean I don't feel older than I really am at times. 😛 )

All you young whipper snappers .... hope you last as long if not longer than myself ... (born April 18, 1932) .. no major aches, no major pains, one major surgery -- open heart, still able to rise and shine each morning. So you all plan to keep on plugging away

congratulations - keep on plugging away

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

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

Anybody else see a problem with this statement?

DECLARE @selectDate = getdate()-365

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]

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

bitbucket-25253 (3/15/2010)
Lynn Pettis (3/15/2010)
Grant Fritchey (3/15/2010)
Lynn Pettis (3/15/2010)
Grant Fritchey (3/15/2010)
GSquared (3/15/2010)
Grant Fritchey (3/15/2010)
Oh cool, tossed under another bus. Thanks Alvin.
What year? (My birthday was yesterday, so I'm curious as to what the actual age difference is.) If you'd rather not say, then don't.
47, three more years before I'm legally dead.
I take exception to this remark, I'm not dead yet!! 😉
Are you sure?
Actually, yes. I am still quite able to eat my favorite spicy foods without getting heartburn or indigestion. A sure sign, in my opinion, that I'm still alive! :w00t: (But that doesn't mean I don't feel older than I really am at times. 😛 )
All you young whipper snappers .... hope you last as long if not longer than myself ... (born April 18, 1932) .. no major aches, no major pains, one major surgery -- open heart, still able to rise and shine each morning. So you all plan to keep on plugging away
congratulations - keep on plugging away

I'll rise each morning, but don't expect me to shine! 😛

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

Alvin Ramard (3/15/2010)
Anybody else see a problem with this statement?
DECLARE @selectDate = getdate()-365

Yup

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

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

CirquedeSQLeil (3/15/2010)
Alvin Ramard (3/15/2010)
Anybody else see a problem with this statement?
DECLARE @selectDate = getdate()-365
Yup

The expression getdate()-365 was used in a few places in today's denormalization article. Now it's showing up in the discussion.

Thanks Jason. I was afraid that I was just getting too picky in my old age. I just love it when I find it in other people's code, especially from people that have been doing this longer than I have.

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]

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

Alvin Ramard (3/15/2010)
Anybody else see a problem with this statement?
DECLARE @selectDate = getdate()-365

Yes, in SQL Server 2008 it is missing the data type. Should be:

DECLARE @selectDate datetime = getdate() - 365;

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 10

bitbucket-25253 (3/15/2010)
Lynn Pettis (3/15/2010)
Grant Fritchey (3/15/2010)
Lynn Pettis (3/15/2010)
Grant Fritchey (3/15/2010)
GSquared (3/15/2010)
Grant Fritchey (3/15/2010)
Oh cool, tossed under another bus. Thanks Alvin.
What year? (My birthday was yesterday, so I'm curious as to what the actual age difference is.) If you'd rather not say, then don't.
47, three more years before I'm legally dead.
I take exception to this remark, I'm not dead yet!! 😉
Are you sure?
Actually, yes. I am still quite able to eat my favorite spicy foods without getting heartburn or indigestion. A sure sign, in my opinion, that I'm still alive! :w00t: (But that doesn't mean I don't feel older than I really am at times. 😛 )
All you young whipper snappers .... hope you last as long if not longer than myself ... (born April 18, 1932) .. no major aches, no major pains, one major surgery -- open heart, still able to rise and shine each morning. So you all plan to keep on plugging away
congratulations - keep on plugging away

1932 - I can't even get back that far using all my fingers and toes!

Although it's close....

Greg E

SQLRNNR SSC Guru Points: 281334 More actions · Answer 11

Lynn Pettis (3/15/2010)
Alvin Ramard (3/15/2010)
Anybody else see a problem with this statement?
DECLARE @selectDate = getdate()-365
Yes, in SQL Server 2008 it is missing the data type. Should be:
DECLARE @selectDate datetime = getdate() - 365;

Agreed. As it is written in the article, you can do a getdate() - 365. Though there are different methods of achieving that.

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

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

CirquedeSQLeil (3/15/2010)
Lynn Pettis (3/15/2010)
Alvin Ramard (3/15/2010)
Anybody else see a problem with this statement?
DECLARE @selectDate = getdate()-365
Yes, in SQL Server 2008 it is missing the data type. Should be:
DECLARE @selectDate datetime = getdate() - 365;
Agreed. As it is written in the article, you can do a getdate() - 365. Though there are different methods of achieving that.

I think y'all missed the point I was trying to make. I was referring to:

getdate() - 365 vs DATEADD(DAY, -365, GETDATE())

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]

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

Alvin Ramard (3/15/2010)
CirquedeSQLeil (3/15/2010)
Lynn Pettis (3/15/2010)
Alvin Ramard (3/15/2010)
Anybody else see a problem with this statement?
DECLARE @selectDate = getdate()-365
Yes, in SQL Server 2008 it is missing the data type. Should be:
DECLARE @selectDate datetime = getdate() - 365;
Agreed. As it is written in the article, you can do a getdate() - 365. Though there are different methods of achieving that.
I think y'all missed the point I was trying to make. I was referring to:
getdate() - 365 vs DATEADD(DAY, -365, GETDATE())

Those are equivalent.

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

Lynn Pettis (3/15/2010)
Alvin Ramard (3/15/2010)
CirquedeSQLeil (3/15/2010)
Lynn Pettis (3/15/2010)
Alvin Ramard (3/15/2010)
Anybody else see a problem with this statement?
DECLARE @selectDate = getdate()-365
Yes, in SQL Server 2008 it is missing the data type. Should be:
DECLARE @selectDate datetime = getdate() - 365;
Agreed. As it is written in the article, you can do a getdate() - 365. Though there are different methods of achieving that.
I think y'all missed the point I was trying to make. I was referring to:
getdate() - 365 vs DATEADD(DAY, -365, GETDATE())
Those are equivalent.

I know they're equivalent, but I've always considered the first case to be bad practice.

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]

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

Alvin Ramard (3/15/2010)
Lynn Pettis (3/15/2010)
Alvin Ramard (3/15/2010)
CirquedeSQLeil (3/15/2010)
Lynn Pettis (3/15/2010)
Alvin Ramard (3/15/2010)
Anybody else see a problem with this statement?
DECLARE @selectDate = getdate()-365
Yes, in SQL Server 2008 it is missing the data type. Should be:
DECLARE @selectDate datetime = getdate() - 365;
Agreed. As it is written in the article, you can do a getdate() - 365. Though there are different methods of achieving that.
I think y'all missed the point I was trying to make. I was referring to:
getdate() - 365 vs DATEADD(DAY, -365, GETDATE())
Those are equivalent.
I know they're equivalent, but I've always considered the first case to be bad practice.

Now that I'll agree with!