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

Can coalesce return null?

1067

Does hive support indexing?

999

Does partitioning ssd reduce performance?

930

Does partitioning help performance?

994

Does partitioning improve performance?

1018

Does table partitioning improve performance?

1015

How do I open a .db file?

1080

How do you run a trace?

946

How do you make a trace?

1073

What is an etl file?

1008

How do I shrink an ldf file?

1038

What is temporal table?

936

What is the difference between dataadapter and datareader?

1058

How does a profiler work?

993

What is the purpose of a table?

993

Un-Answered Questions { SQL Server }

What command do we use to rename a database?

1115

Does hive support indexing?

999

What are the difference between primary keys and foreign keys?

1014

What is data modification?

1017

Where actually sql azure database is hosted?

165

Can we write trigger for view?

1069

Explain about remote stored procedure?

1060

How to manipulate data from one table to another table ?

1018

What do you mean by 'normalization'?

1121

What is 2nf normalization form?

1200

Where are full-text indexes stored?

1036

What is table valued function and scalar valued functions?

1160

How to verify a login name with sqlcmd tool?

1265

Why do we need normalization?

975

Explain can SSRS reports Cache results?

161

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