The ambiguity of the ORDER BY in SQL Server

In today’s blog posting I want to talk about a very controversial and complex topic in SQL Server: the ambiguity of the ORDER BY clause. Views and ORDER BY Let’s start with a very simple SELECT statement. — A very simple SELECT statement SELECT * FROM Person.Person ORDER BY LastName GO As you can see …

The ambiguity of the ORDER BY in SQL Server + read more