What are the different types of indexes?

1165

Explain trigger classes i.e. Instead of and after trigger?

921

What will be the maximum number of indexes per table?

1021

Why should you use or avoid select * statements?

1080

How to replace the Query Result 'Null Value' with a text ?

1101

How to maintain a fill factor in existing indexes?

1060

Which autogrowth database setting is good?

1097

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

1030

ow to bring suspect mode datbase online from scratch

1861

How to use subqueries with the in operators in ms sql server?

1132

How to make a remote connection in a database?

1023

Differentiate between sql temp table vs table variable?

929

What do you mean by sql server agent?

1043

What are window functions in sql server?

1070

What happens to a statement batch if there is a compilation error?

1015