what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
1137what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
1035what's the information that can be stored inside a bit column? : Sql server database administration
1033what is the different types of backups available in sql server? : Sql server database administration
928do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
988how do you test proper tcp/ip configuration windows machine? : Sql server database administration
1061but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
967
What are cursors stored procedures and triggers?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
Do you know what is normalization of database? What are its benefits?
What is spid in sql server profiler?
What is difference between inner join and join?
What is normalization? Explain different forms of normalization?
What are the different normalization forms?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What are the difference between primary keys and foreign keys?
How do you create a clustered index?
Explain about system stored procedure?
Define normalisation?
What is mapping schema?
What number sorts of privileges are accessible in sql?
How to defragment table indexes?