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 17991

Can we create clustered index on non primary key column

ABC, CTS,

20 40498

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

1 8303




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

Microsoft,

2 9930

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

Systematix, Eforce,

26 16990

how to implement locking in sql server

Satyam,

3 5330

What is the difference between a Application Server and a Database

Oracle,

3 9919

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

CTS, Oracle,

15 55347




what is differece between union and union all

6 5817

Is trigger fired implicitely?

2 3367

how do we find every fifth record in a table

Aspire, HCL,

14 10261

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

Microsoft,

2 4286

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 4295

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

8 15443

MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE

TCS, IBM,

2 13489


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

904


If a stored procedure is taking a table data type, how it looks?

4644


How we create SQL Server 2005 Reporting Services ? Give me Sample

920


Delete duplicate rows without using rowid.

190


If the job running very slow what is the action you do

713






ow to bring suspect mode datbase online from scratch

684


Explain Capacity planning to create a database? and how to monitor it?

2803


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1040


Issues related in upgrading SQL Server 2000 to 2005 / 2008

767


how to take backup bcp out for a column in table in sql server?

854


how to overcome kernel isssues

468


plss anybody specify tha constrian management system in dbms

821


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

1102


your distribution database is full what will u do

956


what exactly sql injuction.how to overcome.....

1310