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?

1139

How column data types are determined in a view?

961

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

1079

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

1063

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

1001

How real and float literal values are rounded?

1157

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

1074

How to receive returning result from a query?

1124

How to download and install sql server 2005 books online?

1191

How to override dml statements with triggers?

1186

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

975

How to test odbc dsn connection settings?

1033

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

1123

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

1060

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

1001

Un-Answered Questions { SQL Server }

What does the on update no action do?

1028

Why would you use sql agent?

1263

What are user defined functions in ms sql server?

999

Explain boyce and codd normal form(bcnf)?

958

What is sql server transaction log file?

1054

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1154

Explain about service Broker functions?

1032

What is the purpose of indexing?

1044

Can a table be moved to different filegroup?

976

What are the different Topologies in which Replication can be configured?

1183

What is exporting and importing utility?

1086

How do I completely remove sql server instance?

1102

List the different types of joins?

1007

Do you know what guidelines should be followed to help minimize deadlocks?

970

what is spatial nonclustered index

992

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