what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
1139what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
1039what's the information that can be stored inside a bit column? : Sql server database administration
1035what is the different types of backups available in sql server? : Sql server database administration
931do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
989how do you test proper tcp/ip configuration windows machine? : Sql server database administration
1064but 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 is a database in ms sql server?
What is inner join? Explain with an example?
What does the not null constraint do?
What are various limitations of the views?
what is a traditional network library for sql servers? : Sql server database administration
What are the differences between union, intersect, and minus operators?
What stored procedure would you use to view lock information?
What are the types of normalization?
What is 2nf normalization form?
Do you know what is a linked server in sql server?
Can a unique index be created on a column, which contains null?
what is the system function to get the current user's user id? : Sql server database administration
between cast and convert which function would you prefer and why?
What is checkpoint process in the sql server?
Where in ms sql server is ’100’ equal to ‘0’?