SQL Server Interview Questions
Questions Answers Views Company eMail

what is performance tunning in sql server ? explain.

Thomson Reuters,

1 2167

CTE(common table expression)

Thomson Reuters,

1 5580

how to find maximum identity number in a table ?

Wipro, Thomson Reuters, JPMorgan Chase,

2 9684




what is Covering Index ?

Thomson Reuters,

3 4253

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,

876

Diffrences between sql server 2000 vs 2008

TCS,

770

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

TCS,

1 4019

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

2 3218




how to delete duplicate rows in sql server2005

HCL, CTS, Cisco, IBM,

7 7620

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

1 1918

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

Infosys, Value Labs,

6 6683

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,

1668

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.

605

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 2592

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

Ness Technologies,

3 5167


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

530


SQL Server Architecture ?

1080


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.

605


Why we need to use secondry database file? though, we can do same work using primary database file also.

4137


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

796






what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

4686


System variable and temporary variables

928


what is checksum in sql server.........???

339


What is data modeling and Reterminal integrity?

619


last function used in MS Access to convert sql what function will use in sql

808


Delete duplicate rows without using rowid.

135


How do use Having,Group by,Group function in SQL?

623


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

1006


Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

669


what is difference between view and Dip.

1138