Mike Menser (4/9/2008)

---

Grant Fritchey (4/9/2008)

---

DonaldW (4/9/2008)

---

Mike Menser (4/9/2008)

---

DonaldW (4/9/2008)

---

It is as far as I'm concerned. If I don't tick people...

Since I knew the answer was none of the above before I even bothered to do the calculation, I strongly considered waiting until tomorrow to answer 🙂 However, I...

Linked server, or just plain publish/subscribe replication

I believe the source of this is that in Oracle (and possibly other DB's) a truncate CANNOT be rolled back. But in SQL Server, it CAN!

The reason...

Steve, does this look familiar?

http://www.pdp11.co.uk/profiles/item-enlarge.ehtml?i=93

Steve Jones - Editor (4/7/2008)

---

Hah, I worked with a disk drive you could see spinning.

Ok, it was old when I saw it, but the nuclear plant had this old computer...

Same...

select getdate()-getutcdate() will not impact the number of records. It is just going to return a time, or as I suspect you expect it to return an offset to...

FYI, that is actually the correct way to write it in Oracle also

SELECT Person.* FROM L_RPT_INV_PERSON_INFO AS Person

INNER JOIN L_RPT_INV_INFO AS Inv

ON Person.RPT_INV_ID = Inv.RPT_INV_ID

AND Person.RPT_INV_TP = Inv.RPT_INV_TP

WHERE Inv.INFORMATION_CHANGED_FLAG='Y'

Sorry...

datename...

Alkesh Khedle (3/27/2008)

---

Hi we are constantly getting deadlocks on some part of database.Can we apply Snapshot Isolation level at table level or we need to defined it on database level.Is...

Also, I have seen a performance hit of roughtly 5% OVER the normal hit that being in a transaction will give you.

I haven't found any situation where it will break code, but it won't do anything if you aren't in transactions.

ALTER DATABASE SomeDB

SET READ_COMMITTED_SNAPSHOT ON;

ALTER DATABASE SomeDB

...