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

How do you optimize Sql queries ?

Cognizant,

2426

Rate yourself in .NET and SQL ?

Cognizant, HCL, SunGard,

1 8962

in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 10300

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

Credit Suisse, GCU, Symphony, TCS,

4 27253

What's the difference between a primary key and a unique key?

4 8578

What are user defined datatypes and when you should go for them?

1 8142

What is bit datatype and what's the information that can be stored inside a bit column?

1 4803

Define candidate key, alternate key, composite key.

Infosys, Software India,

13 116007

What are defaults? Is there a column to which a default can't be bound?

TCS,

2 8980

What is a transaction and what are ACID properties?

Config Systems, IBM, TCS, Virtusa,

14 78057

Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement

3 8804

Explain Active/Active and Active/Passive cluster configurations

2 15893

What is RAID and what are different types of RAID configurations?

Wipro,

8 30557

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

Microsoft,

7 47969

What is blocking and how would you troubleshoot it?

2 5519

Un-Answered Questions { SQL Server }

How do I know if localdb is running?

952

What is the server name in sql server?

1010

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

2021

How can we migrate from SQL server to SQL Azure?

113

How to optimize stored procedure optimization?

892

Explain the rules for designing files and file groups in sql server?

987

how many triggers you can have on a table? : Sql server database administration

976

Is candidate a key?

947

What does the on delete cascade option do?

1017

whats the maximum size of view state??

2192

What is a non-clustered index?

998

If user is owning any SQL Objects, can we drop that user

2074

What are data files?

1040

How you can find out if an index is useful to the optimizer?

939

What is the difference between Stored Procedures and triggers?

1080

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