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 18524

Can we create clustered index on non primary key column

ABC, CTS,

20 41379

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

1 8419




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

Microsoft,

2 10186

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

Systematix, Eforce,

26 17570

how to implement locking in sql server

Satyam,

3 5566

What is the difference between a Application Server and a Database

Oracle,

3 10095

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

CTS, Oracle,

15 56068




what is differece between union and union all

6 5988

Is trigger fired implicitely?

2 3498

how do we find every fifth record in a table

Aspire, HCL,

14 10594

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

Microsoft,

2 4522

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 4451

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

8 15929

MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE

TCS, IBM,

2 13865


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

1122


what are the critical issues you have resloved in your company

914


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

935


how can you attach more than 20 ldf files in sql server

912


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

789






tell me the disaster recovery plan

1370


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

957


OPTIMIZATION OF SP,CURSOR,TRIGGERS

1594


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

466


What is RMS migrations?

1047


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

1324


Why do you want to join software field as you have done your BE in Electronics?

1102


how to overcome kernel isssues

541


New concepts of sql server 2005 use in your project.

1313


on line cluster can we make if yes tell me the procedure

920