Where are my .NDF files located? I have created a sample database called TestDB. After that, I ran this select:

select * from sys.master_files


I found my .MDF, .LDF files from this select. Then I want to find out the .NDF file location . Is it possible to see those files like .NDF, .MDF , .LDF?
NDF is secondary data file, By default it will not be created unless we create the file while creating SQL server database or manually create it after database is created using AlTER DATABASE statement. SQL server by default will create one primary data file and one log file. If it is not visible in sys.master_files means you have not created it.

Read more about database files and filegroups

http://msdn.microsoft.com/en-us/library/ms189563.aspx

To add secondary data file please see

http://msdn.microsoft.com/en-us/library/ms189253.aspx