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 9019

how to find maximum identity number in a table ?

JPMorgan Chase, Thomson Reuters, Wipro,

2 13056

what is Covering Index ?

Thomson Reuters,

3 7266

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,

2035

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

TCS,

1 6698

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

2 5697

how to delete duplicate rows in sql server2005

Cisco, CTS, HCL, IBM,

7 13493

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 11733

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,

2953

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.

1848

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 8331

Un-Answered Questions { SQL Server }

Explain about the command-line tool SQLCMD?

1088

How to provide login information for a new odbc dsn?

1052

Name few endpoints exposed by ssrs 2012?

355

What are the different acid properties?

1066

What is recompile sql server?

1038

How do clustered indexes store data?

1106

What are the parts of a function?

942

Explain transaction server explicit transaction?

930

How to create dbo table in sql server?

951

What is CTE in SQL

945

How do I know if localdb is running?

953

How do you create a clustered index?

1056

What do you mean by data manipulation language?

1017

What is the syntax to execute the sys.dm_db_missing_index_details?

1028

What is compound operators?

1058

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