What is the use of builtinadministrators group in sql server? : sql server security
Explain optimistic and pessimistic concurrency?
what does the automatic recovery do? : Sql server administration
What is the distinction amongst delete and truncate?
What is the usage of the sign function?
Explain syntax for dropping triggers?
What are the operating modes in which database mirroring runs?
what changed between the previous version of sql server and the current version? : Sql server database administration
Explain what is lock escalation and what is its purpose?
Can binary strings be used in arithmetical operations?
what are isolation levels? : Sql server database administration
Which rendering formats are affected by the pagesize properties?
What is faster join or union?
What is clustered vs nonclustered index?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration