1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


SQL Server Interview Questions
Questions Answers Views Company eMail

what is performance tunning in sql server ? explain.

Thomson Reuters,

1 3605

CTE(common table expression)

Thomson Reuters,

1 7756

how to find maximum identity number in a table ?

JPMorgan Chase, Thomson Reuters, Wipro,

2 11934

what is Covering Index ?

Thomson Reuters,

3 6008

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,

1711

Diffrences between sql server 2000 vs 2008

TCS,

1643

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

TCS,

1 5815

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

 2 4742

how to delete duplicate rows in sql server2005

Cisco, CTS, HCL, IBM,

7 11323

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

 1 2939

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

Infosys, Value Labs,

6 9852

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,

2511

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.

 1416

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 4036

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

Ness Technologies,

3 7062

Un-Answered Questions { SQL Server }

What is the main purpose of having conversation group?

487

What is unique key constraint?

626

How many types of built in functions are there in sql server 2012?

480

What are “phantom rows”?

1235

how to avoid cursors? : Sql server database administration

483




What are the advantages of log shipping?

553

How to connect php with different port numbers?

546

How to create a testing table with test data in ms sql server?

545

What are the default system databases in sql server 2000?

530

Can I work with several databases simultaneously? : sql server management studio

552

What is query optimizer in sql server?

537

List the different types of joins?

560

How to create a simple table to test triggers in ms sql server?

501

How do you implement session management in SQL Server mode?

546

How can we improve performance by using SQL Server profiler?

568

For More Un-Answered { SQL Server } Questions Click Here