The child table will have a foreign key constraint to the parent. Do you understand why you have to delete the child rows before deleting the parent row?

It looks like there's more than one problem with Microsoft's SQL documentation. They do have a bit of it to maintain, but you'd think they would get the docs...

I know I'm a day late, but I still learned something with this one. Trace flags are not my strong suit. I don't know them off the top...

Lynn Pettis (5/15/2014)

---

I have been working and learning about SQL...

You know, I think that was a great series...

Teenager

Glad to hear it worked out for you in the end.

Something like this?

SELECT ProjectID, ProjectName, ProjectDescription

FROM tbl_Projects

WHERE (ProjectID = @ProjectNumber OR @ProjectNumber IS NULL);

Performance may be a little better firing them individually without the OR...

Sean Lange (5/14/2014)

---

I almost spit my coffee on the screen when...

Don't test with a 1,000-row table. Test with a 1,000,000-row table. Many things can run well with 1,000 rows. Testing on a 1,000,000 rows tends to expose...

Excellent question, Andy. Thanks.

Idol

If you have concerns about fragmentation, use an integer. If you need to support more rows, use a big integer. If you aren't concerned about fragmentation or storage,...

Koen Verbeeck (5/14/2014)

---

I pretty much laughed with the "I have a...

JustOffal - I'm incredibly curious about this one, too. Please post the command and the output.

Jeff - You know I'm thinking of your presentation that isn't ready yet. 😉