What is the difference between Normalization and De-normalization?

1029

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1053

Does index slows down insert statements?

936

Where in ms sql server is ’100’ equal to ‘0’?

1017

Tell me the use of keyword with encryption. Create a store procedure with encryption?

961

Write the queries for commands like Create Table, Delete table, Drop Table etc.

1031

What happens if you add a new index to large table?

881

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

959

Explain transaction server auto commit?

988

What is table constraint?

928

What is standby servers? Explain types of standby servers.

930

What is Cross Join and in which scenario do we use Cross Join?

973

What do you mean by tablesample?

1031

When a primary key constraint is included in a table, what other constraints does this imply?

938

Explain about nested stored procedure?

975