SQL Server Interview Questions
Questions Answers Views Company eMail

what is package and it uses and how can u call a package

Satyam,

961

What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning

TCS,

3 7047

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

924




how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?

Accenture, IBM, Marlabs,

15 14606

how insert selected column only ?

Robert Half,

3 3432

when we use function instead of procedure? plz tell me the situation with ex?

IBM,

3 7887

What are the new features in SQL Server 2005?

Emphasis,

3 3904

What are the different types of backup avaible in SQL SErver

IBM, Emphasis,

6 6185




About Indexed Views? with example? plz reply...

2 6046

What is indexed views? plz explain with example?

2 2459

What is Covering Indexes? Plz explain with example

3 6798

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

935

what is Archive old data?

1 1863

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 3198

what is maximum size of temp db?

iSoft,

4 8363


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

your distribution database is full what will u do

1033


1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

860


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

748


where the connection string store in the database

898


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

950






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

924


What is RMS migrations?

1035


Issues related in upgrading SQL Server 2000 to 2005 / 2008

855


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

1113


How do use Having,Group by,Group function in SQL?

740


How retrieve field names from the table in SQL through JAVA code?

772


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

1182


optimization techinques

1462


what is the sql equivaent of the dataset relation object ?

905


Call by value and call by reference in procedure and function, with NOCOPY.

230