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

2010

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 9903

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

2102

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 25762

how insert selected column only ?

Robert Half,

3 6566

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

IBM,

3 11097

What are the new features in SQL Server 2005?

Emphasis,

3 6920

What are the different types of backup avaible in SQL SErver

Emphasis, IBM,

6 10236

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

2 8243

What is indexed views? plz explain with example?

2 4441

What is Covering Indexes? Plz explain with example

3 9799

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

1961

what is Archive old data?

1 3577

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 5927

what is maximum size of temp db?

iSoft,

4 11816

Un-Answered Questions { SQL Server }

what is the difference between Delete and Truncate command in SQL

1144

What are the purposes of floor and sign functions?

964

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

1035

What are the different types of sub-queries?

1039

What are the ways available in sql server to execute sql statements?

1113

What are the restrictions that views have to follow?

961

Define outer join?

985

What is an indexed view?

949

What is the difference between osql and query analyzer?

986

Define right outer join in sql server joins?

1038

What is a benefit of using an after insert trigger over using a before insert trigger?

981

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

2755

Can sql servers linked to other servers?

1031

Define a cross join?

1006

What do you mean by authentication modes in sql server?

1080

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