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  

---

How to get number of days in a given year?

4 Answers   ADP,

---

what is the importence of the trigger in sqlserver2000?

1 Answers   ATI,

---

Can the “if update (colname)” statement be used in a delete trigger?

0 Answers  

---

Explain the difference between functions and stored procedures in sql server?

0 Answers  

---

---

Explain multiserver query

0 Answers  

---

What are joins in sql and what are the different types of joins?

0 Answers  

---

Restore database SQL2000, SQL2012 Backup of base is created in Microsoft SQL Server 2000 - 8.00.2066, I can't restore on Microsoft SQL Server 2012 - 11.0.2100.60

3 Answers   IT Decisions,

---

What is view in sql?

0 Answers  

---

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

0 Answers   Genpact,

---

How to retrieve field values using mssql_result()?

0 Answers  

---

How to provide values to user defined function parameters?

0 Answers  

---