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 4784

CTE(common table expression)

Thomson Reuters,

1 9013

how to find maximum identity number in a table ?

JPMorgan Chase, Thomson Reuters, Wipro,

2 13036

what is Covering Index ?

Thomson Reuters,

3 7250

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,

2226

Diffrences between sql server 2000 vs 2008

TCS,

2030

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

TCS,

1 6687

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

2 5684

how to delete duplicate rows in sql server2005

Cisco, CTS, HCL, IBM,

7 13463

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

1 3588

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

Infosys, Value Labs,

6 11722

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,

2948

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.

1846

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 4807

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

Ness Technologies,

3 8318

Un-Answered Questions { SQL Server }

How you can get a list of all the table constraints in a database?

952

What are the common performance issues in sql server?

920

How to assign null values to variables or columns?

969

What is the difference between clustered and non-clustered indexes in ms sql server?

995

What are different types of statement?

1008

Can you explain various data region available in ssrs with their use?

969

How do I know if localdb is running?

942

Tell me extended events in sql server 2008?

992

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

897

What are the different subsets of sql?

1547

Can we use where and having clause together?

1038

What is the cartesian product of the table?

950

What is an expression in ms sql server?

1067

How to delete a database in ms sql server?

1225

What is the use of sign function?

1114

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