Sunday, December 3, 2017

SQL Server - Database Architecture



  • Database is a place in the SQL Server where we store the data. It the collection of tables, views, stored procedures, users, roles etc
  • SQL server uses two types of files to store the database information. One or more database files and one or more transaction log files.
  • Database files : Primary data file with.mdf extension, secondary data file with .ndf extension and transaction log file with .ldf extension.
  • File Groups are used to logically group database files.  E.g Sales.ndf, Finance.ndf, HR.ndf   

                                                                                     
                                                       

3 comments:

  1. This website can live streaming , you can join at my site :
    agen judi online terpercaya
    Prediksi Bola

    Thank you
    agenpialaeropa.club
    gamesonline.ga
    beritasemasaterikini.net

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
  3. This is really likewise an incredibly beneficial placing most of us severely encountered shopping as a result of. It truly is faraway from each and every day we have now possibility to think about something. Design

    ReplyDelete