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

1117

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

1076

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

1167

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

1061

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

1034

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

1000

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

1006

what is database replicaion? : Sql server database administration

1275

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

947

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

1028

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

1051

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

1086

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

1104

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

1072

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

1228

Un-Answered Questions { SQL Server }

What is function of master database?

118

What is the most common type of join?

1045

What is master database? : SQL Server Architecture

1086

Why is replication required on the sql server?

1107

Explain SSRS Architecture?

203

What do you mean by subquery?

1152

What is forward - only cursors / read only cursor?

1135

Describe in brief databases and sql server databases architecture.

1069

Does partitioning help performance?

997

on line cluster can we make if yes tell me the procedure

2070

What are commonly used mssql functions in php?

1148

Explain triggers?

1066

What is a trigger and types of a trigger?

1033

How to execute stored procedure and set temp table in sql server?

1101

What are entities and relationships?

1029

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