Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 21,091 through 21,105 (of 66,749 total)

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

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

Grant Fritchey (11/2/2010)
For those who don't know, several of our locals are up for an award at SQLServerPedia for blog posts done over the last year. Gail is in three different categories and looks good to win two of them. I'm in two and actually possibly a contender in one. Please support us, or whoever you think is better, and go vote.
Thanks.

Grant... the link doesn't work. At least for me, it doesn't.

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

spaghettidba SSC Guru Points: 105732 More actions · Answer 2

Jeff Moden (11/2/2010)
Grant Fritchey (11/2/2010)
For those who don't know, several of our locals are up for an award at SQLServerPedia for blog posts done over the last year. Gail is in three different categories and looks good to win two of them. I'm in two and actually possibly a contender in one. Please support us, or whoever you think is better, and go vote.
Thanks.
Grant... the link doesn't work.

The link is correct (I opened it 1 hr ago) but now it doesn't work any more. Maybe their server is down for some reason.

-- Gianluca Sartori

GSquared SSC Guru Points: 260824 More actions · Answer 3

Jeff Moden (11/2/2010)
Grant Fritchey (11/2/2010)
For those who don't know, several of our locals are up for an award at SQLServerPedia for blog posts done over the last year. Gail is in three different categories and looks good to win two of them. I'm in two and actually possibly a contender in one. Please support us, or whoever you think is better, and go vote.
Thanks.
Grant... the link doesn't work. At least for me, it doesn't.

Worked for me about 15 minutes ago.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Grant Fritchey SSC Guru Points: 398916 More actions · Answer 4

Jeff Moden (11/2/2010)
Grant Fritchey (11/2/2010)
For those who don't know, several of our locals are up for an award at SQLServerPedia for blog posts done over the last year. Gail is in three different categories and looks good to win two of them. I'm in two and actually possibly a contender in one. Please support us, or whoever you think is better, and go vote.
Thanks.
Grant... the link doesn't work. At least for me, it doesn't.

I think the server is down. I hope I don't have to go around begging for votes again. It's been enough of a pain in the bottom.

"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

WayneS SSC Guru Points: 95461 More actions · Answer 5

Date field stored as varchar(8000) - what kinds of problems do you see coming up from this OP?

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

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

WayneS (11/2/2010)
Date field stored as varchar(8000) - what kinds of problems do you see coming up from this OP?

8000 characters for a date? I could store an entire calendar in there...

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

Brandie Tarvin SSC Guru Points: 173083 More actions · Answer 7

GilaMonster (11/2/2010)
WayneS (11/2/2010)
Date field stored as varchar(8000) - what kinds of problems do you see coming up from this OP?
8000 characters for a date? I could store an entire calendar in there...

Done correctly, you could stick two calendars in there. Gregorian & Julian.

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.

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

Grant Fritchey (11/2/2010)
For those who don't know, several of our locals are up for an award at SQLServerPedia for blog posts done over the last year. Gail is in three different categories and looks good to win two of them. I'm in two and actually possibly a contender in one. Please support us, or whoever you think is better, and go vote.

Big thank you to everyone here who has voted, I'm now second overall (for a little while anyway) :w00t: 😎 :w00t:

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

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

Brandie Tarvin (11/2/2010)
GilaMonster (11/2/2010)
WayneS (11/2/2010)
Date field stored as varchar(8000) - what kinds of problems do you see coming up from this OP?
8000 characters for a date? I could store an entire calendar in there...
Done correctly, you could stick two calendars in there. Gregorian & Julian.

Klingon and Minbari are far more fun, but they might require nvarchar

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

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 10

Brandie Tarvin (11/2/2010)
GilaMonster (11/2/2010)
WayneS (11/2/2010)
Date field stored as varchar(8000) - what kinds of problems do you see coming up from this OP?
8000 characters for a date? I could store an entire calendar in there...
Done correctly, you could stick two calendars in there. Gregorian & Julian.

Nah nah, need nVARCHAR(4000), and put the Mayan one in there. 😛

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

Kit G SSCrazy Points: 2888 More actions · Answer 11

Grant Fritchey (11/2/2010)
Jeff Moden (11/2/2010)
Grant Fritchey (11/2/2010)
For those who don't know, several of our locals are up for an award at SQLServerPedia for blog posts done over the last year. Gail is in three different categories and looks good to win two of them. I'm in two and actually possibly a contender in one. Please support us, or whoever you think is better, and go vote.
Thanks.
Grant... the link doesn't work. At least for me, it doesn't.
I think the server is down. I hope I don't have to go around begging for votes again. It's been enough of a pain in the bottom.

It's back up. I had a problem a little while ago, but it seems to have cleared up. Perhaps it was just overloaded by Threadizans going there to vote. 🙂

-- Kit

GSquared SSC Guru Points: 260824 More actions · Answer 12

Kit G (11/2/2010)
Grant Fritchey (11/2/2010)
Jeff Moden (11/2/2010)
Grant Fritchey (11/2/2010)
For those who don't know, several of our locals are up for an award at SQLServerPedia for blog posts done over the last year. Gail is in three different categories and looks good to win two of them. I'm in two and actually possibly a contender in one. Please support us, or whoever you think is better, and go vote.
Thanks.
Grant... the link doesn't work. At least for me, it doesn't.
I think the server is down. I hope I don't have to go around begging for votes again. It's been enough of a pain in the bottom.
It's back up. I had a problem a little while ago, but it seems to have cleared up. Perhaps it was just overloaded by Threadizans going there to vote. 🙂

Nah. It appears from the comments here that I was the last one to use it.

So, either I broke it, or it considered my vote as the final decision. Guess my take on which just depends on how hungry my ego is. 🙂

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

SQLRNNR SSC Guru Points: 281334 More actions · Answer 13

GilaMonster (11/2/2010)
Grant Fritchey (11/2/2010)
For those who don't know, several of our locals are up for an award at SQLServerPedia for blog posts done over the last year. Gail is in three different categories and looks good to win two of them. I'm in two and actually possibly a contender in one. Please support us, or whoever you think is better, and go vote.
Big thank you to everyone here who has voted, I'm now second overall (for a little while anyway) :w00t: 😎 :w00t:

Hey - how about throwing some votes my way too!!!

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 14

Craig Farrell (11/2/2010)
Brandie Tarvin (11/2/2010)
GilaMonster (11/2/2010)
WayneS (11/2/2010)
Date field stored as varchar(8000) - what kinds of problems do you see coming up from this OP?
8000 characters for a date? I could store an entire calendar in there...
Done correctly, you could stick two calendars in there. Gregorian & Julian.
Nah nah, need nVARCHAR(4000), and put the Mayan one in there. 😛

Use Varchar(8000) for dates in the very distant future!!! 😛

Seriously now, why use varchar(8000) when you have Varchar(max)???? 😀

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]

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

Alvin Ramard (11/2/2010)
Craig Farrell (11/2/2010)
Brandie Tarvin (11/2/2010)
GilaMonster (11/2/2010)
WayneS (11/2/2010)
Date field stored as varchar(8000) - what kinds of problems do you see coming up from this OP?
8000 characters for a date? I could store an entire calendar in there...
Done correctly, you could stick two calendars in there. Gregorian & Julian.
Nah nah, need nVARCHAR(4000), and put the Mayan one in there. 😛
Use Varchar(8000) for dates in the very distant future!!! 😛
Seriously now, why use varchar(8000) when you have Varchar(max)???? 😀

Because Varchar(max) breaks xp_cmdshell and Varchar(8000) does not. : -)

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