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.

1029

Explain the dirty pages?

961

What are magic tables in sql server?

1076

List few advantages of stored procedure.

937

What is the difference between locking and multi-versioning?

948

Differentiate between a local and a global temporary table?

902

Explain the collation?

1054

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

845

Describe how to use linked server?

944

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

919

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

919

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

944

What is a trace frag?

1040

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

901

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

1042

Un-Answered Questions { SQL Server }

How do I start sql server 2017?

897

Can you explain the disadvantages/limitation of the cursor?

915

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1942

how to avoid cursors? : Sql server database administration

911

Explain about integration services of Microsoft SQL server?

991

What security features are available for stored procedure?

996

How do I start sql server?

931

What is a join in sql? What are the types of joins?

1018

What is subquery? Explain the properties of a subquery?

934

Is the primary key column of a table an index in ms sql server?

925

What is reportserver and reportservertempdb ?

146

Do you know the cursor optimization tips?

935

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

886

Define right outer join in sql server joins?

988

How connect excel to sql server?

936

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