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

2016-10-19T13:11:24+02:00Monday, 29 November, 2010|Categories: Featured, Technical|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 [...]