SQL Server for Oracle DBAs translates instance, database, schema, tablespace, undo, and redo without pretending the two architectures are identical.
CDC Cleanup and Capture Jobs: Keeping the Log and Change Tables Small
Keep CDC cleanup and capture jobs healthy by checking log reuse, job settings, retention, polling, and a stopped-job alert.
High-Frequency Inserts Without Blocking
High-frequency inserts can stall on the log, indexes, or last-page contention; learn to diagnose the wait and choose targeted SQL Server fixes.
Updating a Large Table in Batches With a Moving Key Range
Walk the clustered key a slice at a time, log each batch, and learn why stopping at the first empty batch quietly leaves rows behind.
Choosing Where to Put Data and Log Files
Choosing where data and log files live means checking storage behavior, capacity, install defaults, and a tested move procedure.
SQL SERVER – Solution – Log File Very Large – Log Full
Is your log file too big, or is the log full? Fix it in three steps: back up the log file, truncate it, then shrink it. I link my two detailed posts too.
SQL SERVER – Shrinking Truncate Log File – Log Full – Part 2
About a year ago, I wrote SQL SERVER – Shrinking Truncate Log File – Log Full. I was just going through some of the earlier posts and comments.