SQL Server Interview Questions
Questions Answers Views Company eMail

What is updatable resultset?

516

Is port 1433 secure?

538

How do I open port 1433?

523

What is meant by dirty read?

556

How does recursive cte works in sql server?

524

What is correlated subquery in sql server?

557

What do you mean by sql server 2005 express management tools?

788

Can we use max in where clause?

511

What is the use of group by clause?

525

Can we use where and having clause together?

506

Can we use where clause with group by?

515

Can we use where clause in union?

593

Can we use having clause without group by?

556

How do I create a stored procedure in dbml?

514

What is db stored procedure?

467


Un-Answered Questions { SQL Server }

What is a covered index?

518


What is a user-defined function in the sql server and what is its advantage?

615


What is default port number for sql server 2000?

593


How to add the custom code in Report?

99


Can a table have 2 primary keys?

504






how many type of indexing in database?

577


What area unit the various kinds of info compression introduced in sql server 2008?

568


Does partitioning improve performance?

486


Tell me what is sql profiler?

621


What are the advantages of user defined function?

492


Scalability, Availability, Integration with internet, etc.)?

2433


What happens if we shrink log file in sql server?

518


Why is replication required on the sql server?

574


What is cube dimension? : sql server analysis services, ssas

534


What is the order by used for?

617