sql database suspect
We have a sql database that is showing as suspect. How can we recover?
What is split brain scenario in DB mirroring?
What is difference between table aliases and column aliases? Do they affect performance?
Mention the differences between sql server and mysql.
What are subqueries in sql server? Explain its properties.
What is a collation in ms sql server?
Can a synonym name of a table be used instead of a table name in a select statement?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
How to fetch the next row from a cursor with a "fetch" statement?
What is the purpose of the model database?
default databases available in sql server and there uses ?
What is the use of keyword with encryption.
what is a stored procedure and trigger?