Category: Data Engine

Introduction Docker is perfect for launching DEV and TEST SQL Server environments, when you need many independent SQL instances, or ability to run and stop instances in seconds, only when you need them. Launched from one common image (1GB in …

SQL Server 2017 and 2019 on Docker inside Synology DS918+ Read More »

Tagged with: , , ,

Do you use ROWVERSION/TIMESTAMP to pull changed data? If you do, you might experience a problem – not all changed rows are pulled, some are skipped. How can that be, if we pulled entire range of rowverion changes with no …

ROWVERSION/TIMESTAMP skipping rows problem Read More »

Tagged with: , , , ,

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 …

Single-Row Deadlock Read More »

Tagged with: ,

We are always thinking about you, sometimes even on vacation! Here is a quick hello video from the island of Brac:

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 …

Max Memory in SQL Server 2016 Standard Edition Read More »

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. …

Table and Index Compression Read More »

Checkpoint and Lazy Writer are somewhat similar: they both write pages from buffer pool memory to the disk. So, what is the difference?

Are you still using READ COMMITTED transaction isolation level? Default transaction isolation level on all SQL Server versions (2000-2014) has serious inconsistency problems, by design. Not many people are familiar how and why is it happening. I am writing this …

READ COMMITTED sucks! Read More »

Visit Us On TwitterVisit Us On FacebookCheck Our FeedVisit Us On LinkedinVisit Us On Youtube