What is parameterized reports in ssrs ?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What is the use of =,==,=== operators?
Tell me about joins in database system and explain each in detail.
Explain the disadvantages of cursors?
How do I get Report Builder to generate a parameter that can be set by users viewing the report?
What is a natural primary key?
Explain table valued parameters in sql server? Why tvp used?
How to copy the tables, schema and views from one sql server to another?
What is xdr?
What do you mean by a dependent functionality in a build?
what are the three command line utilities and what are their primary functions?
Explain what is public role in sql server?
What are the reporting services components?
Do you know what is fill factor and pad index?