When I search for C# or SQL in SO, it comes up with the newest C# or SQL questions. But when I search for something like 'SSIS', it comes up with relevance and displays both Questions and Answers, even though SSIS has a tag. This seems like inconsistent behavior. Do some tags have different search result behavior than others?
The top 40 tags only are auto-converted to tags, because people typing "C#" and hitting enter in the search box is a very common search, same for "Java", etc. There's also a little magic trying combos, e.g. "sql server" redirects to "sql-server" because the combined of hyphenated terms are a top tag. The other common case there was "vb .net", but it's generically supported.
We support this use case but not all the way down for all tags, because when you get to a term with a small tag set it's usually much more prevalent than the limited scope of posts actually dedicating a tag to it, it's commonly just a word in the post in those cases.