Both MDF and ndf files are data storage files .....once the primary file mdf got completely filled up as per the space allocated to it....sql server starts storing data in secondary files ...ndf
@@LearnWithMRajput this need not be always true. Intentionally we can have tables getting stored in secondary files. We get the benefit if the main and secondary files are stored in different physical drives and hardware is capable of reading data from different physical drives in parallel
mam i am begainer , after new data base name , in my device only show my file name in c drive not shown mdf and ldf , only shown my file name . why? plz help me
Mam I have a problem In sql server DATA folder in DATA Folder the files are not shows like as your folder they shows In other format. So please help me mam .
You said when c drive full .ndf file will create. You didn’t show it by creating. Will it create by auto once c drive full?. Once .ndf file create .mdf file go away?. Or .ndf file replaces the .mdf file?. .ndf takes less space of c drive the .mdf file?. What is the use of .ndf ?.
Dear Rana,.. 1)first of all...ndf file is not created automatically..it is user defined secondary file. ...2) When your primary file .MDF reached its maximum size, (say you have given 3gb to MDF file while creating database), then to store data we need additional files other than primary file which already got filled ..in that case you need to create ndf file. 3) No, .mdf will not go away 4) No , like I said .ndf file not replaced .mdf file...it's like when .mdf file is no longer to hold data...then .ndf file holds remaining data.4)by default, database files got created on C drive, you can create .ndf files on other drives like E,D drive.
Thanks for this video, Excellent explanation.
Glad to know that it is useful
very informative video mam for the beginners
Nice explanation.... Thanks mam...
Das ist das geilste Video ever
Thanks for this! This video is GOLD🔥💯thank you!
Thank you for the great video Teacher
Your welcome...keep watching
Best sql tutorials I have ever seen please man can you continue the same
Sure
@@LearnWithMRajputHi, I have one small but very complex query on SQL . Can you please help me
Thanks.
sql professor...
Thanks!!!! Awesome!!
Excellent
Big Thanks for your work.
Thank you ma'am
Thanks for the tutorial.
clearly mention about .ndf files
Can ndf be created using same primary group ?
Super..
Good job mam..!!
Thanks Sumant.
Thanks a lot!
Thanks very Much. How can i reduce data to free space on the disk?
Hi Madam, Can you please give a query to create a new database with mdf, ldf, ndf file in different drives. Thanks You.
Hello mam..can you please make a video on how to create and generate ER reports
but maam we store the data on server where lots of space is available we not store in our pc .
First of all thank u for these beautiful videos! I have one ques "How would .ndf file synchronize with mdf file?"
Both MDF and ndf files are data storage files .....once the primary file mdf got completely filled up as per the space allocated to it....sql server starts storing data in secondary files ...ndf
@@LearnWithMRajput this need not be always true. Intentionally we can have tables getting stored in secondary files. We get the benefit if the main and secondary files are stored in different physical drives and hardware is capable of reading data from different physical drives in parallel
How we can create ndf file
Where is .ndf creation scenario, i was waiting for that scenario.
How to add ndf and remove after use
Same here
mam i am begainer , after new data base name , in my device only show my file name in c drive not shown mdf and ldf , only shown my file name . why? plz help me
Hi, how u change the * to all the column name in 14:28?
Mam I have a problem In sql server DATA folder in DATA Folder the files are not shows like as your folder they shows In other format. So please help me mam .
You said when c drive full .ndf file will create. You didn’t show it by creating. Will it create by auto once c drive full?. Once .ndf file create .mdf file go away?. Or .ndf file replaces the .mdf file?. .ndf takes less space of c drive the .mdf file?. What is the use of .ndf ?.
Dear Rana,.. 1)first of all...ndf file is not created automatically..it is user defined secondary file. ...2) When your primary file .MDF reached its maximum size, (say you have given 3gb to MDF file while creating database), then to store data we need additional files other than primary file which already got filled ..in that case you need to create ndf file. 3) No, .mdf will not go away 4) No , like I said .ndf file not replaced .mdf file...it's like when .mdf file is no longer to hold data...then .ndf file holds remaining data.4)by default, database files got created on C drive, you can create .ndf files on other drives like E,D drive.
I hope i have satisfied your question.:)
How to send the image to you for clearly understand the problem....please please help me
Hello Dimple, you can write your problem query with attachment to sqltrainingsession@gmail.com.I would be happy to assist you further.
Published Video Hindi
Hi ..do you want me to publish vedios in hindi?
Yes
Ok sure
you waste huge time to deliver 1 minute message :(
Time consuming video
Please provide you r email id mam to contact for training..regarding index tunning
How to created .ndf files ?
Usually .ndf got created automatically once the space allocated by .mdf file is fully occupied