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

Can we shrink data file in sql server?

1038

What is the difference between upgrade and migration in sql server?

1082

What is sql server query analyzer?

1019

How do I find query history in sql server?

935

What are the source of constraints?

912

How do I create a trace in sql server?

1027

How do I find the sql server version?

1016

What are the types of constraints?

1 1439

What are different types of constraints?

917

How do you check sql server is up and running?

988

How do I find the transaction log size in sql server?

949

What is log in sql server?

1141

How do I clean up sql server transaction log?

1057

What is rtm version in sql server?

1040

What are three major types of constraints?

1108

Un-Answered Questions { SQL Server }

Explain about integration services of Microsoft SQL server?

1030

How do clustered indexes store data?

1096

Define tool Manage Statistics in SQL Server 2000 query ?

1080

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

1016

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

977

Differentiate between a primary key and a unique key.

1060

What is advantage data architect?

916

Explain filtered indexes?

990

Explain where clause?

984

Explain system scalar functions?

993

How to use old values to define new values in update statements in ms sql server?

1258

When a primary key constraint is included in a table, what other constraints does this imply?

981

What method is used by the Command classes to execute SQL statements that return single values?

1058

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

971

what is a mixed extent? : Sql server administration

1095

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