SQL Server Interview Questions
Questions Answers Views Company eMail

what is performance tunning in sql server ? explain.

Thomson Reuters,

1 2124

CTE(common table expression)

Thomson Reuters,

1 5391

how to find maximum identity number in a table ?

Wipro, Thomson Reuters, JPMorgan Chase,

2 9578

what is Covering Index ?

Thomson Reuters,

3 4207

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



Diffrences between sql server 2000 vs 2008



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


1 3964

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

2 3178

how to delete duplicate rows in sql server2005

HCL, CTS, Cisco, IBM,

7 7508

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

1 1878

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

Infosys, Value Labs,

6 6619

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



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.


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 2546

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

Ness Technologies,

3 5102

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

What is Lock table in SQL?


wat wil hapn if we give the both read and deny read permission to user?


what are the critical issues you have resloved in your company


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .


Explain Capacity planning to create a database? and how to monitor it?


What is best institute to Learn DotNET And SQL in chennai?


query processing


how to use DTS package in 2000,2005,2008 in sql server


What is the difference between NOROW and LOCKROW?


which backup strategy you are following at ur company


how can you attach more than 20 ldf files in sql server


What is the difference between online clustering and Offline clustering?


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do