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

Can a database be shrunk with users active?

1192

How you can change a cross join into an inner join?

1020

How you can add messages to the nt event log from within a stored procedure?

1134

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

1127

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

1059

Can a rule be bound to any column of any data type?

1024

can an order by clause be used in a creation of a view?

1235

Define constraints and give an example of their use?

1092

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

977

How can a user-defined datatype be created?

1036

Explain timestamp datatype?

1017

To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

1003

Can an automatic recovery be initiated by a user?

1066

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

1096

Can a table be created inside a trigger?

1012

Un-Answered Questions { SQL Server }

Explain view in sql server?

1086

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

2072

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1145

What are the different types of replication are there in sql server 2000?

1085

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1123

What is the log shipping?

1059

What is instead of trigger sql server?

1072

What are the advantages dts has over bcp?

1047

How to use go command in "sqlcmd"?

1261

Where are full-text indexes stored?

1036

Can I run multiple instances of sql server 2000 at the same time on one computer?

1118

How to enter unicode character string literals in ms sql server?

1113

What are the restrictions applicable while creating views? : SQL Server Architecture

1081

What are the steps you can take to avoid “deadlocks”?

1021

What is a View ? Can we insert, Update and delete a view?

1059

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