What happens if we shrink log file in sql server?
Tell me what are cursors and when they are useful?
Tell me about pre-defined functions of sql?
Tell me about normalization in DBMS.
How to apply filtering criteria at group level with the having clause in ms sql server?
Difference between report and query parameter. Why do we need different type of parameter?
Explain the commands in sql server?
what is datawarehouse?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
What is the difference between coalesce() & isnull()?
from the table display the 2nd highest salary? and also the least 2nd salay?
How the data stores in a page?
can an order by clause be used in a creation of a view?