Thanks for the time take to respond. I am really not looking for particular conventions but rather to solidify a list of points that should be address as an organization...

Fair enough.

I did review that thread before posting...

I love the solution for the simple example. Sadly the XML I've actually got is, i think, far to...

That works.

I created a new user and used sp_msforeachtable to deny on all table and then granted update to the couple tables that need it.

Thanks.

I did try making the...

Smarties (7/4/2012)

---

I am pretty sure you can create a new filegroup and set it as the default filegroup. This will then allow you to set the original filegroup to read...

Smarties (7/4/2012)

---

Moving the log table to a new filegroup and set the others to read only is probably the easiest option. The other way is to create a view for...

SQL Kiwi (11/13/2011)

---

Hi Karl,

On the face of it, this behaviour seems like an unsafe optimizer rewrite (i.e. a bug) because optimizer transformations should not affect the semantic. If you'd...

SQL Kiwi (11/13/2011)

---

Karl Kieninger (11/12/2011)

---

The row_order in the subquery ranks each row in ItemStatusHistory by the datetime of the Status change partitioned by the record in table Item and the...

Bugs are usually super edge cases with a lot a special requirement to hit the bug. I don't have time to waste 5 hours on thin air for you...

I do appreciate...

Again the real code, not the sanitized version in the OP.

CREATE VIEW TestHistoryRankedByTestAndStatus_Rank1 AS

SELECT h.idTest

,h.idTestStatus...

Attaching. No longer using the *, but just including StatusRank or not.

I changed the names and shortened a bit to post. The execution plans reflect my actual data. Would it have been better...

Dev (11/12/2011)

---

Can you please post the results of following?

SELECT a.idTest

,a.*

FROM vwMostRecentInstanceOfEachStatusPerTest a

INNER JOIN...

MS just told me, basically, that the only 2008 R2 edition that will run on SBS2008 is Express.