What are scalar functions?
What is the downside of using udf?
What is a dbms wizard?
Do you know sql server 2008 backup compression?
Explain the properties of subqueries in sql server?
explain the storage models of olap? : Sql server database administration
Will count(column) include columns with null values in its count?
Can group by and orderby be used together?
Data table as parameter in sql server?
How dts is used to extract, transform and consolidate data?
How can we improve performance by using SQL Server profiler?
What is normalization? Describe its different types.
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?