Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 45,586 through 45,600 (of 66,712 total)

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

TomThomson SSC Guru Points: 104773 More actions · Answer 1

Stefan Krzywicki (9/10/2014)
TomThomson (9/10/2014)
Stefan Krzywicki (9/10/2014)
Date columns as a varchar(7). What are you even putting in there? Still better than the date columns as Timestamp I guess.
It's probably the ISO-8061 presentation format for a month: YYYY-MM is 7 characters. Varchar because they might want to designate a year (YYYY). That's one of the rare occassions where Celko prefers to contravene the standard - he insists on char(9) (YYYY-MM-00 for a month, so presumably YYYY-00-00 for a year as it's char not varchar).
Maybe, but for "Date Entered"? Seems a little vague.
I thought Celko hated storing presentation in the database.

Yes, generally he does. However he apparently hates agreeing with anyone in a forum even more, because he's been pushing YYYY-MM-00 format for a month in one of the discussions on SQLServerCentral while everyone else who had suggestions for the OP wanted to use something more sensible.

(By the way Luis, I didn't use a shotgun, it was a mere peashooter. :-D)

Tom

Sean Lange SSC Guru Points: 286590 More actions · Answer 2

TomThomson (9/10/2014)
Yes, generally he does. However he apparently hates agreeing with anyone in a forum even more, because he's been pushing YYYY-MM-00 format for a month in one of the discussions on SQLServerCentral while everyone else who had suggestions for the OP wanted to use something more sensible.

I haven't seen that exact thread but it is kind of funny. He complains so often about using local dialect yet when it comes to dates I have seen him mention that this one (from MySql) is ok because "it is one I particularly like". Often times it seems he can't agree with himself online, let alone anyone else.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

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

Sean Lange (9/10/2014)
TomThomson (9/10/2014)
Yes, generally he does. However he apparently hates agreeing with anyone in a forum even more, because he's been pushing YYYY-MM-00 format for a month in one of the discussions on SQLServerCentral while everyone else who had suggestions for the OP wanted to use something more sensible.
I haven't seen that exact thread but it is kind of funny. He complains so often about using local dialect yet when it comes to dates I have seen him mention that this one (from MySql) is ok because "it is one I particularly like". Often times it seems he can't agree with himself online, let alone anyone else.

Heh... in words similar to those that he's whipped on others, he should get out of the 50's and read a book on database design.

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

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

TomThomson (9/10/2014)
Stefan Krzywicki (9/10/2014)
TomThomson (9/10/2014)
Stefan Krzywicki (9/10/2014)
Date columns as a varchar(7). What are you even putting in there? Still better than the date columns as Timestamp I guess.
It's probably the ISO-8061 presentation format for a month: YYYY-MM is 7 characters. Varchar because they might want to designate a year (YYYY). That's one of the rare occassions where Celko prefers to contravene the standard - he insists on char(9) (YYYY-MM-00 for a month, so presumably YYYY-00-00 for a year as it's char not varchar).
Maybe, but for "Date Entered"? Seems a little vague.
I thought Celko hated storing presentation in the database.
Yes, generally he does. However he apparently hates agreeing with anyone in a forum even more, because he's been pushing YYYY-MM-00 format for a month in one of the discussions on SQLServerCentral while everyone else who had suggestions for the OP wanted to use something more sensible.
(By the way Luis, I didn't use a shotgun, it was a mere peashooter. :-D)

So how is the "noobe" doing:-P Still laughing after reading your response Tom, bl... brilliant!

😎

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

Waaaaay out of his depth... http://www.sqlservercentral.com/Forums/Topic1612186-357-1.aspx

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

Ed Wagner SSC Guru Points: 287026 More actions · Answer 6

Jeff Moden (9/10/2014)
Sean Lange (9/10/2014)
TomThomson (9/10/2014)
Yes, generally he does. However he apparently hates agreeing with anyone in a forum even more, because he's been pushing YYYY-MM-00 format for a month in one of the discussions on SQLServerCentral while everyone else who had suggestions for the OP wanted to use something more sensible.
I haven't seen that exact thread but it is kind of funny. He complains so often about using local dialect yet when it comes to dates I have seen him mention that this one (from MySql) is ok because "it is one I particularly like". Often times it seems he can't agree with himself online, let alone anyone else.
Heh... in words similar to those that he's whipped on others, he should get out of the 50's and read a book on database design.

I bet that suggestion would grind him right to the core. That would be hilarious. In considering the size of the reply, however, I'm forced to wonder about this site, specifically the data type that stores a forum post. I've seen them get pretty long, but his reply/rant could go on for days. It might even set a new record for the longest forum post ever.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Sioban Krzywicki One Orange Chip Points: 27770 More actions · Answer 7

Ed Wagner (9/10/2014)
Jeff Moden (9/10/2014)
Sean Lange (9/10/2014)
TomThomson (9/10/2014)
Yes, generally he does. However he apparently hates agreeing with anyone in a forum even more, because he's been pushing YYYY-MM-00 format for a month in one of the discussions on SQLServerCentral while everyone else who had suggestions for the OP wanted to use something more sensible.
I haven't seen that exact thread but it is kind of funny. He complains so often about using local dialect yet when it comes to dates I have seen him mention that this one (from MySql) is ok because "it is one I particularly like". Often times it seems he can't agree with himself online, let alone anyone else.
Heh... in words similar to those that he's whipped on others, he should get out of the 50's and read a book on database design.
I bet that suggestion would grind him right to the core. That would be hilarious. In considering the size of the reply, however, I'm forced to wonder about this site, specifically the data type that stores a forum post. I've seen them get pretty long, but his reply/rant could go on for days. It might even set a new record for the longest forum post ever.

I'm sure they just made every column varchar(max). Then you don't have to worry about it, right?

--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

WayneS SSC Guru Points: 95460 More actions · Answer 8

Steve Jones - SSC Editor (9/10/2014)
WayneS (9/10/2014)
Sean Lange (9/9/2014)
I think I should be able to make it for the afternoon sessions. The last game should be done a little before noon. Cerner is about 45 minutes away from the soccer field so I think I could make it by the 12:45 session or at least be early for the next one. Registration is full but I am on the waiting list. I will be able to stick around for the social hour at the end for sure.
There are always no-shows, and people leaving early, so come on out. Look me up...
Wayne!!!!
BBQ time is a couple days away.

:ermm: And then I re-read Sean's original post... for some reason, I thought we were talking about Denver. I won't be in KC, but will be in Denver. Anyone else going there that I can meet up with?

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

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 9

WayneS (9/10/2014)
:ermm: And then I re-read Sean's original post... for some reason, I thought we were talking about Denver. I won't be in KC, but will be in Denver. Anyone else going there that I can meet up with?

Are you saying you don't want to meet me?

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

Hooray!! We have Internet again!! Been down for nearly 24 hours. Can't wait to get back to 1st World Internet capabilities!

WayneS SSC Guru Points: 95460 More actions · Answer 11

Steve Jones - SSC Editor (9/10/2014)
WayneS (9/10/2014)
:ermm: And then I re-read Sean's original post... for some reason, I thought we were talking about Denver. I won't be in KC, but will be in Denver. Anyone else going there that I can meet up with?
Are you saying you don't want to meet me?

And here I was thinking that we'd gotten past that old meet-and-greet thing. Sure... I'll meet you too!

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

Sioban Krzywicki One Orange Chip Points: 27770 More actions · Answer 12

Oh thank goodness a reasonable answer. It isn't varchar(7) it is datetimeoffset(7) and the modeling tool (Happy Fish) can't handle that.

I'm still not sure why they're using datetimeoffset(7) instead of datetimeoffset(0), but that's a much less serious question.

--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

Sean Lange SSC Guru Points: 286590 More actions · Answer 13

WayneS (9/10/2014)
Steve Jones - SSC Editor (9/10/2014)
WayneS (9/10/2014)
Sean Lange (9/9/2014)
I think I should be able to make it for the afternoon sessions. The last game should be done a little before noon. Cerner is about 45 minutes away from the soccer field so I think I could make it by the 12:45 session or at least be early for the next one. Registration is full but I am on the waiting list. I will be able to stick around for the social hour at the end for sure.
There are always no-shows, and people leaving early, so come on out. Look me up...
Wayne!!!!
BBQ time is a couple days away.
:ermm: And then I re-read Sean's original post... for some reason, I thought we were talking about Denver. I won't be in KC, but will be in Denver. Anyone else going there that I can meet up with?

Bah!!! It isn't too late. Come join us for some BBQ.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Sean Lange SSC Guru Points: 286590 More actions · Answer 14

Lynn Pettis (9/10/2014)
Hooray!! We have Internet again!! Been down for nearly 24 hours. Can't wait to get back to 1st World Internet capabilities!

Welcome back!!!

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

SQLRNNR SSC Guru Points: 281334 More actions · Answer 15

Everything is awesome

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