how can do you the system monitoring?
Where can you find the error log information? : sql server database administration
What are indexers?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
What is a view?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
Restore database SQL2000, SQL2012 Backup of base is created in Microsoft SQL Server 2000 - 8.00.2066, I can't restore on Microsoft SQL Server 2012 - 11.0.2100.60
What are the different types of join?
Can a database be shrunk with users active?
Explain what is the use of custom fields in report?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What is lock escalation?
How to know whether our backup is succesfully taken?