What are the three types of Database files? Explain them

What are the three types of Database files? Explain them.

Types of database files:
- Data file: This stores all the data. It has an extension .mdf
- Log file: This stores all the transaction log information. It has an extension .ldf
- Additional data files: Any additional data is stored in these files. It has an extension .ndf

What are the three types of Database files? Explain them.

Database files are used for mapping the database over some operating system files. Data and log information are separate.

SQL server database has three types of database files:
Primary: starting point of a database. It also points to other files in database. Extension: .mdf
Secondary: All data files except primary data file is a part of secondary files. Extension: .ndf
Log files: All log information used to recover database. Extension: .ldf

User defined data type concepts, syntax and an example
User defined data types are most commonly used when consistency among several tables storing the same type of data is desired........
Concepts behind placing indexes with filegroups
Indexes can be placed on different file groups to increase performance. By default, indexes are created on the same file group as the base table........
Explain how to make views updatable in SQL Server 2000
INSTEAD OF Triggers: Cause the trigger to fire instead of executing the triggering event or action. It prevents unnecessary changes to be made.......
Post your comment