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 4855

CTE(common table expression)

Thomson Reuters,

1 9096

how to find maximum identity number in a table ?

JPMorgan Chase, Thomson Reuters, Wipro,

2 13177

what is Covering Index ?

Thomson Reuters,

3 7402

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,

2278

Diffrences between sql server 2000 vs 2008

TCS,

2095

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

TCS,

1 6780

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

2 5791

how to delete duplicate rows in sql server2005

Cisco, CTS, HCL, IBM,

7 13708

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

1 3667

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

Infosys, Value Labs,

6 11964

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,

3000

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.

1898

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 4885

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

Ness Technologies,

3 8449

Un-Answered Questions { SQL Server }

Do you know how to send email from database?

1049

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

1032

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1985

Explain an automatic checkpoint

1018

Explain what is the function of sql server agent windows service?

1044

What is the difference between createstatement and preparedstatement?

1002

Difference between 2NF &3NF ?

1132

How to provide default values to stored procedure parameters?

1105

What do you understand by coalesce in sql server?

1129

Explain table valued parameters in sql server? Why tvp used?

1070

How to return the second 5 rows in ms sql server?

1108

What is database architecture? : SQL Server Architecture

1101

What is the use of tempdb? What values does it hold?

1121

What are window functions in sql server?

1068

How to remove duplicate rows from table except one?

1064

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