What is log cache in sql server?
Define msdb database?
Define right outer join?
What is nested transaction?
What are the differences between clustered and non-clustered index?
What is page-level compression?
When cursors are useful?
Explain about extended stored procedure?
Explain what is “asynchronous” communication in sql server service broker?
Define inner join in sql server joins?
What is row-level compre?
Explain about nested stored procedure?
Define left outer join in sql server joins?
Can we create clustered index on composite key?
Explain important index characteristics?