what is normalization? Explain different levels of normalization? : Sql server database administration
1241what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
1078what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
973what 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
894what are user defined datatypes and when you should go for them? : Sql server database administration
976what is the difference between delete table and truncate table commands? : Sql server database administration
985what is the information that can be stored inside a bit column? : Sql server database administration
920
What are the steps to follow to configure SQL*Net?
What are the main differences between #temp tables and @table variables and which one is preferred?
Why people hate cursor?
What are statistics?
Explain what are the different index configurations a table can have?
What are approximate numeric data types in ms sql server?
What is the order in which the sql query is executed?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
What is store procedure?
How do I setup a local sql server database?
How to add code to the existing article (using improve article)?
What is exporting and importing utility?
How to receive output values from stored procedures?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What are the instances when triggers are appropriate?