SQL Server Interview Questions
Questions Answers Views Company eMail

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

Satyam,

886

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 6899

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

854




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 14096

how insert selected column only ?

Robert Half,

3 3313

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

IBM,

3 7678

What are the new features in SQL Server 2005?

Emphasis,

3 3791

What are the different types of backup avaible in SQL SErver

IBM, Emphasis,

6 6021




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

2 5923

What is indexed views? plz explain with example?

2 2375

What is Covering Indexes? Plz explain with example

3 6575

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

858

what is Archive old data?

1 1774

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 3101

what is maximum size of temp db?

iSoft,

4 8174


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

what are the Prerequisites for Replication?

8457


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

1103


what is difference between view and Dip.

1206


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

853


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

940






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

1501


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

940


how can u get last observation in an unknown dataset ?

1148


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

817


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

886


query processing

1000


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


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

706


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

705


Working with TLogs

683