database – Page 3 – SQL Padawan

Simple way to understand transaction isolation levels

I was talking with a friend about how a database works and she asked me to explain transaction isolation levels

In a previous post I talked about transaction log works, and what about using a memory-optimized table? SQL Server has

Checkpoints flush dirty data pages from the buffer cache of the current database to disk. This minimizes the active portion

To see how many VLFs you have solely look at the number of rows returned by DBCC LOGINFO. The size

Doing crash and recovery tests on my local machine I got the SQL Server instance not going online. After trying

Every database has a transaction log that records all transactions and the database modifications made by each transaction The transaction

Let’s talk about why we have to wait and how to understand the wait types. Paul Randal in his post

Great news, a visual way to manage SQL Server from Linux. SQL Operations Studio came to fill a gap we

Update data in SQL Server is a simple task. Using the command update table set column = value where column

SQL Server has many undocumented functions and commands. I will write series of posts with functions to have a library online.