when would you go for denormalization? : Sql server database administration
Explain what are page splits? : SQL Server Architecture
What is row by row processing ?
What is a transactions?
What is conditional split?
What is the purpose of sql profiler in sql server?
What is rank function?
How to delete database objects with "drop" statements in ms sql server?
What is blocking?
How to delete all rows with truncate table statement in ms sql server?
Explain few examples of RDBMS?
What is difference between process and thread? Explain lazy writer funcationality.
what command is used to create a table by copying the structure of another table?