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

How many triggers are possible per table?

1098

What is the maximum number of index per table?

1073

How to recompile stored procedure at run time?

1076

What are the different types of stored procedures?

1117

What is difference between rollback immediate and with no_wait during alter database?

1090

What is merge statement?

1080

Explain throw statement in sql server 2008?

994

What is nonclustered index on computed columns?

960

Explain some stored procedure creating best practices or guidelines?

937

Explain try...catch with sql server?

1021

What are sp_configure commands and set commands?

1023

What is the ‘fillfactor’?

968

What is read uncmmited?

1058

What is an sql server agent?

1063

What is the difference between for trigger and after trigger?

1106

Un-Answered Questions { SQL Server }

Describe in brief databases and sql server databases architecture.

1009

Explain system views?

1086

What are difference between Cluster index and Non-Cluster index?

1079

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1063

How you can change a cross join into an inner join?

973

What are constraints?

1010

How will you monitor replication latency in transactional replication? : sql server replication

1143

Explain syntax for disabling triggers?

1040

can we have a nested transaction? : Sql server database administration

1094

What is indexed view?

980

What is stored in the mssqlsystemresource database? : sql server database administration

1030

What do you understand by a stored procedure?

1088

What does man by sql wildcard characters in sql server?

1059

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

985

What is ddl command?

975

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