SQL Server Interview Questions # 7

One of my friend has given me few technical interview question. He has given interview for a company based out from Chandigarh. So with out further delay I will list the questions-

Question 1 : SQL Server – Should you update statistics after rebuild indexes?

Question 2 : SQL Server – Should you update statistics after reorganize indexes?

Question 3 : SQL Server – Can you create filtered index on computed columns?

Question 4 : SQL Server – Could you please tell situations where it is fine to use cursors?

Question 5 : SQL Server – What is Parameter Sniffing?

Question 6 : SQL Server – You have a query which is working very slow when executed from application but working fine when executed from SSMS? What could be the reason?

Question 7 : Reporting Services – You have 100 columns in your SSRS report and you are exporting this report into PDF format, How do you manage this?

Question 8 : SQL Server – Provide output of below query.

--

SELECT X.X
FROM 
( SELECT 5 X ) X
INNER JOIN
( SELECT 5 X , 6 Y ) Y ON X.X = Y.Y
  
--

Question 9 : Can you create table in SQL Azure with out clustered index?

Shall update the answers very soon !

Cheers, Thanks for reading !

-Pawan Khowal

MSBISkills.com