There are 5 type of Isolation levels available in SQL Server – Read Uncommitted: A transaction can read the data…
What are the different database state? Explain all.
There are 5 different database state are there, they are – Online: Available for all users. Offline: Unavailable. Restoring: Unavailable…
What will happen if model database get corrupted ?
If model database gets corrupted, then SQL server services not started because whenever SQL server is started tempdb is created…
How to attach a database.
T-SQL USE [master] GO CREATE DATABASE [AdventureWorks2008] ON ( FILENAME = N’D:\AdventureWorks2008_Database\AdventureWorks2008_Data.mdf’ ), ( FILENAME = N’D:\AdventureWorks2008_Database\AdventureWorks2008_Log.ldf’ ) FOR ATTACH…
Your database log drive got full. how you will recover it.
First we have to run “dbcc sqlperf(logspace)” from there we get “Log Size” and “Log Space Used“. If log size…
What is the purpose of DCM & BCM page ?
DCM : Differential Changed Map pages track the extents modified after the full backup. DCM has a bit for every extent…
Database is in suspect mode, how you recover?
Change the status of your database in “EMERGENCY” mode. (i.e. ALTER DATABASE Database Name SET EMERGENCY;) Check for any of…
Difference between re-build and reorganization with query syntax.
SQL,SQL SERVER,SQL DATABASE,Microsoft SQL Server,Database,Database Administrator While index reorganization is a pure cleanup operation which leaves system state as it…
What is the Pre-requisite of mirroring ?
The principal server and mirror server, must be running the same edition of SQL Server. The witness server (if any)…
List of Some SQL CMD Arguments with Description
-s instance_nameSpecifies the instance of SQL Server you want to connect. If no named instance is specified, sql server starts…