SQL Server Interview Questions
Questions Answers Views Company eMail

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

CMC, Hitech,

3 3728

Difeerence between ssis 2005 and ssis2008?

Convergys,

1 4073

How to provide Security for package?

Convergys,

1 4832




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

ABC,

4 4501

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

968

OPTIMIZATION OF SP,CURSOR,TRIGGERS

1510

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

Broadridge,

2 4510

what is diffrent between store procedure and trigger

2 2726




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 2147

what is victor class

1099

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 2425

syntax and example for bitmap index in sql???

1 3097

One table how may column and Primary key

3 2371

Psudo colums

HP,

1 2406

Simple example for difference between select and cursor in sql

1 2629


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1144


Any one plz send me SQL Server Developer/DBA resume for 4 years experience

1501


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., }

1061


Why we need to use secondry database file? though, we can do same work using primary database file also.

4213


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

877






what is difference between view and Dip.

1205


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.

1263


whats the maximum size of view state??

948


If user is owning any SQL Objects, can we drop that user

852


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

864


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

809


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1351


query processing

999


what are the Prerequisites for Replication?

8453


In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

873