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

Will sql server 2005 allow you to reduce the size of a column?

1055

What does the update command do?

1173

Can you type more than one query in the query editor screen at the same time?

1068

How do I find information about the install locations for the various instances running on a computer?

1124

What is the maximum row of a size?

1068

Does sql server 2000 clustering support load balancing?

1025

What is unique key constraint?

1118

What is default port number for sql server 2000?

1105

How to copy data from one table to another table?

1051

What is the purpose of the tempdb database?

1045

What are the properties and different types of sub-queries?

1050

Is the log file is a part of file group?

1095

What is attribute relationships, why we need it? : sql server analysis services, ssas

1030

What is the maximum size of a dimension? : sql server analysis services, ssas

1086

What is dimension table? : sql server analysis services, ssas

1065

Un-Answered Questions { SQL Server }

How to update muliple row in single query?

1113

What are different types of views?

985

Which sql server table is used to hold the stored procedure script?

1004

How to assign null values to variables or columns?

1027

What do we have to check in database testing?

1056

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

1249

What is shrink log file?

952

Mention what are the different types of ssrs reports?

158

What are the built in functions in sql server?

1027

How to get a list of columns in a view using the "sp_columns" stored procedure?

1086

What is the exact numeric data type in sql?

1056

What are the rules to use the rowguidcol property to define a globally unique identifier column?

1075

How to loop through result set objects using mssql_fetch_array()?

1133

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

1050

Explain how you can configure a running aggregate in SSRS?

169

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