View Single Post
 
Old July 18th, 2006, 11:20 AM
MythicalMe MythicalMe is offline
Authorized User
 
Join Date: May 2006
Location: , , .
Posts: 99
Thanks: 0
Thanked 1 Time in 1 Post
Default

A stipulated yes. Anytime you can let SQL server take some of the workload your application is going to perform better, however, like most applications, it depends on the specific case. One time that you might not want to use cascading delete is when a child table has two or more parents.