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

Difference between report and query parameter.

1088

Explain the dirty pages?

996

What are magic tables in sql server?

1130

List few advantages of stored procedure.

980

What is the difference between locking and multi-versioning?

983

Differentiate between a local and a global temporary table?

947

Explain the collation?

1102

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

877

Describe how to use linked server?

1008

You want to implement the one-to-one relationship while designing tables. How would you do it?

960

Give a example to search fr a string in all stored procedure in sql server.

976

Explain the etl (extraction, transformation, and loading)?

990

What is a trace frag?

1081

Is it possible for a stored procedure to call itself or recursive stored procedure?

945

What is similarity and difference between truncate and delete in sql?

1089

Un-Answered Questions { SQL Server }

Explain what is row_number function?

1014

What does dml stand for?

943

Can you explain about buffer cash and log cache in sql server?

945

What is the difference between writing data to mirrored drives versus raid5 drives

920

What is schemabinding a view?

914

Explain about extended stored procedure?

931

How to convert character strings into numeric values?

1092

Which tools are available to manage SQL Azure databases and servers?

115

What is the usage of the sign function?

1098

How to find the version of sql server? : sql server database administration

1102

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1247

What is report subscription?

123

What is built-in/administrator?

998

What is the maximum size of a row in sql server?

961

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

2235

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