It is actively discouraged to put "keywords" in the title of a question, especially since Stack Exchange starting put the most popular tag in front of the title (which is done for SEO).
In other words:
SQL Server - How can I prevent injection when using sp_executesql?
Should simply be:
How can I prevent injecting when using sp_executesql?
In that example, it's already pretty clear that the question is about SQL Server. Sometimes, though, it isn't clear what the question is about without looking at the tags. I have cheated a few times and done something like:
How can I reverse an array in assembly?
Rather than:
How can I reverse an array?
Many people don't do this, and as a result, when asking questions:
The "Related Questions" are far less useful than they could be, which increases the likelihood of duplicate questions being asked.
If the tags were put above the body text, users would likely fill them out before starting to type the body text, and the "Related Questions" feature could use the tags along with the title to show higher quality potential duplicates.