Why we use functions in sql server?
How can you list all the columns in a database?
What are system databases into sql server (2005/2008) : sql server database administration
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
How to Debug a Stored Procedure?
How to resolve the orphan use problem? : sql server security
How to concatenate two binary strings together?
what is the output for this query select * from employee where 1=1;
Do you know what is difference between index seek vs. Index scan?
Explain the third normal form(3nf)?
How you provide security to cube? : sql server analysis services, ssas
We need to perform what steps in the following order to work with a cursor?
what is a mixed extent? : Sql server administration