...Apparently this was an error in how the navigation and steering controls were configured. You can read about this over at Ars Technicaread about this over at Ars Technica,...

If you don't know T-SQL; meaning if you can't write your own T-SQL scripts to automate things, or analyze execution plans and advise developers on proper T-SQL coding and data...

This year was my first time attending PASS. Most of the sessions I attended focused on ColumnStore, which is something our organization has implemented in production over the past couple...

An email or MP3 may have a header and other structured meta-data, but the contents typically follow no formal EDI structure. Even the contents may not conform to proper grammatical...

It's expensive, risky, and unproductive for companies to continually lose and replace experienced staff. Smart companies understand that smart employees need variety and challenge, and they provide opportunities for staff...

I don't have a problem with index hints, even in production, so long as it's presumptive need is evidence based. Hints are declarative, and although the guy taking over your...

What a joke. We seriously need to reform the way government at all levels does procurement and hires contractors.

... The system, the Property and Evidence Tracking System...

What are their arguments for embedding the SQL in the application? Even if there were some marginal technical advantage, there is still issue that ownership of the SQL would then...

... It is great that you can fix a problem at your kid's soccer game or dance recital, but it's also important that you attend and enjoy those...

You might achieve what you're wanting to do using hints. FORCESCAN forces scan on index instead of seek, INDEX(1) forces use of clustered index, and INDEX(0) forces a table scan.

Ordinarily the plebeians would be demanding their elected leaders "DO SOMETHING ABOUT THIS !!!".

However, under the present circumstances they're just praying the crisis will blow over without...