Andrew Watson (12/17/2008)

---

Since the question states "...using the log backups", and there can't be any in Simple mode, my reasoning was that the correct answer has to be "none of...

Cool...

I'm curious, how does that checksum work?

Paul Randal (12/14/2008)

---

Hey George - I had a thought - can you try changing the setting of NUMERIC_ROUNDABORT and see if CHECKTABLE completes? If it does, you might be able...

I could be wrong here... but...

Somehow you have an index on a computed column that is guaranteed to give a arithmetic overflow error.

For an index on a computer column...

george sibbald (12/14/2008)

---

CREATE TABLE [dbo].[Observances] (

[ObservanceID] [bigint] NOT NULL ,

[ObservanceTime] [datetime] NOT NULL ,

[ObservanceType] [tinyint] NULL ,

[SecChkID] [int] NULL ,

[SensorID] [int] NOT NULL ,

[SourceID] [int] NOT NULL ,

[TargetID] [int] NOT...

henrik staun poulsen (12/9/2008)

---

Hi icocks,

Well, I've seen worse; like the programmer that loved to write "BEGIN TRAN", but forgot a few "COMMIT" or "ROLLBACK".

And this system actually works, and makes...

ramadesai108 (11/14/2008)

---

Hello All,

Now the following statement works fine but it produces number of digits to the right of the decimal:

CAST(ROUND((((t.ItmRecvdYR1 - t.ItmRecvdYR2)/(t.ItmRecvdYR1 * 1.0)) * 100),0)...

Chirag (11/11/2008)

---

ta.bu.shi.da.yu (11/11/2008)

---

Chirag (11/10/2008)

---

You do not store either credit or debit values as negative becoz u need to take these values and show them in various reports .This would need...

Lynn Pettis (11/7/2008)

---

Better question, are there...

What if SoldYR1 is 0 and SoldYR2 is a negative value?

SoldYR1 = 0

SoldYR2 = -1

Thus:

(t.SoldYR1 - t.SoldYR2)/(t.SoldYR1 * 1)

becomes:

(0-(-1))/(0 * 1)

Divide by zero.

Chirag (11/10/2008)

---

You do not store either credit or debit values as negative becoz u need to take these values and show them in various reports .This would need multiplying with...

Evidently never heard of twos compliment.

As Lynn Pettis wrote:

"Not all credits are negative. It depends if they are expenses, liabilities, or assests."

Thus it makes no sense not to...