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

Поділитися
Вставка
  • Опубліковано 5 січ 2025

КОМЕНТАРІ • 50

  • @Kingbezy
    @Kingbezy 2 роки тому +2

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

  • @rajbandaru618
    @rajbandaru618 Рік тому +1

    Thanks for this video, Excellent explanation.

  • @rajkumars1204
    @rajkumars1204 2 роки тому +1

    very informative video mam for the beginners

  • @hrushikeshkhonde7079
    @hrushikeshkhonde7079 5 місяців тому

    Nice explanation.... Thanks mam...

  • @rahulborate7034
    @rahulborate7034 5 років тому +1

    Big Thanks for your work.

  • @BCTAHbKA
    @BCTAHbKA 3 роки тому +1

    Das ist das geilste Video ever

  • @abhay6276
    @abhay6276 2 роки тому +1

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

  • @balajianjansai9622
    @balajianjansai9622 3 роки тому +1

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

    • @LearnWithMRajput
      @LearnWithMRajput  3 роки тому

      Sure

    • @Deepak-kk3wz
      @Deepak-kk3wz Рік тому

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

  • @balaanji2877
    @balaanji2877 5 років тому +1

    Excellent

  • @hayalgeta6024
    @hayalgeta6024 3 роки тому +1

    Thanks!!!! Awesome!!

  • @GENADIKRASTEV
    @GENADIKRASTEV Рік тому

    Thank you for the great video Teacher

  • @amangupta-ll3rs
    @amangupta-ll3rs 5 років тому +1

    Thanks for the tutorial.

  • @jingtingong6177
    @jingtingong6177 3 роки тому

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

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

  • @funmania5863
    @funmania5863 2 місяці тому

    Can ndf be created using same primary group ?

  • @prakashboksham8673
    @prakashboksham8673 4 роки тому

    Super..

  • @amitbhardwaj8801
    @amitbhardwaj8801 4 роки тому +1

    Thank you ma'am

  • @nandini5141
    @nandini5141 5 років тому +1

    Thanks a lot!

  • @SumantKumar-fn5td
    @SumantKumar-fn5td 5 років тому +1

    Good job mam..!!

  • @dimpledivya2315
    @dimpledivya2315 5 років тому

    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 .

  • @foolchandsonariwal4203
    @foolchandsonariwal4203 3 роки тому +1

    How we can create ndf file

  • @venkayyanaidu9227
    @venkayyanaidu9227 4 роки тому +1

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

  • @ashishdev7999
    @ashishdev7999 5 років тому +2

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

  • @ajitsaharan9445
    @ajitsaharan9445 4 роки тому +1

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

    • @LearnWithMRajput
      @LearnWithMRajput  4 роки тому +1

      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
      @phaneendrasubnivis607 3 роки тому

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

  • @ranadheera7574
    @ranadheera7574 5 років тому

    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
      @LearnWithMRajput  5 років тому +3

      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
      @LearnWithMRajput  5 років тому

      I hope i have satisfied your question.:)

  • @devanaidu9406
    @devanaidu9406 4 роки тому

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

  • @chiranjeevikatta8116
    @chiranjeevikatta8116 5 років тому +1

    clearly mention about .ndf files

  • @balakrishnareddithala8718
    @balakrishnareddithala8718 11 місяців тому

    sql professor...

  • @tshiamobaepi7193
    @tshiamobaepi7193 3 роки тому

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

  • @dimpledivya2315
    @dimpledivya2315 5 років тому

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

    • @LearnWithMRajput
      @LearnWithMRajput  5 років тому +1

      Hello Dimple, you can write your problem query with attachment to sqltrainingsession@gmail.com.I would be happy to assist you further.

  • @satyampalofficial
    @satyampalofficial 5 років тому

    Published Video Hindi

  • @mabushuhada
    @mabushuhada Рік тому

    you waste huge time to deliver 1 minute message :(

  • @lakhpatsingh300
    @lakhpatsingh300 2 роки тому

    Time consuming video

  • @amarcse06
    @amarcse06 Рік тому

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

  • @bhavinmer1651
    @bhavinmer1651 Рік тому

    How to created .ndf files ?

    • @LearnWithMRajput
      @LearnWithMRajput  Рік тому

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