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

1 2084

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 10120

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

1 2169

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 26489

how insert selected column only ?

Robert Half,

3 6771

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

IBM,

3 11279

What are the new features in SQL Server 2005?

Emphasis,

3 7145

What are the different types of backup avaible in SQL SErver

Emphasis, IBM,

6 10523

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

2 8387

What is indexed views? plz explain with example?

2 4579

What is Covering Indexes? Plz explain with example

3 10028

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

1 2045

what is Archive old data?

1 3677

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 6112

what is maximum size of temp db?

iSoft,

4 12026

Un-Answered Questions { SQL Server }

What kind of problems occurs if we do not implement proper locking strategy?

1490

Does view occupy space?

1005

How to convert numeric expression data types using the cast() function?

1142

what is the difference between openrowset and openquery?

1186

How to enter binary string literals in ms sql server?

1235

Why use identity in sql server?

1189

How can I check that whether automatic statistic update is enabled or not?

1108

How raid can influence database performance?

1104

Equi join and non equi join is possible with sql server?

1119

How do I create a trace in sql server?

1109

Can we shrink data file in sql server?

1117

What are the different types of subquery?

1226

What is sql or structured query language?

1212

What is a view in sql?

1035

What is temporary table in sql server? Why we use temp table?

1006

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