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

Satyam,

924

Diffrences between sql server 2000 vs 2008

TCS,

814

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

TCS,

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

IBM,

1715

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.

649

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.)?

1627


OPTIMIZATION OF SP,CURSOR,TRIGGERS

1499


what is difference between view and Dip.

1182


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

1132


Tell about MOM Tool(Microsoft Operator Manager)?

668






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

134


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

864


optimization techinques

1306


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., }

1048


What is the difference between NOROW and LOCKROW?

1256


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

865


where the connection string store in the database

808


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

662


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.

697


whats the maximum size of view state??

932