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 a subquery in a select query statement in ms sql server?

1184

How to see the event list of an existing trigger using sys.trigger_events?

1126

How to provide default values to stored procedure parameters?

1099

How to defragment indexes with alter index ... Reorganize?

1134

What is the default schema of your login session in ms sql server?

1091

Where to find ntwdblib.dll version 2000.80.194.0?

1006

What happens if ntwdblib.dll is missing on your machine?

1187

How to disconnect from a sql server using mssql_close()?

1162

How to turn on the mssql api module in php?

1118

Can select statements be used on views in ms sql server?

1104

How to create a ddl trigger using "create trigger" statements?

1185

How to use old values to define new values in update statements in ms sql server?

1330

Does index speed up select statements?

1072

What happens if time-only values are provided as date and time literals?

1057

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

1011

Un-Answered Questions { SQL Server }

How to create view in stored procedure sql server?

1053

How can you tell if a database object is invalid?

1113

How to delete multiple rows with one delete statement in ms sql server?

1071

What is bcp? When does it used?

1037

How much is a sql server license?

1008

How to use column default values in insert statements in ms sql server?

1089

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

1249

How to set the current database in ms sql server?

1136

What is the difference between index seek vs. Index scan?

1062

Explain having clause and where clause?

1091

What are the advantages of the mirroring?

1146

Explain the truncate command? : SQL Server Architecture

1227

in the physical file layout, where should the transaction log be stored in relation to the data file?

1038

What is the purpose of indexing?

1090

How can sql server instances be hidden? : sql server security

1212

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