Explain system scalar functions?
What are four major operators that can be used to combine conditions on a where clause?
Can we add our custom code in ssis?
What factors you will consider calculating the storage requirement for that view?
What are data files?
What is the architecture of ms sql reporting service?
When would you use a before or after trigger?
What is table join?
What is field with example?
How to enforce security in sql server? : sql server security
How to stop log file growing too big?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
What is the index requirement in SQL Azure?
What is dbcc? Give few examples.
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?