What is the status of services on passive node for failover cluster in sql server? : sql server database administration
1346What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
1038What is your recommendation for a query running very slow? : sql server database administration
1110What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
1199Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
1097Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
1000What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
1125
How to define output parameters in stored procedures?
How can you find out how many rows returned in a cursor?
Define constraints and give an example of their use?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
Explain about Views?
How do I know if localdb is running?
List the different index configurations possible for a table?
What xml support does the sql server extend?
How to create an inline table-valued function?
How to list all tables in the database using odbc_tables()?
How to use clusters?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
How to create sub reports?
What is cube dimension? : sql server analysis services, ssas
What extended events?