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

What is updatable resultset?

1007

Is port 1433 secure?

997

How do I open port 1433?

930

What is meant by dirty read?

996

How does recursive cte works in sql server?

1009

What is correlated subquery in sql server?

1072

What do you mean by sql server 2005 express management tools?

1305

Can we use max in where clause?

925

What is the use of group by clause?

942

Can we use where and having clause together?

1045

Can we use where clause with group by?

899

Can we use where clause in union?

1065

Can we use having clause without group by?

979

How do I create a stored procedure in dbml?

1007

What is db stored procedure?

880

Un-Answered Questions { SQL Server }

What is an etl file?

957

Explain different backup plans?

942

Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

190

What is checkpoint process in the sql server?

1030

What is the native system stored procedure to execute a command against all databases?

1029

How can you stop stored procedures from recompiling?

900

What is replace and stuff function in sql server?

1065

What is the name of the system variable that returns the number of rows affected by a SQL statement?

1008

what is database replicaion? : Sql server database administration

1193

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

995

Do you know sql server 2008 introduces automatic auditing?

980

Does partitioning help performance?

935

How to find the source of a table in sql server?

997

Can you explain what is indexed view? How to create it?

904

How to modify an existing stored procedure in ms sql server?

1079

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