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 6368Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?
5 17389What 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 16151
Do you know what is a linked server in sql server?
What is the difference between primary key and unique constraints?
What do you understand by a view? What does the with check option clause for a view do?
How to use clusters?
What’s the distinction between dropping a info and taking a info offline?
What is replace and stuff function in sql server?
What happens if ntwdblib.dll is missing on your machine?
What is the difference between locking and multi-versioning?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
What is snapshot replication?
What is difference between inner join and full join?
What are a database and a data warehouse?
What is etl - extraction, transformation, and loading?
When do you think a developer should use sql server-based cursors?
Ms sql server index?