Why?

The minimum unit for a read or write to/from disk is the page. The row couldn't possibly be written alone, the page headers change when a row changes.

nam.lenhat (9/15/2014)

---

The server's memory usage is increasing when querying BUT IT DOESN'T DECREASE WHEN FINISHED until I restart SQL services :|. (It reached over 70% ram memory)

Can you help me...

It's got better. Alter table replicates now. Drop table isn;t...

That's easy....

bob199214 (9/15/2014)

---

For the error message like this "Table error: Object ID 2121058592, index ID 1, partition ID 72057594038648832, alloc unit ID 72057594043629568 (type LOB data). The off-row data node at...

It's because + is both the addition operator and concatenation operator.

When you say String + Int, SQL assumes you want addition, so it does CAST(String AS INT) + INT. If...

Jack Corbett (9/15/2014)

---

I can see teh frustration coming out a bit, but I wouldn't say out of line. I'd be...

use msdb;

go

select 'exec dbo.sp_updateJob @job_name = N' + (Char(39) + name + char(39) + ',') + '@enabled = ' + CAST(enabled AS CHAR(1)) from sysjobs

Cast the integer data type column...

Out of line? (Me, I mean) http://www.sqlservercentral.com/Forums/FindPost1613791.aspx

I already answered that

GilaMonster (9/15/2014)

---

freddyism00 (9/15/2014)

---

ok, so can anybody tell me what a...

Plenty of people know what those pages are, exactly where they are, what they do, etc. There's even a book that has a full chapter on the structure of the...

Um, the data files of a SQL database. The ones that by convention have a .mdf or...

1) If you mean the default trace, yes, providing the data is still in the trace. It's 5 files of 20MB each, no more.

2) You don't.

3) When SQL restarts or...

Looks like a rather bad design too.