DATABASE FILES--MDF,LDF AND NDF IN SQL SERVER | How data is actually stored in sql server

[@rajbandaru618]

Thanks for this video, Excellent explanation.

[@LearnWithMRajput]

Glad to know that it is useful

[@Kingbezy]

Thanks for this! This video is GOLD🔥💯thank you!

[@rajkumars1204]

very informative video mam for the beginners

[@hrushikeshkhonde7079]

Nice explanation.... Thanks mam...

[@balajianjansai9622]

Best sql tutorials I have ever seen please man can you continue the same

[@LearnWithMRajput]

Sure

[@Deepak-kk3wz]

​@@LearnWithMRajputHi, I have one small but very complex query on SQL . Can you please help me Thanks.

[@rahulborate7034]

Big Thanks for your work.

[@GENADIKRASTEV]

Thank you for the great video Teacher

[@LearnWithMRajput]

Your welcome...keep watching

[@hayalgeta6024]

Thanks!!!! Awesome!!

[@BCTAHbKA]

Das ist das geilste Video ever

[@amangupta-ll3rs]

Thanks for the tutorial.

[@balaanji2877]

Excellent

[@amitbhardwaj8801]

Thank you ma'am

[@nandini5141]

Thanks a lot!

[@chiranjeevikatta8116]

clearly mention about .ndf files

[@ajitsaharan9445]

First of all thank u for these beautiful videos! I have one ques "How would .ndf file synchronize with mdf file?"

[@LearnWithMRajput]

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

[@phaneendrasubnivis607]

@@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

[@ashishdev7999]

Where is .ndf creation scenario, i was waiting for that scenario. How to add ndf and remove after use

[@bhavinmer1651]

Same here

[@SumantKumar-fn5td]

Good job mam..!!

[@LearnWithMRajput]

Thanks Sumant.

[@venkayyanaidu9227]

Hi Madam, Can you please give a query to create a new database with mdf, ldf, ndf file in different drives. Thanks You.

[@jingtingong6177]

Hi, how u change the * to all the column name in 14:28?

[@abhay6276]

but maam we store the data on server where lots of space is available we not store in our pc .

[@funmania5863]

Can ndf be created using same primary group ?

[@prakashboksham8673]

Super..

[@devanaidu9406]

Hello mam..can you please make a video on how to create and generate ER reports

[@foolchandsonariwal4203]

How we can create ndf file

[@tshiamobaepi7193]

Thanks very Much. How can i reduce data to free space on the disk?

[@thefilmythings]

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

[@dimpledivya2315]

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 .

[@balakrishnareddithala8718]

sql professor...

[@ranadheera7574]

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 ?.

[@LearnWithMRajput]

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.

[@LearnWithMRajput]

I hope i have satisfied your question.:)

[@dimpledivya2315]

How to send the image to you for clearly understand the problem....please please help me

[@LearnWithMRajput]

Hello Dimple, you can write your problem query with attachment to [e-mail].I would be happy to assist you further.

[@satyampalofficial]

Published Video Hindi

[@LearnWithMRajput]

Hi ..do you want me to publish vedios in hindi?

[@satyampalofficial]

Yes

[@LearnWithMRajput]

Ok sure

[@mabushuhada]

you waste huge time to deliver 1 minute message :(

[@lakhpatsingh300]

Time consuming video

[@amarcse06]

Please provide you r email id mam to contact for training..regarding index tunning

[@bhavinmer1651]

How to created .ndf files ?

[@LearnWithMRajput]

Usually .ndf got created automatically once the space allocated by .mdf file is fully occupied