Answer / guest

Indexes improve database performance by allowing faster retrieval of records.
Types of indexes:
• Clustered Index – Reorders table records for faster access.
• Non-Clustered Index – Stores index separately for faster lookups.
• Unique Index – Ensures all values in a column are unique.

What does the on delete cascade option do?

0 Answers  

---

Can we execute a stored procedure inside a trigger?

6 Answers   BirlaSoft, CarrizalSoft Technologies, United Healthcare,

---

Explain about SQL server 2005?

0 Answers  

---

What are the advantages of partitioning?

0 Answers  

---

How will you collect the date from current date to last older 6 days date in sql server 2005

4 Answers  

---

what is difference between NULL and ISNULL in SQL Server 2008?

0 Answers   MCN Solutions,

---

Explain syntax for viewing, dropping and disabling triggers?

0 Answers  

---

Do you know what is sql service broker?

0 Answers  

---

What is a Lock and let me know Different types of locks?

2 Answers  

---

What are the different types of queries?

1 Answers  

---

Explain the stored procedure?

0 Answers  

---

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

0 Answers  

---