SQL Server Interview Questions
Questions Answers Views Company eMail

what is performance tunning in sql server ? explain.

Thomson Reuters,

1 2301

CTE(common table expression)

Thomson Reuters,

1 5851

how to find maximum identity number in a table ?

Wipro, Thomson Reuters, JPMorgan Chase,

2 9827




what is Covering Index ?

Thomson Reuters,

3 4376

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,

956

Diffrences between sql server 2000 vs 2008

TCS,

845

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

TCS,

1 4162

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

2 3326




how to delete duplicate rows in sql server2005

HCL, CTS, Cisco, IBM,

7 7887

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

1 2003

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

Infosys, Value Labs,

6 6884

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,

1746

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.

678

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 2691

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

Ness Technologies,

3 5303


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

How you trouble shoot when any job fails

701


How much memory that we are using in Logshipping Concept?

725


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

690


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1365


What are the dis_advantages of stored procedures, triggers, indexes?

982






How to restore performance issues and how to check?

861


System variable and temporary variables

994


what is the sql equivaent of the dataset relation object ?

855


what is difference between view and Dip.

1225


What is RMS migrations?

970


If the job running very slow what is the action you do

730


Delete duplicate rows without using rowid.

209


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

629


New concepts of sql server 2005 use in your project.

1246


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

793