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 are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

QuestPond,

1136

What is the default port for SQL Server over a firewall?

Microsoft,

1099

What is the syntax for encrypting a column in SQL Server?

MindCracker,

1120

what is difference between NULL and ISNULL in SQL Server 2008?

MCN Solutions,

1016

How to create a Master database in SQL server ?

MCN Solutions,

1090

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

MCN Solutions,

1210

Difference between LEN() and DATALENGTH() in sql server ?

HCL,

1107

Show Practically Sql Server Views are updatable?

QuestPond,

1124

Define tool Manage Statistics in SQL Server 2000 query ?

NA,

1094

What is dynamic cursor in SQL SERVER?

1082

How you can change the database name in SQL SERVER?

1192

how we use window authentication connection with sql server.?

MCN Solutions,

1153

How display code or Text of Stored Procedure using Sql query in Sql Server ?

Wipro,

1145

Difference between connected and disconnected database in .net with sql server?

Infosys,

1097

Give the query of getting last two records from the table in SQL SERVER?

Petranics Solutions,

963

Un-Answered Questions { SQL Server }

If we delete pack Spec what will be the status of pack Body ?

1476

Explain what is public role in sql server?

1135

What are the properties of the relational tables?

881

What does it mean to normalize a database and why would you do it?

979

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

1006

Explain what is meant by replication of database?

1033

Explain some stored procedure creating best practices or guidelines?

937

Why the trigger fires multiple times in single login?

1213

what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

1056

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1132

When would you prefer to have a minimum number of indexes?

911

How to recompile stored procedure at run time?

1076

What is a transaction and why is it important?

1091

Do you know what are various aggregate functions that are available?

1126

What is the impact on other user sessions when creating indexes?

927

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