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,

1135

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

Microsoft,

1097

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,

1014

How to create a Master database in SQL server ?

MCN Solutions,

1088

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

MCN Solutions,

1208

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

HCL,

1105

Show Practically Sql Server Views are updatable?

QuestPond,

1123

Define tool Manage Statistics in SQL Server 2000 query ?

NA,

1093

What is dynamic cursor in SQL SERVER?

1080

How you can change the database name in SQL SERVER?

1192

how we use window authentication connection with sql server.?

MCN Solutions,

1152

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,

1095

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

Petranics Solutions,

963

Un-Answered Questions { SQL Server }

Define normalisation?

1116

How to drop an existing stored procedure in ms sql server?

1032

What are the different types of sql server replication? : sql server replication

1272

Explain what are magic tables in sql server?

997

Do you know what is lock escalation?

1012

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

2147

Why we use trigger in sql server with example?

959

Mention a few common trace flags used with sql server?

930

Can we create clustered index on composite key?

1084

What are relationships and mention different types of relationships in the dbms

962

What is the difference between a stored procedure and a user defined function?

1020

how can you check the level of fragmentation on a table? : Sql server administration

982

Is mysql better than sql server?

1059

What is forward - only cursors / read only cursor?

1089

What guidelines should be followed to help minimize deadlocks?

943

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