• It's just a way to differentiate between primary and secondary data files.If we keep all the data file extension same then others might confuse between primary and secondary data file.

    Primary data file contains some metadata about secondary files.

    Although we can keep the extension whatever we like .x,.y etc.

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014

    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/