Category: Data Engine

Single-Row Deadlock

Introduction Demonstration of the smallest possible deadlock: only one statement, one table, one row. Without transactions (no BEGIN TRANSACTION). Even RCSI (Read Committed Snapshot Isolation) is turned ON to eliminate shared locks. Everything is “by the book” as Books Online

Tagged with: ,

Max Memory in SQL Server 2016 Standard Edition

What is the memory limit for Standard edition of SQL 2016? The answer you will most often get is 128 GB. But that answer is not correct, or very partially correct at best case. When you plan a new SQL

Table and Index Compression

Compression feature was reserved for Enterprise Edition of SQL Server. With SQL 2016 SP1 we get it in all editions, e.g. Standard Edition. But, it is not always easy to say will we benefit from compressing certain table/index/partition or not.

Top
Visit Us On TwitterVisit Us On FacebookVisit Us On LinkedinVisit Us On YoutubeVisit Us On Google PlusCheck Our Feed