Write a SQL query in order to merge two different columns into single column?
Will count(column) include columns with null values in its count?
What are number line correlation administrators will use while working with a subquery?
one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.
What is transaction server consistency?
what is meant by sql injection with example and one more question how to catch the errors in sqlserver
what is the difference between delete table and truncate table commands? : Sql server database administration
Explain isolation levels that sql server supports?
What is de-normalization and when do you do it?
List some major differences between triggers and stored procedures?
Advantages and disadvantages of stored procedures.
What are secondary xml indexes?
What are the components of dbms?