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

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1029

what is the system function to get the current user's user id? : Sql server database administration

968

what's the maximum size of a row? : Sql server database administration

1031

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

981

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

934

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

909

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

894

what is database replicaion? : Sql server database administration

1119

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

861

what purpose does the model database serve? : Sql server database administration

934

what are constraints? Explain different types of constraints? : Sql server database administration

931

what is a schema in sql server 2005? : Sql server database administration

963

what are different types of raid configurations? : Sql server database administration

1008

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

973

how many clustered indexes can be created on a table? : Sql server database administration

1086

Un-Answered Questions { SQL Server }

Explain primary key?

909

What is difference between table aliases and column aliases? Do they affect performance?

926

How to create a simple user defined function in ms sql server?

986

what is unique and xaml nonclustered index

1006

Where are full-text indexes stored?

955

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

955

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

4318

Is the order of columns in the set clause important in ms sql server?

939

Mention what are the different types of ssrs reports?

147

What is join and name different type of joins?

995

How to make conditional sum in ssrs?

176

We need to perform what steps in the following order to work with a cursor?

1180

what is a schema in sql server 2005? : Sql server database administration

963

What are the components of sql server service broker?

958

Explain what are the database objects? : SQL Server Architecture

1023

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