what is normalization? Explain different levels of normalization? : Sql server database administration
1327what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
1130what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
1034what 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
923what are user defined datatypes and when you should go for them? : Sql server database administration
1019what is the difference between delete table and truncate table commands? : Sql server database administration
1033what is the information that can be stored inside a bit column? : Sql server database administration
963
Do you know the different ddl commands in sql?
Can you please differentiate between a primary key and a unique key?
Explain indexes disadvantages?
What is a mutating table error and how can you get around it?
What is a view and what are its advantages?
What is a field name?
What is the Control Flow in SSIS
What is the difference between Normalization and De-normalization?
What are sql server functions?
What is a dataset and what are the different types of datasets?
Indexes are updated automatically is the full-text index also updated automatically?
What are indexers?
What are cascading parameters in ssrs reports?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
What’s the distinction between dropping a info and taking a info offline?