SQL Server Interview Questions
Questions Answers Views Company eMail

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

Satyam,

1575

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 8750

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

1652

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,

16 21767

how insert selected column only ?

Robert Half,

3 5377

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

IBM,

3 9874

What are the new features in SQL Server 2005?

Emphasis,

3 5641

What are the different types of backup avaible in SQL SErver

Emphasis, IBM,

6 8439

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

2 7310

What is indexed views? plz explain with example?

2 3649

What is Covering Indexes? Plz explain with example

3 8655

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

1591

what is Archive old data?

1 2973

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 4678

what is maximum size of temp db?

iSoft,

4 10484


Un-Answered Questions { SQL Server }

How to create stored procedures with parameters in ms sql server?

544


What is a with(nolock)?

593


What are the types of sql server?

540


How to delete duplicate rows from table except one?

566


Explain sql server authentication modes?

635






What is tempdb in sql server?

539


List down some advantages of sql stored procedure?

578


What is Lock table in SQL?

1027


How to provide login information for a new odbc dsn?

555


What is instead of dml trigger?

613


What are different backups available in sql server?

624


What is a derived table?

534


what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

548


Why we use functions in sql server?

535


Can select statements be used on views in ms sql server?

604