This is duplicate post #8 for this problem. I provided an answer in another one, but it's not on my clipboard anymore and I'm not going to go searching...

The easiest way is to use SSMS. Right-click on the table, select Script Table AS -> CREATE TO -> New QUery window. Then change the table name in...

Okay this is like duplicate post #7 for this problem. I also provided an answer here. Which I would not have wasted my time with had there been...

Hopefully this is the last duplicate I find of this post. I posted an answer here. On the bright side my post count is climbing.

Duplicate post. Please post answers here. Hopefully I won't find another one.

Okay, there are a few things.

1. It would help if we had full table definitions. For example, are they separate indexes on each of the columns you list...

Duplicate post. Please post answers here

Duplicate post. Please post answers here

Duplicate post. Please post answers here

I usually don't jump in on threads that have already had several answers, but I do have a couple of comments.

Your clustered index is probably not the best candidate/design for...

emblabac (2/22/2010)

---

Well C is the first group in the list (relative to date) ... hence number 1. Similarly for B and D, they are the second and third "distinct" groups...

HowardW (2/22/2010)

---

I thought using a column in the order by that's included in the partition is irrelevent as the partitioned column by definition will be the same value for all...

Did you read the article I linked to? Setting TrustWorthy on has effects as well, so be sure that's what you really want to do.

I think you want sp_changeobjectowner

I'm not sure, but I would guess that you are missing it because you are filtering based on an application, user, or database. In a simple test I am...