how many clustered indexes can be created on a table? : Sql server database administration

1152

Explain the cursor lock types?

1053

What is an sql server agent?

1063

what are the three command line utilities and what are their primary functions?

144

What are the export options of ssrs?

173

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1054

Explain what is meant by replication of database?

1031

What is dirty page?

973

Why is normalisation important?

942

Your table has a large character field there are queries that use this field in their search clause what should you do?

884

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

967

Is natural join and equi join same?

971

What are the differences between stored procedure and view in sql server?

1248

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

948

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

980