Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...



SQL Server Interview Questions
Questions Answers Views Company eMail

what is performance tunning in sql server ? explain.

Thomson Reuters,

1 2728

CTE(common table expression)

Thomson Reuters,

1 6736

how to find maximum identity number in a table ?

JPMorgan Chase, Thomson Reuters, Wipro,

2 10445

what is Covering Index ?

Thomson Reuters,

3 4925

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,

1223

Diffrences between sql server 2000 vs 2008

TCS,

1136

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

TCS,

1 4653

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

2 3770

how to delete duplicate rows in sql server2005

Cisco, CTS, HCL, IBM,

7 9099

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

1 2346

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

Infosys, Value Labs,

6 7765

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,

2075

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.

963

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 3204

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

Ness Technologies,

3 5927







Un-Answered Questions { SQL Server }

Do you know nested transaction?

111


What are the advantages of paper records?

101


Does an index slow down updates on indexed columns?

164


What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

113


Can we add a cpu to sql server?

107






What are “lost updates”?

141


What are the recovery models for a database?

157


What are the types of stored procedures in an sql server?

125


What are “phantom rows”?

779


Difference between Sql server reporting services and Crystal reports?

31


Explain activity monitors

151


How can I create a report based on a query? : sql server management studio

152


What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

166


What is dknf in normalization form?

146


Explain cursor as data base object?

153