If a question has been tagged with sqlserver-2008, should it also be tagged with sqlserver?
If a question has been tagged with sqlserver and references a feature only present in SQL Server 2008, should it also be tagged with sqlserver-2008?
Generally if I have an SQL Sever question, I will only tag it with the specific year if it is an absolute requirement and generally I will include both "sql-server" and "sql-server-[year]".
It is also possible that users can set up an interesting tag for "sql-server~" that will allow for them to see any tag that starts with "sql-server".
Like many other users, I watch lots of different tags; sqlserver, sql-server, ms-sql, etc. This isn't a good solution, but is a result of letting users create their own tags, and isn't really that much overhead.
On the other hand, when asking questions, I'd stick to one tag rather than using multiple (redundant) tags: sqlserver if the question is common to many versions, or sqlserver-2008 if it references some feature specific to that version.
This saves polluting the tag-space, frees up some tags for moderators and future editors, and avoids annoying people who have no interest in SQL Server 2005 if that's what my question relates to :)
Until we had the search functionality using ~ as a wildcard (server side * that is, such that [sql-server~] finds all tags including the year, see here), I would have voted to use both the generic and the specific tag.
But now, I can use [sql-server*] on my preferred tags and [sql-server~] when searching for questions I would like to offer answers to. So I now adopt using the generic tag unless the question is version specific.
I was originally going to post that I liked having multiple tags such as sql-server and sql-server-2008 because I then have the flexibility to search all sql server questions OR sql server 2008 questions.
Then I discovered that you could put a "~" in the URL for a wild card and I changed my mind. Now I think you should just put in the sql-server-2008 and let me put in the "~" on my own.
Just my 2 cents :)