quote:

---

- So what it is? Bad application/database design? Is there a way to correct this?

Some MS SQL options?

---

quote:

---

2Allen_Cui:

quote:

---

How much memory SQL Server uses from Task Manager? Task manager wouldn't give your...

If RowStamp is a unique incrementing value (e.g. has the identity property), why not just something like this?

SELECT s.WONum, s.Status, s.ChangeDate

FROM WOStatus s JOIN

(SELECT WONum, MAX(RowStamp)...

If you are trying to learn about cursors, here is an example of what you describe:

SET NOCOUNT ON

DECLARE @OrderNo int, @Desc varchar(30)

DECLARE @LastOrdNo int, @NewDesc varchar(2000)

DECLARE...

quote:

---

quote:

---

Perhaps something like this?

SELECT c.Item_No, c.Item_YesNo, c.Item_Date

FROM CheckList c JOIN

(SELECT...

quote:

---

Hi Gunther,

When using mem tables with large amount of rows, I suspect that SQL starts dumping them to disk.

I tried the differences...

quote:

---

I have used bitmaps in a few cases, but like most of the comments here, the relational approach is the way to...

quote:

---

I created my own SP to capture the DB size by copying the codes in sp_SpaceUsed. Hope it works on you!...

quote:

---

Ok, I finally got it to create Backups locally. I had to Right-Click on the Database and Choose "All Tasks..." then...

How about backup/restore?

--Jonathan

quote:

---

Try xp_msver to get information about the server. This however will not tell how much ram is currently being used.