It is impossible for a page to be shared between two tables. Pages will only ever contain rows from a single table.

Can you post definitions and index definitions of...

If the IO subsystem has...

Interesting.

What I suggest is that you go through all of the attributes in sys.dm_exec_plan_attributes, one of the columns in there is 'is_cache_key'. If any attributes with that column = 1...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic932919-391-1.aspx

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic932919-391-1.aspx

Deb Anderson (6/4/2010)

---

Everything I've read says that when I do a backup with checksum, it will read each page. I do daily differential backups (which will touch all the...

What does this return? Should be safe to post, there's no info on the query or plan anywhere in there.

SELECT cp.plan_handle, cp.cacheobjtype, cp.refcounts, cp.usecounts,

pa.attribute, pa.value

FROM sys.dm_exec_cached_plans cp

CROSS APPLY sys.dm_exec_plan_attributes(cp.plan_handle)...

Edit: On second thoughts....

Nope. There's no concatenation of user-inputted values directly into the string, so that's pretty safe as you've done it.

Just one small point, you don't...

Are all 12 plan handles different?

Could you perhaps attach the results as an excel sheet? Without seeing results, hard to tell you why there are multiple rows. Can you also...

But it's not being...

Be careful. The minimum acceptable frequency of CheckDB should be influenced by the retention period of your backups. The idea is that checkDB should run often enough that, should it...

Page verification is not a replacement for checkDB, it's not going to safely allow you to reduce the frequency of CheckDB. Something still needs to read the pages and check...

Bhuvnesh (6/4/2010)

---

Nils Gustav Stråbø (6/3/2010)

---

Set "max server memory" to a specific value that leaves some memory to the OS and other processes running on the server. I usually leave 2...

mchofman (6/4/2010)

---

it is indeed a good idea to backup the logs more frequently, but when the logs grows over 60% between two backups it is a good idea to make...