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

2071

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 10064

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

2148

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 26294

how insert selected column only ?

Robert Half,

3 6734

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

IBM,

3 11218

What are the new features in SQL Server 2005?

Emphasis,

3 7098

What are the different types of backup avaible in SQL SErver

Emphasis, IBM,

6 10460

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

2 8347

What is indexed views? plz explain with example?

2 4553

What is Covering Indexes? Plz explain with example

3 9973

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

2027

what is Archive old data?

1 3656

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 6060

what is maximum size of temp db?

iSoft,

4 11992

Un-Answered Questions { SQL Server }

Does partitioning improve performance?

1023

What is 1nf normalization form?

1085

What are functions in the sql server?

1297

Do you know data definition language, data control language and data manipulation language?

1091

What is sql injection and why is it a problem? : sql server security

1192

What is normalization? Explain its different types?

1153

How to create hyperlink from returned sql query ?

1183

Why use sub query in sql server and list out types of sub queries?

1061

What are the different subsets of sql?

1623

What do you mean by collation recursive stored procedure?

1112

Explain the etl (extraction, transformation, and loading)?

1058

What is the difference between dbcc indexdefrag and dbcc reindex?

1042

What is a trace frag? Where do we use it?

1160

Describe how to use the linked server?

1206

What is optimistic concurrency?

1094

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