Answer / Saurendra Singh Paliwal

The NOLOCK hint (or table hint) is used to read data from a table without acquiring a shared lock, allowing other transactions to modify the same data concurrently. However, this can lead to inconsistent or dirty reads, and should be used with caution.

What is difference between oltp and olap?

1 Answers  

---

How to add code to the existing article (using improve article)?

1 Answers  

---

Explain what are sparse columns?

1 Answers  

---

What is an index in a database?

1 Answers  

---

Write a program to fetch first 10 records from a file?

1 Answers   Amdocs,

---

Explain how to maintain a fill factor in existing indexes?

1 Answers  

---

How do you clear a log file?

1 Answers  

---

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1 Answers   ADP, iSoft,

---

What is rolap and its advantage? : sql server analysis services, ssas

1 Answers  

---

How to attach adventureworkslt physical files to the server?

1 Answers  

---

System variable and temporary variables

1 Answers   Wipro,

---

when would you go for denormalization? : Sql server database administration

1 Answers  

---