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 find the login name linked to a given user name?

954

How to rename databases in ms sql server?

1133

How to select all columns of all rows from a table with a select statement in ms sql server?

1051

How to create a dml trigger using create trigger statements?

981

How to set database to be read_only in ms sql server?

964

What is the simplest way to create a new database in ms sql server?

970

How to connect ms access to sql servers through odbc?

977

How to add an address record into adventureworkslt?

941

How to select some specific rows from a table in ms sql server?

969

How to create a new schema in a database?

1078

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

925

How to define the name and server for a new dsn?

1025

How to create a trigger for insert only?

996

How to delete a login name in ms sql server?

1013

What are the differences between decimal and float in ms sql server?

1138

Un-Answered Questions { SQL Server }

What is the recovery model?

942

Explain different types of locks in sql server.

1024

Define Business Edition in SQL Azure?

100

How do I trace a query in sql server?

907

Which rendering formats are affected by the pagesize properties?

138

Explain the different index configurations a table can have?

896

Explain Reporting Life Cycle?

116

What is trace flag in sql server?

979

What is dirty read?

1047

How to test values returned by a subquery with the in operator?

1142

Explain about service Broker functions?

993

What is checkpoint in sql server?

1070

How to replace null values in expressions using isnull()?

1058

Explain transaction server explicit transaction?

890

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1082

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