Answer / Greesh Kumar Sharma

{"WITH (NOLOCK)": "A hint used in SQL queries to instruct the database engine to bypass row versioning and read data without locking the rows. This can improve query performance but may lead to reading inconsistent or uncommitted data."}

How to start sql server browser service?

1 Answers  

---

What is a derived table?

1 Answers  

---

which table keeps the locking information? : Sql server administration

1 Answers  

---

What are the different types of upgrades that can be performed in sql server?

1 Answers  

---

What are extended events in sql server?

1 Answers  

---

How many instances per computer are there in sql server 2000?

1 Answers  

---

1 01 101 01010

1 Answers  

---

How you can find out if an index is useful to the optimizer?

1 Answers  

---

How to convert a unicode strings to non-unicode strings?

1 Answers  

---

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

1 Answers  

---

Write a sql query to display the current date?

1 Answers  

---

How get current date in SQL server 2000

4 Answers   Cap Gemini, Polaris,

---