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 to create “alternate row colour”?

152

How to create percentile function?

159

How to make conditional sum in ssrs?

183

how you can deploy an ssrs report?

185

Can I disable or restrict ssrs export formats (rendering formats)?

155

How to create “dependant” parameter “make, model, year”

137

Can sub report data source be different from that of the parent report?

149

How to create median function?

172

Sql server reporting services vs. Crystal reports.

142

When I run the sql server 2000 setup, it just hangs. What do I do?

1129

Which tcp/ip port does sql server run on? How can it be changed?

1086

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1085

What is a file group?

1171

Does order by actually change the order of the data in the tables or does it just change the output?

1209

What is the definition for sql server 2000?

1142

Un-Answered Questions { SQL Server }

What is the difference between TRUNCATE and DROP?

1192

Explain transaction server auto commit?

1092

What is a primary index?

980

what are the different ways to return the rowcount of a table?

1059

What is amo? : sql server analysis services, ssas

1137

When would you use a before or after trigger?

959

Do you know the different ddl commands in sql?

1109

what protocol both networks use? : Sql server database administration

1021

What is the concept of optimization?

1112

Explain what is raid and what are different types of raid levels?

1094

What does dml stand for?

998

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

1019

Explain cursor as data base object?

1099

What is user-defined scalar function?

1010

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

2072

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