Books...

From Books Online:

If there is more than 16 GB of physical memory available on a computer, the operating system requires 2 GB of virtual address space for system purposes and...

No way to answer that. Depends on IO throughput, concurrent load and a few other things.

Restore a backup to a dev server, try an index rebuild there. That gives you...

Page splits don't roll back.

Also, while table variables ignore user transaction rollbacks, statements will still automatically roll back in the case of an error

Yup, and it does that whether it's column IN (1,2,3) or 1 IN (Col1, Col2, Col3)

Lowell (1/11/2013)

---

maybe he's confusing a virtual page with a server side trace and the possibility of a log file that has no limitations on the size or number of...

For table ABC, probably. Not going to do much for the operations against XYZ of course.

Ask him for a reference or article on this 'virtual file' so that you can learn more about it, seeing as you'd never heard of such a thing. Or straight...

You can't have a column in the key and include. One or the other.

Given the predicates, switch the order of the key columns, it's not efficient for that query as...

AndrewSQLDBA (1/11/2013)

---

I would like to get suggestions or advice on how I can re-write this to be so much better performing. Not having to seek the entire table all those...

zi (1/11/2013)

---

Thank you very much, I got it mostly

If I want to stop restoring at a certain log file. what should I do to finish

what I mean is to change...

Almost, on a few occasions. I've had cases where people quote that site to prove...

Triggers don't create any form of file, virtual...

This would allow SQL to use no more than 3GB of memory, as enabling AWE required the PAE switch to be on

3. /PAE + /3GB...

Please note: year old thread.