The transaction log records every change before it reaches the data file. Why it grows, what log_reuse_wait_desc is telling you, how the recovery model decides everything, and the one fair reason to shrink it.
SQL SERVER – Introduction to JOINs – Basic of JOINs
A simple introduction to JOINs: INNER JOIN and the three OUTER JOIN types, written for members of the Gandhinagar SQL Server User Group who asked for it.
SQL SERVER – Restore or Attach Database Without .NDF or .MDF is Not Possible
Can you restore or attach database files if the .mdf or an .ndf file is missing? In one word, no. Here is why every data file is needed.
Reading the SQL Server Support Lifecycle
Read the SQL Server support lifecycle for your exact release, distinguish mainstream and extended support, and plan before coverage ends.
SQL SERVER – Logical Query Processing Phases – Order of Statement Execution
Logical Query Processing is the order in which SQL Server handles each clause of a statement, with FROM and ON first and SELECT near the end. Here are the phases.
SQLAuthority News – Launch of Gandhinagar SQL Server User Group
The launch of Gandhinagar SQL Server User Group on March 27, 2009 drew over 50 database enthusiasts, and we even ran out of chairs. Register at the portal.
What Is a Database Backup? Full, Differential, Log
A database backup comes in three kinds and they work together. Measured sizes for full, differential and log, why the recovery model decides everything, and the restore order that cannot be improvised.