SQL Indexing and SQL Performance Part 1: SQL Storage and Indexing

2016-10-19T13:11:29+02:00Δευτέρα, 29 Νοεμβρίου, 2010|Categories: Προτεινόμενα, Τεχνικά|Tags: , , , , , , , |

Before we begin our journey in SQL Indexing it is important to understand how a SQL Server stores its data. Database FileGroups and Files A MS SQL database uses a .mdf file as the primary data file, a number of .ldf files as transaction logs, and optionally a number of .ndf files as secondary data files. These [...]