Answer / Mohd Farman

Index Seek and Index Scan are both used by SQL Server to retrieve data from an index, but they differ in their efficiency and behavior. An Index Seek occurs when the query matches the exact key of the index and retrieves only the specified rows. It is faster than Index Scan because it avoids unnecessary data retrieval. An Index Scan occurs when the query does not match the exact key of the index or there is no matching key, and SQL Server must scan the entire index to retrieve the requested data. Index Scans are slower than Index Seeks.

What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue

2 Answers   IBM,

---

What is difference between clustered index and non clustered index?

1 Answers  

---

What is difference between primary key and foreign key?

1 Answers  

---

Do you know what is similarity and difference between truncate and delete in sql?

1 Answers  

---

What is the purpose of the tempdb database?

1 Answers  

---

Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY

5 Answers   TCS,

---

What is RAID? What are the different types of RAID configurations?

1 Answers   Flextronics,

---

Explain different types of lock modes in sql server 2000?

1 Answers  

---

What is transact-sql language?

1 Answers  

---

Is natural join and equi join same?

1 Answers  

---

What is meant by Active-Passive and Active-Active clustering setup?

1 Answers  

---

Explain syntax for viewing, dropping and disabling triggers?

1 Answers  

---