Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?
1 6258Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?
5 17208What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?
2 16013
what are isolation levels? : Sql server database administration
Do you know what is normalization of database? What are its benefits?
What is a file group?
What is Service Broker in sql server 2012?
Can group functions be mixed with non-group selection fields in ms sql server?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
What are tables in sql server?
What do you mean by acid?
Do you know what is sql injection?
What are the different types of collation sensitivity?
What is page in sql server?
How to create a view on an existing table in ms sql server?
What is use of except clause?
What are the reporting services components?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?