Describe triggers features and limitations?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
What is the osql utility?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
In which files does sql server actually store data?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
What is RAID? What are the different types of RAID configurations?
How to create an index on a view?
What is molap and its advantage? : sql server analysis services, ssas
Explain how to use linked server?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What are the five characteristics of good data?
Explain insert into select statement?
Do you have any idea about the tcl commands?
What is difference between view and materialized view?
