How to set the default transaction isolation level server wide?

Last week I was involved in a discussion about the default transaction isolation level used by the transaction objects in WCF’s services (Serializable) versus the one used by the transaction objects in Entity Framework for SQL Server (ReadCommitted) whose details I’m not going to cover in this post.   At a given point during that…

0

DBCC DBRECOVER finally removed from SQL Server

For those of you who relied on that command, typically used in data recovery learning labs, just wanted to warn you, if you haven’t noticed already, that it has been removed from the product starting with SQL Server 2012 RTM. The supported way to do what that undocumented DBCC command did would be using ALTER…

3

How the query execution engine calculates the threshold it uses to detect inaccurate cardinality estimation and fire the inaccurate_cardinality_estimate extended event?

Starting with SQL Server 2012, the query engine folks introduced an extended event, inaccurate_cardinality_estimate, you can use to identify those running queries for which any of its iterators outputs significantly more rows than those estimated by the Query Optimizer. To be more precise, it is not the case with ANY iterator. This diagnosing functionality will…

3