what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
1086what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
979what's the information that can be stored inside a bit column? : Sql server database administration
983what is the different types of backups available in sql server? : Sql server database administration
894do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
937how do you test proper tcp/ip configuration windows machine? : Sql server database administration
1012but 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
934
Can binary strings be used in arithmetical operations?
What is the difference between Normalization and De-normalization?
What are the restrictions that views have to follow?
Is sql server difficult to learn?
Which tcp/ip port does the sql server run on? How can it be changed?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
How to create percentile function?
What is 2nf example?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
What is the security principal at the database level that represents your session?
What is a transact-sql statement batch in ms sql server?
Explain the stored procedure?
What do you understand by hotfixes and patches in sql server?
Tell about MOM Tool(Microsoft Operator Manager)?
How to loop through the result set with @@fetch_status?