SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

What is the purpose of sql profiler in sql server? : sql server database administration

629

Can we perform backup restore operation on tempdb? : sql server database administration

587

Can you move the resources after pausing the node? : sql server database administration

596

What should be the fill factor for indexes created on tables? : sql server database administration

629

What is lock escalation? : sql server database administration

599

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

606

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

520

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

610

What are the difference between primary key and unique key? : sql server database administration

528

Can you tell me some of the common replication dmv's and their use? : sql server replication

537

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

547

What type of locking occurs during the snapshot generation? : sql server replication

872

Explain what stored procedure sp_replcounters is used for? : sql server replication

1004

What are the different types of sql server replication? : sql server replication

626

How will you monitor replication latency in transactional replication? : sql server replication

616

Un-Answered Questions { SQL Server }

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?

527

Which are ddl commands?

542

What is the use of keyword with encryption.

582

Can we add our custom code in ssis?

555

what authentication modes does sql server support? : Sql server database administration

524

what is the difference between delete table and truncate table commands? : Sql server database administration

525

What is used to replicate sessions between instances in coldfusion clusters?

586

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

2035

Detail about the hardware which is supported by SQL server?

591

Explain primary key in sql server?

571

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

592

What are key constraints?

518

Where sql server usernames and passwords are stored in a sql server?

498

Why use sub query in sql server and list out types of sub queries?

545

Difference between LEN() and DATALENGTH() in sql server ?

596

For More Un-Answered { SQL Server } Questions Click Here