what is normalization? Explain different levels of normalization? : Sql server database administration
1411what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
1175what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
1113what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
973what are user defined datatypes and when you should go for them? : Sql server database administration
1065what is the difference between delete table and truncate table commands? : Sql server database administration
1081what is the information that can be stored inside a bit column? : Sql server database administration
1010
How can you check the level of fragmentation on a table?
What do you understand by coalesce in sql server?
What is difference between index seek vs. Index scan?
explain what is raid and what are different types of raid configurations? : Sql server database administration
Explain what are partitioned views and distributed partitioned views?
Can you name a few encryption mechanisms in sql server?
When is the use of update_statistics command?
How does recursive cte works in sql server?
What is indexing a document?
what is a self join? Explain it with an example? : Sql server database administration
Do you know what is user defined datatypes and when you should go for them?
Explain what is lock escalation and what is its purpose?
What do you mean by stored techniques? How would we use it?
What is dynamic cursor in SQL SERVER?
Where is trigger in sql server?