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

what is performance tunning in sql server ? explain.

Thomson Reuters,

1 4793

CTE(common table expression)

Thomson Reuters,

1 9018

how to find maximum identity number in a table ?

JPMorgan Chase, Thomson Reuters, Wipro,

2 13051

what is Covering Index ?

Thomson Reuters,

3 7262

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

Satyam,

2236

Diffrences between sql server 2000 vs 2008

TCS,

2031

please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect syntax near the keyword 'UNIQUE'.

TCS,

1 6695

how can we know that how many users are connected in perticuler server??????

2 5696

how to delete duplicate rows in sql server2005

Cisco, CTS, HCL, IBM,

7 13492

how to insert the values in 5 table at a time with triggers . if u have any solution then co-operate me ?

1 3595

how to insert the values in 5 table at a time Using any single statement ?

Infosys, Value Labs,

6 11732

hi ..i am working as a sql dba.....now i want to learn more about t-sql..... is it possible to learn online.... plz refer any site ..thankq

IBM,

2951

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1847

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

Ness Technologies,

1 4813

What are the benefits of using stored procedures over sql statements?

Ness Technologies,

3 8330

Un-Answered Questions { SQL Server }

What is the recursive stored procedure in sql server?

1019

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

1032

Differentiate between mongodb vs. Sql server?

1095

What is table-valued sub query?

967

How to use group functions in the select clause in ms sql server?

1052

How do you delete a data source?

1007

What are the differences between char and nchar in ms sql server?

1085

What is a covering index?

983

How can we delete a table in sql server?

975

How do I find query history in sql server?

942

Explain the advantages of merge replication?

951

Explain triggers in sql?

950

you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

983

Can the query output be sorted by multiple columns in ms sql server?

980

What is temporary table in sql server? Why we use temp table?

952

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