Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 18,241 through 18,255 (of 66,815 total)

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

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 1

WayneS (9/8/2010)
How about a table where the PK is on a text datatype? (as are most of the other columns also!)

After a day full of stupidity, I'm just about out of patience.... I think it's showing too.

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

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

GilaMonster (9/8/2010)
WayneS (9/8/2010)
How about a table where the PK is on a text datatype? (as are most of the other columns also!)
After a day full of stupidity, I'm just about out of patience.... I think it's showing too.

You may be running out of patience, but there's nothing wrong with the way you answered.

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]

Paul White SSC Guru Points: 150468 More actions · Answer 3

WayneS (9/8/2010)
How about a table where the PK is on a text datatype? (as are most of the other columns also!)

I would speculate that the OP there has a history using...argh...Access. Isn't 'text' the default string type there?

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

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

Paul White NZ (9/8/2010)
WayneS (9/8/2010)
How about a table where the PK is on a text datatype? (as are most of the other columns also!)
I would speculate that the OP there has a history using...argh...Access. Isn't 'text' the default string type there?

Hey Paul. Stop reading my mind! 😛

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]

SQLRNNR SSC Guru Points: 281344 More actions · Answer 5

Paul White NZ (9/8/2010)
WayneS (9/8/2010)
How about a table where the PK is on a text datatype? (as are most of the other columns also!)
I would speculate that the OP there has a history using...argh...Access. Isn't 'text' the default string type there?

I think so.

Just like the default datatype from the folks at MS for CRM is nvarchar()

Would you believe out of the box that MS CRM 4 has several different phone number fields. All of them are nvarchar data type and they are of varying length (one such was nvarchar(500) ). I am baffled as to the standards that are used in the product and that best practices are not followed. I can't fathom a 500 character unicode phone number.

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: 1004638 More actions · Answer 6

Steve Jones - Editor (9/8/2010)
I think more interesting is will The Thread beat me to 30k

I'm still trying to catch you as well. 😉

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

I'm not even going to try to keep up in the post war. I have too much work to do.

Hey, Steve, what kind of horses are those?

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.

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

Alvin Ramard (9/8/2010)
Paul White NZ (9/8/2010)
WayneS (9/8/2010)
How about a table where the PK is on a text datatype? (as are most of the other columns also!)
I would speculate that the OP there has a history using...argh...Access. Isn't 'text' the default string type there?
Hey Paul. Stop reading my mind! 😛

Oops, that is posted under MS Access.

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]

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 9

This is my post to whine that none of you have yet answered the post I put in in another forum.

Surely I should have my answer not 5 seconds after posting the question, yes? Isn't that the way these forums work?

@=) (running and hiding now.)

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.

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

CirquedeSQLeil (9/8/2010)
Paul White NZ (9/8/2010)
WayneS (9/8/2010)
How about a table where the PK is on a text datatype? (as are most of the other columns also!)
I would speculate that the OP there has a history using...argh...Access. Isn't 'text' the default string type there?
I think so.
Just like the default datatype from the folks at MS for CRM is nvarchar()
Would you believe out of the box that MS CRM 4 has several different phone number fields. All of them are nvarchar data type and they are of varying length (one such was nvarchar(500) ). I am baffled as to the standards that are used in the product and that best practices are not followed. I can't fathom a 500 character unicode phone number.

I'd believe it. A few years ago I helped a company evaluate several CRM products. Most seemed like several systems patched together without checking for coherance.

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

SQLRNNR SSC Guru Points: 281344 More actions · Answer 11

Stefan Krzywicki (9/8/2010)
CirquedeSQLeil (9/8/2010)
Paul White NZ (9/8/2010)
WayneS (9/8/2010)
How about a table where the PK is on a text datatype? (as are most of the other columns also!)
I would speculate that the OP there has a history using...argh...Access. Isn't 'text' the default string type there?
I think so.
Just like the default datatype from the folks at MS for CRM is nvarchar()
Would you believe out of the box that MS CRM 4 has several different phone number fields. All of them are nvarchar data type and they are of varying length (one such was nvarchar(500) ). I am baffled as to the standards that are used in the product and that best practices are not followed. I can't fathom a 500 character unicode phone number.
I'd believe it. A few years ago I helped a company evaluate several CRM products. Most seemed like several systems patched together without checking for coherance.

Without coherence is an understatement. I was going to write a blog on the top ten problems - but my list is well beyond that. I might be able to pare it down to top 25.

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 12

Brandie Tarvin (9/8/2010)
This is my post to whine that none of you have yet answered the post I put in in another forum.
Surely I should have my answer not 5 seconds after posting the question, yes? Isn't that the way these forums work?
@=) (running and hiding now.)

And which thread would that be?

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

CirquedeSQLeil (9/8/2010)
Stefan Krzywicki (9/8/2010)
CirquedeSQLeil (9/8/2010)
Paul White NZ (9/8/2010)
WayneS (9/8/2010)
How about a table where the PK is on a text datatype? (as are most of the other columns also!)
I would speculate that the OP there has a history using...argh...Access. Isn't 'text' the default string type there?
I think so.
Just like the default datatype from the folks at MS for CRM is nvarchar()
Would you believe out of the box that MS CRM 4 has several different phone number fields. All of them are nvarchar data type and they are of varying length (one such was nvarchar(500) ). I am baffled as to the standards that are used in the product and that best practices are not followed. I can't fathom a 500 character unicode phone number.
I'd believe it. A few years ago I helped a company evaluate several CRM products. Most seemed like several systems patched together without checking for coherance.
Without coherence is an understatement. I was going to write a blog on the top ten problems - but my list is well beyond that. I might be able to pare it down to top 25.

Sounds like you'll have to start with "I know I'm leaving a lot out, but" : -D

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

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 14

Lynn Pettis (9/8/2010)
Brandie Tarvin (9/8/2010)
This is my post to whine that none of you have yet answered the post I put in in another forum.
Surely I should have my answer not 5 seconds after posting the question, yes? Isn't that the way these forums work?
@=) (running and hiding now.)
And which thread would that be?

http://www.sqlservercentral.com/Forums/Topic982528-148-1.aspx if you want to take a look. Not quite my stupidest question. @=)

But really, I was just posting the whining post because I've seen it so often lately and this is a thread about awful posts. "Please, this is urgent. You should have answered my question before I posted it, darnit!"

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.

Paul White SSC Guru Points: 150468 More actions · Answer 15

Alvin Ramard (9/8/2010)
Oops, that is posted under MS Access.

So it is. I didn't even know there was such a forum.

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi