How to run Script faster

[mcgheeiv]

Sorting in SQL is done with SQL ORDER BY not WHERE… My favorite SQL guru says that SQL Server is the second most expensive place to sort data:

How to Think Like the SQL Server Engine: Adding an ORDER BY - Brent Ozar...