okbangas (10/16/2012)
kapil190588 (10/15/2012)
As sql server version was not specified so I selected NoiseList but got wrong...I think version should be mentioned in question..
learn new thing today.......
If it were different in two supported editions of SQL Server, I agree. However, SQL Server 2005 is not supported anymore, so this question is correct for all supported editions of SQL Server.
When I saw the question and the list of answers, I *knew* there would be debate over this.
However, I agree with Okbangas - the question is fine without mentioning the version. And not just because SQL Server 2005 is out of date. I might have at least somewhat concurred with Kapil if that were the only argument. However, the "correct" answer for SQL Server 2005 and before was not included.
In SQL Server 2005, the words to be ignored were called "noise words". But lists of those words were not ever called "noise lists" - they were called "noise word files". So even those who have only experience with SQL Server 2005 and prior should have been able to realize that a name change had happened, and that they needed to do more research.
I think this was a great question, Steve! 🙂