DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

2 Answers   ADP,

---

How to provide values to stored procedure parameters in ms sql server?

0 Answers  

---

What is change data capture (cdc) in sql server 2008?

0 Answers  

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers  

---

What is use of @@ spid in sql server?

0 Answers  

---

---

Explain user defined functions?

0 Answers  

---

Which system table contains information on constraints on all the tables created?

2 Answers  

---

wat new abt truncate in sql server

2 Answers   HCL, HP,

---

What are mdf,ndf,ldf files and how to see the data in those files?

6 Answers   Accenture,

---

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers   Microsoft,

---

Can you tell me the difference between DELETE & TRUNCATE commands?

15 Answers  

---

What is the difference between SQL notification and SQL invalidation?

0 Answers   MindCracker,

---