SQL Server Interview Questions
Questions Answers Views Company eMail

Which autogrowth database setting is good?

612

What types of replication are supported in sql server?

554

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

519

What is not null constraint?

611

How to get nth highest salary from employee table.

610

How would you add a section to a table?

559

What do you mean by stored techniques? How would we use it?

571

Tell me something about security and sql azure?

100

How many replicas are maintained for each sql azure db?

104

What is federation member?

91

How to identify current user in ssrs report?

238

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

114

Explain can you implement data mining in ssrs?

106

How to change parameter value inside the report?

104

What is the rdl file?

88


Un-Answered Questions { SQL Server }

How to rename an existing column with sql server management studio?

492


What stored by the master?

537


What are date and time data types in ms sql server?

517


How to select an exiting database using mssql_select_db()?

503


Explain collation?

613






How to get the query of a table in sql server?

494


What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

685


What are the steps you will take to improve the performance of a poor performing query?

585


How many categories of functions based their return modes?

581


Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

505


What is a result set object returned by mssql_query()?

566


How do you implement session management in SQL Server mode?

546


What is an example of a primary key?

498


How to set database to be single_user in ms sql server?

553


Does index slows down insert statements?

579