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...

There is nothing wrong with an employee deciding to move on another opportunity or an employer choosing to let someone go, so long as the motivation is rational and the...

When you're a one-man show, it's easy to have a myopic view of one's job, overestimating your skills and stagnating. We certainly learn more when we have good co-workers, particularly when...

That's the thing about attending .NET related developer conferences, when the topic of SQL coding comes up, we will often find ourselves shaking our head.

Abstracting the complexity of...