Explain what are various ways to enhance the ssrs report?
What is BCNF? How is it better than 2NF & 3NF?
What are the properties of sub-query?
Explain what are partitioned views and distributed partitioned views?
Tell me what is log shipping?
can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?
How to create view in stored procedure sql server?
What is blocking?
Write a code to select distinct records without using the DISTINCT keyword.
Other than truncate statement, which other command can by-pass the trigger on the tables?
Explain for xml explicit mode?
How do you create a data source?
Call by value and call by reference in procedure and function, with NOCOPY.