Can you post execution plan (as a .sqlplan file) please?

How does the performance change when you use a temp table instead of the table variable?

I've got a pair of Bose QC15s (wired noise-cancelling). Fantastic headphones, but not cheap.

I would recommend spending a little extra on headphones, if you use them every day,...

9 year member of this site, 9 years of asking DBA questions, and can't write a differential backup script...

I saw a feature from Stream Analytics today that I would love to have in T-SQL

GROUP BY TransactionDate(Hour, 1)

Essentially group by one hour intervals of the...

It's a wait to acquire an Intent-Exclusive lock. Short duration waits are not a problem, and are expected. If you've got longer-duration waits, then you probably have some inefficient queries...

Try dropping the index you identified and recreating it (not rebuild. Drop and then create as two separate operations), then run checktable again and see if the errors are gone.

The linked servers will be fine. What will catch you is the cardinality estimator change that was made for SQL 2014. Most queries either stay the same or experience a...