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 update locks?

842

Determine when an index is appropriate?

1032

Can you explain important index characteristics?

958

Explain the purpose of indexes?

925

Explain full-text indexing?

933

Do you know clustered and non-clustered index?

951

Explain the difference between clustered and non-clustered index?

895

Explain having clause and where clause?

1005

Explain indexes disadvantages?

1023

Explain what is it unwise to create wide clustered index keys?

943

Ms sql server index?

1026

Do you know what is fill factor and pad index?

958

How to maintain a fill factor in existing indexes?

964

Write down the syntax and an example for create, rename and delete index?

938

Tell me the difference between clustered and non-clustered index?

904

Un-Answered Questions { SQL Server }

How to backup SQL Server Reporting Services ?

143

Explain Reporting Life Cycle?

118

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1821

What do you understand by triggers?

877

Write an SQL query to obtain the 2nd highest salary.

1033

If we delete pack Spec what will be the status of pack Body ?

1447

What happens if you delete a table that is used by a view?

951

How are the exceptions handled in sql server programming?

1022

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1017

What is subquery? Explain the properties of a subquery?

940

what are candidate key, alternate key and composite key? : Sql server database administration

869

How to rename an existing column with sql server management studio?

966

How to define the name and server for a new dsn?

1047

What is reportserver and reportservertempdb ?

148

What is difference between join and natural join?

911

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