derekr 43208 (5/23/2012)

---

Lynn Pettis (5/23/2012)

---

Your query:

select

*

from

T1 TT

where

exists (select

...

I think this is what he was after.

select

*,

case IsActive when 0 then cast(Cnt as varchar(10)) else 'N/A' end as InActiveCnt,

...

Well, that is step one.

Please read the second article I reference below in my signature block regarding performance problems. We need the DDL of the tables including indexes, the...

Nope, still not able...

ARRGGGGG!!!!! Why won't he just go away!

CELKO (5/23/2012)

---

Thanks for the DDL, but it has errors. Tables need keys and you wrote needless dialect, and no semi-colons. Try this, using current T-SQL instead of the old Sybase...

If you append to the same file every...

Anyone else noticing a sudden concern over the size of database backup files?

Gopi Krishnan-468302 (5/23/2012)

---

Following is the snapshot of differnential backups in one of our production servers. As you can see size of diff backup has gone to 100 MB and again...

This value, 2.35944361387577E-315, maybe zero in the stored procedure and that is why the update doesn't occur.

What you may be seeing is a conversion issue between decimal(money) and float data...

Based on what you have provided, no idea. We can't see from here what you see there. Just not enough information to tell you.

If I was at your...

May be nothing, but just for giggles (and no, I don't know who giggles is), try changing the data types from money to decimal(20,4) (just to give values).

Based on what has been provided, nope. We can't see from here what you see there.

Have you tried running these same queries to see what you get and to...

michael vessey (5/23/2012)

---

ahem.... the tester didn't put the defect there (the...

The following ran about 1 second on my computer, ymmv.

CREATE TABLE dbo.fooTable (data VARCHAR(8000) );

GO

WITH

e1(n) AS (SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1...