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 can I enforce to use particular index?

Symphony,

1 6169

What is sorting and what is the difference between sorting and clustered indexes?

1 7991

What are the differences between UNION and JOINS?

CarrizalSoft Technologies,

3 6331

What is the use of SCOPE_IDENTITY() function?

2 6368

Can we rollback records deleted by a truncate statement?

CarrizalSoft Technologies, United Healthcare,

3 8889

How many types of indexes are there in SQL Server?

CarrizalSoft Technologies, United Healthcare,

6 12468

How many types of TRIGGERS are there in MS SQL Server?

CarrizalSoft Technologies, TCS, United Healthcare,

8 31325

Difference between: - Delete & Truncate - Table & View - Constraints & Triggers

United Healthcare,

1 5974

Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?

United Healthcare,

1 5773

Can we execute a stored procedure inside a trigger?

BirlaSoft, CarrizalSoft Technologies, United Healthcare,

6 25001

What is the query optimization statistics?

1 2853

1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?

3 6596

write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car

Cognizant, TCS,

12 15752

How will u test the stroded procedures and functions? difference between SP and Triggers

TCS,

2 7758

explain the type of contraints

3 5421

Un-Answered Questions { SQL Server }

How to delete duplicate rows from table except one?

989

What is bookmark link in ssrs?

244

How to count duplicated values in a column in ms sql server?

1092

What is filtered index?

1095

What are two difference between sql azure and azure tables?

159

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

1116

Why use “nolock” in sql server?

1058

What are various aggregate functions that are available?

979

How to recreate an existing index in ms sql server?

1056

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

979

What is difference between getdate and sysdatetime in sql server 2008?

1047

How do I view a stored procedure in sql server?

982

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

4384

What is the difference between a unique key and primary key?

955

Explain the functionalities that views support?

1114

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