Logging

Every database has a transaction log that records all transactions and the database modifications made by each transaction The transaction log is a critical component of the database. If there is a system failure, you will need that log to bring your database back to a consistent state. How that works? What steps SQL Server … Continue reading Logging

Wait wait wait…

Let's talk about why we have to wait and how to understand the wait types. Paul Randal in his post Wait statistics, or please tell me where it hurts said: A thread is using the CPU (called RUNNING) until it needs to wait for a resource. It then moves to an unordered list of threads … Continue reading Wait wait wait…