Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...



SQL Server Interview Questions
Questions Answers Views Company eMail

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

Satyam,

1412

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 8297

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

1462

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 19647

how insert selected column only ?

Robert Half,

3 4822

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

IBM,

3 9296

What are the new features in SQL Server 2005?

Emphasis,

3 5183

What are the different types of backup avaible in SQL SErver

Emphasis, IBM,

6 7749

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

2 6953

What is indexed views? plz explain with example?

2 3297

What is Covering Indexes? Plz explain with example

3 8160

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

1427

what is Archive old data?

1 2611

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 4167

what is maximum size of temp db?

iSoft,

4 9882


Un-Answered Questions { SQL Server }

Write a query to find 5th highest amount paid from the customer table.

385


Is it possible in sql table to have more than one foreign key?

452


Explain isolation levels that sql server supports?

427


What is the recursive stored procedure in sql server?

370


How to start and end transact-sql statements?

437






What are the purposes of floor and sign functions?

388


What is query parameter in ssrs?

90


What are different types of raid configurations? : SQL Server Architecture

422


What are the 3 types of schema?

410


Explain the categories of stored procedure?

376


In which sql server version report builder introduced?

84


What is the full meaning of dml?

369


What is difference between join and natural join?

333


What is transaction server consistency?

378


Why it is recommended to avoid referencing a floating point column in the where clause?

395