Are the posted questions getting worse?

Question

Post reply

Are the posted questions getting worse?

Viewing 15 posts - 11,266 through 11,280 (of 66,712 total)

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

J-F Bergeron SSCrazy Eights Points: 8593 More actions · Answer 1

Lynn Pettis (2/9/2010)
I guess it's time for me to start a personal black-list

Ehh, I wish I would've seen that comment before I posted the solution,

Why be so rude anyway, I mean, people are just trying to help!

Cheers,

J-F

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

J-F Bergeron (2/9/2010)
Why be so rude anyway, I mean, people are just trying to help!

Some are born that way, some are raised that way, others somehow get there own.

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 3

J-F Bergeron (2/9/2010)
Lynn Pettis (2/9/2010)
I guess it's time for me to start a personal black-list
Ehh, I wish I would've seen that comment before I posted the solution,
Why be so rude anyway, I mean, people are just trying to help!

Well, we could see what happens to his future requests for help if the "gurus" stay away. 😉

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

Lynn Pettis (2/9/2010)
J-F Bergeron (2/9/2010)
Lynn Pettis (2/9/2010)
I guess it's time for me to start a personal black-list
Ehh, I wish I would've seen that comment before I posted the solution,
Why be so rude anyway, I mean, people are just trying to help!
Well, we could see what happens to his future requests for help if the "gurus" stay away. 😉

It's too late now, we should have posted his answer behind the wood shed. :w00t:

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

J-F Bergeron (2/9/2010)
Lynn Pettis (2/9/2010)
I guess it's time for me to start a personal black-list
Ehh, I wish I would've seen that comment before I posted the solution,
Why be so rude anyway, I mean, people are just trying to help!

Unfortunately the solution only works in some of the databases. I was ready to post another reply to that thread when I tested it some more. I found a few databases that still show dtproperties and sysdiagrams.

Still looking for an alternative 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

J-F Bergeron SSCrazy Eights Points: 8593 More actions · Answer 6

CirquedeSQLeil (2/9/2010)
J-F Bergeron (2/9/2010)
Lynn Pettis (2/9/2010)
I guess it's time for me to start a personal black-list
Ehh, I wish I would've seen that comment before I posted the solution,
Why be so rude anyway, I mean, people are just trying to help!
Unfortunately the solution only works in some of the databases. I was ready to post another reply to that thread when I tested it some more. I found a few databases that still show dtproperties and sysdiagrams.
Still looking for an alternative answer.

Interesting, on 1 of my databases, the sysdiagrams is grouped under system databases, but the dtproperties is not... Seems even in the Studio there is a glitch...

Cheers,

J-F

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

Yes, this is a very interesting question.

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 8

Nothing says we can't continue to work on a better solution, especially if it may benefit others that may be more appreciative of our efforts and are more professional in their responses.

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

Lynn Pettis (2/9/2010)
Nothing says we can't continue to work on a better solution, especially if it may benefit others that may be more appreciative of our efforts and are more professional in their responses.

Stronger the Force will get, while the dark side is left to fend for itself.

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]

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

J-F Bergeron (2/9/2010)
Lynn Pettis (2/9/2010)
I guess it's time for me to start a personal black-list
Ehh, I wish I would've seen that comment before I posted the solution,
Why be so rude anyway, I mean, people are just trying to help!

Especially since I told him the same thing and didn't get insulted.

http://www.sqlservercentral.com/Forums/Topic862522-392-1.aspx

Should I feel insulted that I didn't get insulted? Perhaps instead of getting insulted I got ignored. :hehe:

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

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 11

Thanks for standing up for me 🙂 I appreciate it very much.

This is the first time I got insulted here. Feels kind of strange... But what ever.. I will try to help others when ever I can with the limited knowledge I have.

-Roy

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

I think the only method to exclude those two tables (sysdiagrams and dtproperties) is to hard code them into the query. Anybody else have any other ideas?

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

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 13

If you use is_ms_shipped = 0, does it not exclude those tables?

-Roy

SQLRNNR SSC Guru Points: 281334 More actions · Answer 14

Roy Ernest (2/9/2010)
If you use is_ms_shipped = 0, does it not exclude those tables?

Those two tables, no. They are tweener tables. They were technically shipped with SQL Server, but not truly activated until a user creates a diagram. They are considered User tables by MS.

Whether they show up in a database is also a bit inconsistent. I have them showing up in those queries whether I have a diagram or not, and sometimes they don't show up at all. In this scenario it has to do with the extended properties - but I see nothing that correlates.

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

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 15

Thanks for the update Jason. It works in all my Databases I have. In some database I dont even see those tables.

-Roy