1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


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 21652

Can we create clustered index on non primary key column

ABC, CTS,

20 49131

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

 1 9327

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

Microsoft,

2 11667

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

Eforce, Systematix,

26 26011

how to implement locking in sql server

Satyam,

3 7538

What is the difference between a Application Server and a Database

Oracle,

3 11776

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

CTS, MCN Solutions, Oracle,

15 63392

what is differece between union and union all

 6 8048

Is trigger fired implicitely?

 2 4791

how do we find every fifth record in a table

Aspire, HCL,

14 15389

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

Microsoft,

2 6021

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 5979

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

 8 19687

MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE

IBM, TCS,

2 16143

Un-Answered Questions { SQL Server }

How to sort the query output with order by clauses in ms sql server?

624

How to use “drop” keyword in sql server and give an example?

677

Can we shrink data file in sql server?

529

How can a user-defined datatype be created?

532

Which sql server table is used to hold the stored procedure script?

469




How to connect Azure federated root database and apply federation in entity framework?

87

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

562

What is store procedure? How do they work? When do you use?

499

What is dbcc command in sql server?

581

Explain concepts of analysis services?

503

What are parameterized reports? What are cascading parameters in ssrs reports?

100

Define outer join in sql server joins?

515

When to use Inner join & when to use subquery?

571

Do you know what is lock escalation?

574

Define self join in sql server joins?

512

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