Paul White (@SQL_Kiwi) follows up a great post on calculating medians with some information on how locking can affect query performance, often undetected.
We have launched a new, bi-weekly newsletter to offer you the freshest content from our blogs and beyond. Subscribe at: https://sentryone.com/community.
Paul White (@SQL_Kiwi) demonstrates another case where a cursor might be the most efficient approach to solving a typically set-based problem: medians.
Aaron Bertrand (@AaronBertrand) takes a quick look at a couple of things you should be careful about when calling natively-compiled Hekaton stored procedures in SQL Server 2014.
Paul White (@SQL_Kiwi) concludes his two-part series on SQL Server sort internals, including two new classes specific to In-Memory OLTP in SQL Server 2014.
Paul White (@SQL_Kiwi) rolls up his sleeves in his usual way, showing off the debugger several times while explaining the internals of SQL Server sorts.
With detailed information and his uncanny knack for explaining technical concepts very well, Paul White (@SQL_Kiwi) concludes his series on ACID, transactions, and isolation levels in SQL Server with a great read on READ UNCOMMITTED.
