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 an indice?

1023

What is difference between views and tables?

1002

What is the purpose of self join?

968

What is the maximum length of an alert name?

999

What is a primary index?

919

What is query optimization process?

1003

What is a non equi join?

974

What is a db view?

890

What is the use of commit?

995

What is a covering index?

980

What is difference between count (*) and count 1?

920

What is normalization process?

1165

What is difference between rownum and row_number?

959

What is meant by indexing files?

1033

What is candidate key with example?

973

Un-Answered Questions { SQL Server }

Where do you find the default Index fill factor and how to change it?

1057

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1081

What is use of dbcc commands?

1059

Why are sql functions used?

1113

Is resultset an interface?

957

What are page splits? : SQL Server Architecture

982

Explain boyce and codd normal form(bcnf)?

934

What is the dbcc command and why is it used?

1044

What is filter index?

943

What is SubQuery in SQL Server 2008

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

Can we check locks in database? If so, how can we do this lock check?

937

If no size is defined while creating the database, what size will the database have?

984

Does a specific recovery model need to be used for a replicated database? : sql server replication

953

What Is Rdbms?

1147

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