SQL Server According to Bob

JANUARY 11, 2020

KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? KB boundary   12 Larger transaction logs   13 Restore and attach   14 Format for 4 ?KB

Servers 40

Servers Cache Database Media 40

SQL Server According to Bob

DECEMBER 18, 2018

Durability: “In database systems , durability is the ACID property which guarantees transactions that have committed will survive permanently. For example, if a flight booking reports that a seat has successfully been booked, then the seat will remain booked even if the system crashes.” – [link]. The Back Story.

Servers 90

Servers Media Cache Storage 90

SQL Performance

MARCH 30, 2021

It includes initializing each operator, and adding hidden profilers to collect runtime performance data like actual row count and elapsed time. I used the public Stack Overflow 2013 database ( download details ). See Myth: SQL Server Caches a Serial Plan with every Parallel Plan for details. MonthlyPosts AS. ( ( SELECT.

Cache 98

Cache Servers Operating System Processing 98