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 5545Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?
5 15612What 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 14968
How many types of triggers are there?
Why truncate is ddl?
Will count(column) include columns with null values in its count?
How can you hide the sql server instances?
what is a self join? Explain it with an example? : Sql server database administration
Why use “nolock” in sql server?
What is report rendering ?
Why use cursor in sql server?
what authentication modes does sql server support? : Sql server database administration
What is the default value of an integer data type in sql server 2005?
Explain the microsoft sql server delete command? : SQL Server Architecture
How to convert character strings into numeric values?
What are the advantages of using third-party tools?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
Explain the dbcc pintable command when would you use it?