What is the purpose of the master database?

1115

How can you list all the columns in a database?

924

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

999

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1213

What are cursors and when they are useful?

1082

What are the advantages of user defined function?

980

What is named query? : sql server analysis services, ssas

958

What is the contrast amongst drop and truncate?

1032

What is catalog views?

1064

What is a cache in ssrs?

134

Find nth lowest salary or get nth lowest salary?

1020

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

938

Write a query for primary key constraint with identity key word?

1023

Explain rdbms?

1023

What is difference between rollback immediate and with no_wait during alter database?

1086