What do you understand by mirroring and mention the advantages of the mirroring?
No Answer is Posted For this Question
Be the First to Post Answer
what are default? Is there a column to which a default cant be bound?
what is the difference between delete,drop and truncate
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
what information is maintained within the msdb database? : Sql server administration
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
What are the pros and cons of creating extended stored procedures?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
What is indexing a document?
Which table keeps the locking information?
How can we check the sql server version?
What is database black box testing?
How to create a user to access a database in ms sql server using "create user" statements?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)