How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
1194Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
1396
Write down the syntax and an example for create, rename and delete index?
Differentiate between a primary key and a unique key.
How do I clean up sql server transaction log?
What’s the distinction between dropping a info and taking a info offline?
what is the maximum size of a row? : Sql server database administration
Can you index views?
Explain alternate key, candidate key and composite key in sql server?
How are the unique and primary key constraints different?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
Do you know what are the steps to process a single select statement?
What is 2nf in normalization?
When does a workload on SQL Azure get throttled?
What is an identity column in insert statements?
Do you know how to store and query spatial data?
Explain what is the purpose of sql profiler in sql server?