6

I answered this question using a method that looked ok and solved the user's problem. But later a more experienced user added a comment showing a method that is the solution "by design" and looks more professional. With his authorization I improved my answer with that method and removed mine (see edit 2 of the answer).

Knowing that new method made me feel like mine was more like a workaround, yet mine was the one used by the OP to solve his problem. I'm completely ok with removing my 2nd place method for the sake of brevity.

But that got me thinking: is the answer more valuable to the forum being brief and showing only a really professional method or being long and keeping alternative methods?

| |
  • 1
    Related: dba.meta.stackexchange.com/q/2516 – Paul White Oct 23 at 13:20
  • Thanks, @PaulWhite. Your comment and the answers I received were really helpful. I've decided to keep the question cited on the OP clean with only one method (reasons on Vérace's answer here). – Ronaldo Oct 24 at 11:41
3

As in so many things in life, it really depends on the question.

For some questions, there needs to be several methods of solving the problem since not everyone will have exactly the same problem, and each resolution might be uniquely helpful to them.

It's great to see that you incorporated the comments and suggestions into your answer, making it more useful for future visitors to the question.

| |
  • Thanks, Max Vernon =) I thought about it and I've made my mind (please, see my comment on Vérace's answer). Just in case my "2nd place" method is needed for some really specific case, I might leave it as a comment on my own answer so that it won't get lost. – Ronaldo Oct 24 at 11:36
3

I'd put a TL;DR header saying something like "The consensus appears to be method 1, but you can also use method(s) 2, (3,...) below the first one).

There may be edge cases for which the other methods work better - let the OP and any future visitors (who may have related, but not identical, problems) choose. The more complete an answer is, the better it makes the site (IMHO).

We're grown ups here and users can make decisions for themselves. Plus, alterrnative methods might give the OP further insight into their own issue.

p.s. welcome to meta and +1 for a thought provoking question!

| |
  • Thanks, Vérace =) I liked your approach and I'll certainly consider using it for other questions, but for the one mentioned on the OP I've decided to keep it clean as it is now and the reason is that the sys.sql_dependencies catalog view is available since SQL Server 2005, so I believe no one will have a problem using it and by doing it they'll improve their knowledge of system catalogs as I just did (and for DBAs that's really important). – Ronaldo Oct 24 at 11:30

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .