SQL Server Interview Questions
Questions Answers Views Company eMail

what is performance tunning in sql server ? explain.

Thomson Reuters,

1 3591

CTE(common table expression)

Thomson Reuters,

1 7747

how to find maximum identity number in a table ?

JPMorgan Chase, Thomson Reuters, Wipro,

2 11924

what is Covering Index ?

Thomson Reuters,

3 6001

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,

1706

Diffrences between sql server 2000 vs 2008

TCS,

1639

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

TCS,

1 5804

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

2 4731

how to delete duplicate rows in sql server2005

Cisco, CTS, HCL, IBM,

7 11310

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

1 2930

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

Infosys, Value Labs,

6 9835

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,

2505

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.

1408

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 4026

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

Ness Technologies,

3 7051


Un-Answered Questions { SQL Server }

Explain aggregate functions?

544


What are the advantages of partitioning?

627


How many databases Microsoft SQL server provides?

594


How to truncate the log in sql server 2012? : sql server database administration

557


What are the differences between web role and worker role?

96






You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

467


What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

585


What is SQL Server?

650


What are the difference between data mart and data warehouse? : sql server analysis services, ssas

486


How extra digits are handled with numeric data type literals?

508


Explain how dts is used to extract, transform and consolidate data?

558


Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

512


How to change the password of a login name in ms sql server?

547


Explain trigger classes i.e. Instead of and after trigger?

473


What is sql language?

538