what is difference between NULL and ISNULL in SQL Server 2008?
Can you please differentiate between a primary key and a unique key?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?
What are the recovery models for a database?
How to a Query to copy data from on table to another table.
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
What are the differences between having and where clause.
What is a Linked Server?
What is lock escalation? : sql server database administration
Which Model uses the SET concept
What is a hint?
What are the factors you will check for the performane optimization for a database query?
7 Answers CarrizalSoft Technologies, DELL, SoftSol,