The ORDER hint does not sort anything. It is a promise about your file, and SQL Server checks it. Here is what happens when you break it.
SQL SERVER – Could Not Register Service Principal Name Persists – Notes from the Field #105
Seeing ‘Could not register the Service Principal Name’ in your SQL Server log at startup? In Notes from the Field #105, Ryan Adams explains why and what to do.
SQL Server – T-SQL Enhancement “Drop if Exists” clause
Tired of IF OBJECT_ID checks before every DROP? SQL Server 2016 adds a T-SQL enhancement I wanted for years, the DROP IF EXISTS clause. Here is how it works.
SQL SERVER – New features in SQL Server 2016 Setup Wizard
Microsoft listened to feedback, and the SQL Server 2016 Setup Wizard shows it. Here are the new options I noticed, such as Perform Volume Maintenance Task.
Why datetime Turns .999 Milliseconds Into the Next Day
See why 999 milliseconds rounds into tomorrow with datetime, compare datetime2 precision, and use an exclusive next-day report boundary.
SQL SERVER – Installation Failed With Error – Wait on the Database Engine Recovery Handle Failed
I ran SQL Server setup on a domain controller by mistake, and the Installation Failed at ‘Wait on the Database Engine recovery handle’. Here is what fixed it.
SQL Server: What to Record Before Tuning a Slow Query
What to record before tuning a slow query starts with the original execution. Keep its SQL, inputs, connection settings, measurements, and plan together before testing a change.