/explore
|
You are here 
|
timilearning.com | ||
| | | | |
sookocheff.com
A central tenet of databases is that any committed data survives a crash or a failure. Write-ahead logging is a fundamental primitive that ensures all changes to data are first written safely to stable storage before being applied. Coupling that with some careful use of sequence numbers and we can guarantee that changes made to a database can survive system crashes. Motivation Let's start with a simple transaction T1 that reads object A, and updates the value for A with a write. To simplify matters, A is... |
|
| | | | | ||
| | | | |
www.red-gate.com
This article is an extract from the book Tribal SQL. In this article, Mark S. Rasmussen offers a concise introduction to the physical storage internals behind SQL Server databases. He doesn't dive into every detail, but provides a simple, clear picture of how SQL Server stores data. |
|
| | | | | ||
| | | | |
stribny.name
A list of things that we can do when we need to scale a SQL database. |
|
| | | | | ||
| | | | |
blogditifet.com
|
|
| | | |||
