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

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

Infosys,

5 23546

Can we create clustered index on non primary key column

ABC, CTS,

20 54813

What are Sql Reporting Services and analysis services? Can u Explain

1 10046

What r sql reporting services and analysis services? how can we use it.

Microsoft,

2 12694

is there more the two primary key in a single table?

Eforce, Systematix,

26 32552

how to implement locking in sql server

Satyam,

3 8836

What is the difference between a Application Server and a Database

Oracle,

3 13186

What is the difference between 2-Tier architecture and 3-Tier architecture

CTS, MCN Solutions, Oracle,

15 68336

what is differece between union and union all

6 10180

Is trigger fired implicitely?

2 5675

how do we find every fifth record in a table

Aspire, HCL,

14 18690

What is the appropriate number of test cases that you can write on a database?

Microsoft,

2 7040

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

Microsoft,

2 7195

WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?

8 21811

MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE

IBM, TCS,

2 17404

Un-Answered Questions { SQL Server }

Difference between primary key and clustered index?

998

How to use transact-sql statements to access the database engine?

1055

What are the benefits of filtered indexes?

1032

How to optimize stored procedures in sql server?

1176

What are the filtered indexes?

1030

Mention a few common trace flags used with sql server?

924

How to change the name of a database user?

954

what are defaults? : Sql server database administration

1081

How to Check if table exists in sql server?

1121

Which are the new data types introduced in sql server 2008?

879

whats new about truncate in sql server 2008?

2496

What are window functions in sql server?

1001

How to enter binary string literals in ms sql server?

1145

What stored by the master? : sql server database administration

1098

What is the difference between local and global temporary tables?

1133

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