Keith -

The trigger as written is going to give you headaches. The way it's written - you're presuming that the insert consists of only one record, which is...

Also - all current Windows versions seem to want to hold on to the install files for every update every applied to the server. IMO - you will get...

The fun part is - this kind of test can be fully automated, so that you can run an in-depth test of restoring your backup, and in-depth validation testing. ...

This may be over-simplifying it - but isn't this something profiler does for you? Just continuously record a profiler session, preferrably tuned to only what you want recorded so...

Jeff Moden (3/18/2008)

---

You can lead a horse to water... and you can make him drink... I just don't like taking a suction on the part of the horse that's necessary...

True - but now we KNOW the name is accurate...:)

srienstr (3/19/2008)

---

I'm having a hard time grasping the significance and nature of cost. Would it be accurate to say that the cost is representative of the extent to which...

Don Cooper (3/19/2008)

---

Sorry for being dense, but is my understanding correct that vardecimal would NOT have any affect on a money type field, even if it is filled with a...

Validate your theory first - does text1 have an instance of 'CD' as a value? If not - that's not it. If it's theere in the "failing table",...

Jeff Moden (3/18/2008)

---

Lynn Pettis (3/18/2008)

---

Or

SELECT

*

FROM

dbo.tblData

WHERE

MonthID between ((3 * @Quarter) - 2) and (3 * @Quarter)

If MonthID is indexed,...

It's like...

Since we're going short on details -

are we pivoting or aggregating?

Before and after sample of what you have and what you'd like would be nifty...Thanks!

Or - if you like simple...

CASE

WHEN SUM(v.PurchaseAmount) /15000 < 1 THEN 0

ELSE SUM(v.PurchaseAmount)/15000

END as 'TotalPersonalSalesCalculatedPoints'

Jeff Moden (3/18/2008)

---

I think you may have a misunderstanding of what it does... VarDecimal has nothing to do with the MONEY datatype. The only time that VarDecimal saves space...

[font="Arial Black"]Edit: I AM missing something obvious - this test is flawed (and will be left here only for the sake of the conversation)[/font] See response below (yes...