What is store procedure? How do they work? When do you use?
How to concatenate two character strings together?
What are trace files?
What happens to a statement batch if there is a compilation error?
In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;
What is database dimension? : sql server analysis services, ssas
Do you know sql server 2008 backup compression?
Is Sql non procedural query language?
Is t sql the same as sql server?
How to find the service pack installed? : sql server database administration
What is subquery? Explain the properties of a subquery?
What is NOT NULL Constraint in sql server 2012?
How to stop log file growing too big?