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

What is the Difference beween sql server 2005 and sql server 2008

CMC, Hitech,

3 7009

Difeerence between ssis 2005 and ssis2008?

Convergys,

1 6375

How to provide Security for package?

Convergys,

1 7128

how to get rank of diffrent student in same table based on newly inserted row in sql server2008

ABC,

4 8348

What are the dis_advantages of stored procedures, triggers, indexes?

2273

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2852

what's the difference between SQL & MY-SQl...? And what we learn from these ....?

Broadridge,

2 7920

what is diffrent between store procedure and trigger

2 5364

can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -

2 4552

what is victor class

2312

can any one say how to update the following senario I have a table in which the table structure is as follows ANAME ACCNO LOCATION ACCTYPE BAL SBanuPrakash 31518746291 Punganur deposit 4000 Sreenivas 31518746292 mahoobnagar current 14000 Ranjith 31518746293 Karimnagar Savings 2000 Giresh 31518746294 Chennai deposit 40000 Boo 31518746295 Chennai Savings 20000 Jay 31518746296 Valachari Savings 1000 tirumalraj 31518746297 Vellore Savings 8000 The senario is We need to select one account number and check the balance after checking the balance if the balance exist we need to transfer to another account . in the from account the amount need to be reduced and in the to account the amount needed to be added. for example for the <31518746291> the balance is <4000> for the <31518746292> the balance is <14000> after transferring the balance the details will look as follows <31518746291> <2000> <31518746292> <16000> the above mentioned two statment will come under the final result.

3 5712

syntax and example for bitmap index in sql???

1 5429

One table how may column and Primary key

3 5459

Psudo colums

HP,

1 4637

Simple example for difference between select and cursor in sql

1 4666

Un-Answered Questions { SQL Server }

Which are the olap features?

1006

Explain the difference between clustered and non-clustered index?

966

What action plan is preferred if sql server is not responding?

1154

What are the rules to use the rowguidcol property to define a globally unique identifier column?

1074

List the data types available in mssql?

1101

What are sql dirty pages?

1081

What is an execution plan? When would you use it?

1024

What is save transaction and save point?

1255

How to reaname table name without using sp_Rename in sql server..?

1038

How sql server enhances scalability of the database system?

1313

What is the difference between having clause and where clause in sql server?

1163

What command is used to rename the database?

1085

What stored by the msdb?

1046

How to view existing indexes on an given table using sp_help?

1204

Does sql server 2000 clustering support load balancing?

1024

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