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 to view existing indexes on an given table using sp_help?

1124

How column data types are determined in a view?

953

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

1070

What are the differences between char and varchar in ms sql server?

1054

How to bind a view to the schema of the underlying tables?

990

How real and float literal values are rounded?

1150

How to use subqueries with the in operators in ms sql server?

1067

How to receive returning result from a query?

1111

How to download and install sql server 2005 books online?

1173

How to override dml statements with triggers?

1172

How to create a simple table to test triggers in ms sql server?

971

How to test odbc dsn connection settings?

1015

How to find out what is the default collation in a database?

1112

How to add a new dsn with the odbc driver for sql server?

1052

How to delete all rows with truncate table statement in ms sql server?

994

Un-Answered Questions { SQL Server }

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1207

What is the command dbcc checkdb used for?

1005

how can you attach more than 20 ldf files in sql server

1992

What are the different types of backups avaialabe in sql server 2005?

1010

List types of tables in SQL Azure?

126

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

934

How many instances per computer are there in sql server 2000?

1058

Explain contrast amongst grouped and non-bunched records?

1010

What are the advantages of mirroring?

985

What are examples of triggers?

1081

List the different types of joins?

974

What is a sql join?

1010

What are the different authentication modes in sql server? How can it be changed?

1076

What is service broker? : sql server database administration

985

Is t sql the same as sql server?

958

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