What is normalization 1nf 2nf 3nf?
How to write a query with a full outer join in ms sql server?
Difference between primary key and clustered index?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
Where actually sql azure database is hosted?
Explain the difference between control flow and data flow?
What are scalar functions?
Is t sql the same as sql server?
What method is used by the Command classes to execute SQL statements that return single values?
What are the different types of replication you can set up in sql server?
Explain tablesample?
How can change procedure in sql server?
You want to implement the many-to-many relationship while designing tables. How would you do it?
What is difference between aggregate and analytic function?
How do I perform an unattended install of sql server 2000?