MSSQL - How to force mssql to use a specific index for a query using an index hint
It is quite easy to give SQL a hint on which index to use for a query. I will however, start by warning you: this is »
MSSQL - Adding a column to a table without a default value or allowing null
If you are on this page you likely got an error similar to the following: Msg 4901, Level 16, State 1, Line 8 ALTER TABLE only »
MSSQL - Select statement slow on VARCHAR column with index
I recently had an odd experience with a select statement. It was a very simple select statement hitting a unique index on a varchar column. But »