SQL Server Interview Questions
Questions Answers Views Company eMail

what is performance tunning in sql server ? explain.

Thomson Reuters,

1 2234

CTE(common table expression)

Thomson Reuters,

1 5738

how to find maximum identity number in a table ?

Wipro, Thomson Reuters, JPMorgan Chase,

2 9771

what is Covering Index ?

Thomson Reuters,

3 4328

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 4100

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

2 3283

how to delete duplicate rows in sql server2005

HCL, CTS, Cisco, IBM,

7 7787

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

1 1970

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

Infosys, Value Labs,

6 6798

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 2648

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

Ness Technologies,

3 5245

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

Scalability, Availability, Integration with internet, etc.)?




what is difference between view and Dip.


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail


Tell about MOM Tool(Microsoft Operator Manager)?


Call by value and call by reference in procedure and function, with NOCOPY.


Which is the best place or learning center for MS SQL?????In Bangladesh?????


optimization techinques


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }


What is the difference between NOROW and LOCKROW?


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


where the connection string store in the database


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that


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.


whats the maximum size of view state??