New answers tagged


The SQL Server DB Storage Engine access the data on the hard drive the same way. It can be the exact same physical file. This is why although it's bad practice, you can have just 1 physical .mdf file and have all of your indexed, non indexed data on a clustered index, and heap in the same physical file. Of course performance and disk space usage will be ...

Top 50 recent answers are included