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 23587

Can we create clustered index on non primary key column

ABC, CTS,

20 54888

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

1 10051

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

Microsoft,

2 12712

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

Eforce, Systematix,

26 32662

how to implement locking in sql server

Satyam,

3 8865

What is the difference between a Application Server and a Database

Oracle,

3 13206

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

CTS, MCN Solutions, Oracle,

15 68403

what is differece between union and union all

6 10209

Is trigger fired implicitely?

2 5694

how do we find every fifth record in a table

Aspire, HCL,

14 18752

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

Microsoft,

2 7048

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 7208

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

8 21834

MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE

IBM, TCS,

2 17411

Un-Answered Questions { SQL Server }

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1266

What is the purpose of indexing?

1044

What are commit and rollback in sql?

1125

How to set the current database in ms sql server?

1081

what is the difference between Tabular and Matrix report?

170

How to get the definition of a stored procedure back?

977

What are the new features in sql server 2016?

967

List out the differences between global and local temp tables in sql server?

1060

What is global temp table?

995

What is factless fact table? : sql server analysis services, ssas

1028

Detail about the hardware which is supported by SQL server?

1063

What is 3nf normalization?

995

What is data source in connection string?

907

What are the steps to take to improve performance of a poor performing query? : sql server database administration

1050

How much is a sql server license?

953

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