inevercheckthis2002 (8/24/2016)

---

GilaMonster (8/23/2016)

---

If they're getting denied access to just one table, then there's a object-level permission set on that table. Check the DMVs for the details, you can then use...

Yup. It's normal, expected, desired behaviour. You really don't want SQL fetching data from disk every time it needs to read a row...

So put the GROUP BY inside the subquery, not replacing the DISTINCT in the outer query? It's not clear from the post.

Which will behave exactly the same as the DISTINCT. Since he wants distinct values, DISTINCT...

The only time that a varchar/nvarchar column...

Best thing to do is identify the queries which are slower under the new CE and tweak them and/or indexes to improve the performance.

The legacy cardinality estimator option is the...

Clustered index, or nonclustered?

What's the complete table definition (post the CREATE TABLE) and index...

NVARCHAR(MAX) is a LOB....

Which, other than...

NVARCHAR(MAX) is a LOB. Any other NVARCHAR is not LOB.

If there's no explicit transaction, then any changes that have been made and commited are persistent, any uncommitted are rolled back when the deadlock victim is killed.

https://msdn.microsoft.com/en-us/library/ms176064.aspx

REPAIR_FAST

Maintains syntax for backward compatibility only....

Depends whether you want the index creation to use TempDB for sorting or not.

That option isn't persisted anywhere, it's effective only for the create/alter that it's specified on and no...

Rolled back to the beginning of the transaction. Hence if you have a procedure that does multiple data modifications without an explicit transaction, what had completed and committed is permanent...

Filestream isn't a datatype. It's an attribute of a varbinary data type column. Bigint is definitely not considered as large object, it's a grand total of 16 8-bytes in size.

Your...