Have you ever thought about how SQL Server stores data in its data files? In this tip I will show how pages are allocated to data files and what happens when there are multiple data files for a SQL Server database.
