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 4854

CTE(common table expression)

Thomson Reuters,

1 9092

how to find maximum identity number in a table ?

JPMorgan Chase, Thomson Reuters, Wipro,

2 13168

what is Covering Index ?

Thomson Reuters,

3 7397

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,

2277

Diffrences between sql server 2000 vs 2008

TCS,

2094

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

TCS,

1 6776

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

2 5786

how to delete duplicate rows in sql server2005

Cisco, CTS, HCL, IBM,

7 13704

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

1 3662

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

Infosys, Value Labs,

6 11948

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,

2997

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.

1897

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 4881

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

Ness Technologies,

3 8443

Un-Answered Questions { SQL Server }

How to automatically create a log when an exception is being received into SQL Server?

1359

What are the different index configurations a table can have?

1008

Which tcp/ip port does sql server run on? How can it be changed?

1081

What is sharding?

116

Does sql server use t sql?

1071

what data regions are and what are the different data regions?

146

What are the main differences between #temp tables and @table variables and which one is preferred?

1134

What is optimistic concurrency?

1091

What are points to remember while using the fillfactor argument?

1018

What are data resources?

963

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

1248

What is the datatype of rowid?

963

How to provide default values to function parameters?

1221

Give an example of SQL injection attack ?

1050

What are partitioned views and distributed partitioned views?

1062

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