SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

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

2014

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 9925

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

2105

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 25803

how insert selected column only ?

Robert Half,

3 6579

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

IBM,

3 11105

What are the new features in SQL Server 2005?

Emphasis,

3 6936

What are the different types of backup avaible in SQL SErver

Emphasis, IBM,

6 10265

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

2 8253

What is indexed views? plz explain with example?

2 4447

What is Covering Indexes? Plz explain with example

3 9814

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

1965

what is Archive old data?

1 3583

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 5937

what is maximum size of temp db?

iSoft,

4 11840

Un-Answered Questions { SQL Server }

What is the meaning of resultset type_scroll_insensitive?

956

How to create new tables with "select ... Into" statements in ms sql server?

990

What is the difference between lock, block and deadlock? : sql server database administration

1045

Explain error handling in ssis?

1023

What is self join in sql server joins?

1059

Explain transaction server consistency?

973

How to use transact-sql statements to access the database engine?

1067

What is difference between index and primary key?

1100

Describe triggers features and limitations?

989

Explain what is lock escalation and what is its purpose?

932

What is the difference between substr and charindex in the sql server?

1101

Which is faster statement or preparedstatement?

945

How fixed length strings are truncated and padded?

980

What is the difference RDBMS and Graph Database?

1047

what are cursors? : Sql server database administration

1061

For More Un-Answered { SQL Server } Questions Click Here