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?

1057

How to rename databases in ms sql server?

1256

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

1190

How to create a dml trigger using create trigger statements?

1081

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

1052

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

1049

How to connect ms access to sql servers through odbc?

1069

How to add an address record into adventureworkslt?

1027

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

1054

How to create a new schema in a database?

1205

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

1050

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

1195

How to create a trigger for insert only?

1083

How to delete a login name in ms sql server?

1125

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

1344

Un-Answered Questions { SQL Server }

How to drop an existing user defined function in ms sql server?

1063

How do I trace a query in sql server?

997

Why it is recommended to avoid referencing a floating point column in the where clause?

1010

How raid can influence database performance?

1084

What is subreport?

144

What is resource governor?

1029

How are the exceptions handled in sql server programming?

1118

Is it possible to replicate data from sql server to oracle? : sql server replication

1140

what is dbcc? : Sql server database administration

1077

Is oracle faster than sql server?

1004

How can you start sql server in different modes?

1019

What is difference between delete & truncate commands?

1140

which table keeps the locking information? : Sql server administration

1139

Your table has a large character field there are queries that use this field in their search clause what should you do?

923

Mention the differences between local and global temporary tables.

1109

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