The way to do something like that would be with at least two tables. The first table would hold the information about the person. The second table would hold relationships...

I've seen a few posts like this where the odd query or three gets messed up by the upgrade, but I've never seen any large number of procedures get messed...

Bruce W Cassidy (4/15/2009)

---

[font="Verdana"]Warning! Mini rant!

I'm reading an article (it's work related, okay?) and I run across this paragraph:

"The first and most obvious reason is that the DW appliance...

GilaMonster (4/15/2009)

---

One question that pops to mind. Did ANSI create...

If I'm reading the data correctly, the estimated rows on the 2000 query is 13 right through, but the estimated values in 2005 are all over the place, from 1...

I am confused as to why the performance is so different between the two, but the fact that performance is sub-optimal is because of the functions on the columns in...

You can use SET SHOWPLAN_ALL or SHOWPLAN_TEXT.

ALL provides more information but it's more difficult to read. Let's go with ALL despite the difficult, but you can post both.

Two things.

First, and most important, the costs displayed in execution plans are estimates. They are not accurate measures of anything. While you may or may not see a cost go...

Can you post the actual execution plan instead of the estimated one? I'd really like to see, as much as possible, what's happening.

This is a weird one. Also, can you...

Story of my life.

Here's a video on exactly how to capture the execution plans & post them to SSC.

If I were doing that particular insert, I'd use the OUTPUT clause as part of a single transaction. That will allow you to insert into the BusinessEntity table and any...

Do you see an error? Is the process waiting for a long time? Disconnected?

A little more information would sure be helpful.

If the two queries are basically identical, then I suspect it's parameter sniffing (you can look that up). First, make sure that the queries are identical (I know you said...

There are basically three ways you can do it; MAX, TOP, and ROW_NUMBER. They all work. They all don't work equally well. I wrote an article, with code examples, comparing...