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

Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?

1 6534

How do I compare two values when one value(data type) is char and the other is an integer?

3 8769

What are the pros and cons of creating extended stored procedures?

1 5682

Is it possible to delete duplicate rows in a table without using a temporary table ?

TCS,

12 26182

I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?

1 6723

How to Check Whether a Global Temporary Exists in a SQL Database or not?

2 8632

how to know Who Is Blocking Your SQL Server?

4 12815

How to Get the last identity value used

4 9102

How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?

1 5446

How to Run a Query on a Remote SQL Server?

2 8615

How to Generate a Series of Random Integers With T-SQL?

1 4958

What's the purpose of Stored Procedure?

Wipro,

6 18530

What is normalization?

9 13231

What is a Stored Procedure?

8 12752

Can you give an example of Stored Procedure?

Wipro,

4 11483

Un-Answered Questions { SQL Server }

How can you find out which stored procedures are recompiling?

956

What are dml triggers and types of dml triggers?

1035

What is your recommendation for a query running very slow? : sql server database administration

1113

What is self contained scalar sub query?

1022

Are connections to sql server encrypted?

1055

What is difference between aggregate and analytic function?

978

What are the types of resultset?

1018

How to insert multiple rows with a subquery?

1193

What is simple indexing method?

1088

You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

123

explain databases and sql server databases architecture? : Sql server database administration

1017

What do you mean by stored techniques? How would we use it?

1086

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

1052

What is the difference between char and varchar2 datatype in sql?

1127

What do you mean by subquery?

1154

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