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 a job?

3 6161

What are primary keys and foreign keys?

4 8057

How would you Update the rows which are divisible by 10, given a set of numbers in column?

3 11454

If a stored procedure is taking a table data type, how it looks?

1 6432

How m-m relationships are implemented?

2 8299

How do you know which index a table is using?

4 12875

How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?

3 8412

How do you find the error, how can you know the number of rows effected by last SQL statement?

2 8959

How can you get @@error and @@rowcount at the same time?

9 24255

What are sub-queries? Give example? In which case sub-queries are not feasible?

Infosys,

4 11933

What are the type of joins? When do we use Outer and Self joins?

3 10209

Which virtual table does a trigger use?

TCS,

8 27356

How do you measure the performance of a stored procedure?

Infosys,

3 16171

Questions regarding Raiseerror?

1 6864

Questions on identity?

Infosys,

2 7004

Un-Answered Questions { SQL Server }

What do you know about normalization and de- normalization?

919

Why union all is faster than union?

906

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1194

What is the osql utility?

950

Write an sql query to find first weekday of the month?

908

How to generate create view script on an existing view?

982

Explain various data region available in ssrs with their use?

925

Write a program to fetch first 10 records from a file?

997

can an automatic recovery be initiated by a user? : Sql server administration

945

List some advantages and disadvantages of stored procedure?

1014

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2923

Is there any difference between the primary key and unique key?

997

What is an etl file?

949

What is the difference between coalesce() & isnull()?

1122

What is abstracting periodical?

937

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