Answer / Chandrakant Giri

{"index_seek_vs_scan": "Index seek is a fast method of retrieving rows from an index when the query uses an SEEK operation and specifies an exact value or range for the key column(s). In contrast, index scan reads all the pages of the index sequentially to fetch the required data. Scans are slower than seeks but may be necessary for queries that don't have a specific key value or seek criteria."}

What is view in sql?

1 Answers  

---

What is difference between commit and rollback when used in transactions?

1 Answers  

---

What are the various Isolation levels?

2 Answers   HP,

---

How to delete exactly duplicate records from a table?

1 Answers  

---

what is package configuration variable?How to change file name in folder dynamically?Plz help me

1 Answers  

---

How to change a login name in ms sql server?

1 Answers  

---

How do you find the error, how can you know the number of rows effected by last SQL statement?

1 Answers  

---

What happens if null values are involved in boolean operations?

1 Answers  

---

What are the components of dbms?

1 Answers  

---

Which one is faster delete/truncate? Why?

1 Answers   Infosys,

---

How to find the version of sql server? : sql server database administration

1 Answers  

---

Wht is the difference between stored procedure and trigger

6 Answers   HCL, TCS,

---