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?

1124

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

1064

How to provide default values to stored procedure parameters?

1060

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

1075

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

1043

Where to find ntwdblib.dll version 2000.80.194.0?

956

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

1138

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

1099

How to turn on the mssql api module in php?

1067

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

1059

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

1119

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

1258

Does index speed up select statements?

1010

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

1004

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

964

Un-Answered Questions { SQL Server }

What is the difference between having clause and where clause in sql server?

1090

Explain user defined views?

952

List the advantages of using stored procedures?

1044

What is an etl file?

949

What do you mean by acid?

984

What is the function of sql server agent windows service?

1081

How to list all columns in a table using odbc_columns()?

971

What is nolock hint in sql server 2008

1113

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1128

When would you use a before or after trigger?

902

What are sql server procedures?

967

You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

121

What is a view in sql?

971

What is the difference between function and stored procedure in sql server?

1056

What is TDS(Tabular Data Stream) Gateway?

121

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