Define outer join in sql server joins?
Mention the different types of replication in sql server.
What are the new data types are introduced in sql 2000?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
Can you use order by when defining a view?
Can I delete event logs?
What is pivot and unpivot?
What is difference between stored procedure and function?
what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?
how to create a scrollable cursor with the scroll option? : Sql server database administration
Can anyone explain difference between Database, Data warehouse and Data mart with some example?````
If we shrink the Databse and Files, how much size is decreased?
What is the difference between HAVING clause and the WHERE clause?