What is sql server profiler?
in how many ways we can use count()
What is the use of RDBMS?
How many categories of functions based their return modes?
What is temporary table in sql server? Why we use temp table?
Why and when do stored procedure recompile?
Explain what is the function of sql server agent windows service?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
what are triggers? : Sql server database administration
What are user-defined functions (udfs) in sql server?
What is sql server schema compare? How we can compare two database schemas?
What is the difference between SSAS 2000 and SSAS 2005?