SQL Server Interview Questions
Questions Answers Views Company eMail

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

CMC, Hitech,

3 3751

Difeerence between ssis 2005 and ssis2008?

Convergys,

1 4099

How to provide Security for package?

Convergys,

1 4851




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

ABC,

4 4530

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

982

OPTIMIZATION OF SP,CURSOR,TRIGGERS

1521

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

Broadridge,

2 4555

what is diffrent between store procedure and trigger

2 2750




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 2170

what is victor class

1112

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 2456

syntax and example for bitmap index in sql???

1 3125

One table how may column and Primary key

3 2404

Psudo colums

HP,

1 2428

Simple example for difference between select and cursor in sql

1 2643


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

1357


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

1313


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

369


which backup strategy you are following at ur company

1009


Which is the best place or learning center for MS SQL?????In Bangladesh?????

891






what are the Prerequisites for Replication?

8515


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

846


sql database suspect We have a sql database that is showing as suspect. How can we recover?

724


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

615


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

4675


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

1069


what is checksum in sql server.........???

411


what is difference between view and Dip.

1225


plss anybody specify tha constrian management system in dbms

836


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

628