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 replace given values with null using nullif()?

982

How to insert new line characters into strings?

984

How to sort query output in descending order in ms sql server?

942

How to start and end transact-sql statements?

1024

What is sqlservr.exe - process - sql server (sqlex?press)?

1104

How to get a list of all tables with "sys.tables" view in ms sql server?

1030

How to attach adventureworkslt physical files to the server?

1102

How to download and install microsoft sql server management studio express?

1032

Does the unique constraint create an index?

1054

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

1025

How to get a list of columns using the "sys.columns" view in ms sql server?

954

What is mscorsvw.exe - process - microsoft .net framework ngen?

945

How to delete an existing database user?

1013

How to rebuild all indexes on a single table?

1052

How to write a query with an inner join in ms sql server?

1040

Un-Answered Questions { SQL Server }

How can I know what locks are running on which resource?

947

How to drop existing views from a database in ms sql server?

1099

How to handle error or exception in sql?

980

Explain the Ways to improve the performance of a sql azure database?

What is the difference between coalesce() & isnull()?

1128

Which tools are available to manage SQL Azure databases and servers?

115

What are the differences between left join and inner join in sql server?

1102

What is a Join and explain its types?

1096

What does Master database contains?

1129

What is spatial and temporal data?

991

Working with TLogs

1830

What do you understand by replication in sql server?

1056

What is store procedure? When do you use?

923

How to disable triggers using "disable trigger"?

1051

What to check if a User database is locked?

1060

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