SQL Server Interview Questions SQL Terminologies

SQL Server DBA Interview Questions and Answers-Data File and Transaction Log File Architecture

This Blog illustrates about the most frequent questions which are asked about the Data file and Transaction Log file architecture. Intentionally I did not add any troubleshooting questionnaire in this
Indexes Scripts SQL Server

How to move Indexes (Cluster and Non Cluster) from Primary File group to New File group?

As a DBA, many times there are requirements to segregate data in a Database into multiple file groups. There can be many reasons like below: Performance issues (Disk I\O) Disk
Indexes Scripts SQL Server

How to create Drop and Recreate Script of all Indexes in a database?

It’s a general requirement in the DBA job to scripts out the database objects and deployment the scripts in the new environment. Microsoft SQL Server provides us an option to
Cloud Computing Technology

Cloud Computing and top service providers

Technologically the IT industry has evolved at a rapid rate with new and innovative ideas entered into the industry. The amount of data that has grown over time among industry
  • BY
  • March 4, 2016
  • 0 Comments
SQL Server Database Objects Interview Question Interview Questions SQL Terminologies

SQL DBA Interview Questions and Answers-Database Architecture and Database Properties

This article comprises of SQL Server Questions and answers series on Database Architecture and various Database Properties. Intentionally I skipped Database Recovery Models, Backups, Restore, Data File and Transaction Log

On Instagram

DBAMantra.com

@DbaMantra
Follow Us