Viewing 15 posts - 32,596 through 32,610 (of 49,552 total)
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...
June 4, 2010 at 10:54 am
GilaMonster (6/4/2010)
The rebuild of all indexes (cluster and noncluster) will put checksums onto most pages. Some, like LOB pages may not be touched by rebuilds though.
If the IO subsystem has...
June 4, 2010 at 10:39 am
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...
June 4, 2010 at 10:22 am
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
June 4, 2010 at 10:08 am
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
June 4, 2010 at 10:08 am
Deb Anderson (6/4/2010)
June 4, 2010 at 9:50 am
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)...
June 4, 2010 at 9:30 am
Edit: On second thoughts....
June 4, 2010 at 9:19 am
Ray K (6/4/2010)
Is there something I'm missing?
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...
June 4, 2010 at 9:10 am
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...
June 4, 2010 at 8:40 am
Deb Anderson (6/4/2010)
so, utilizing the checksum will give me some peace of mind that the greatest source of my data corruption (i/o subsystem malfunctions) is being monitored.
But it's not being...
June 4, 2010 at 8:13 am
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...
June 4, 2010 at 7:58 am
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...
June 4, 2010 at 5:02 am
Bhuvnesh (6/4/2010)
Nils Gustav Stråbø (6/3/2010)
June 4, 2010 at 4:55 am
mchofman (6/4/2010)
June 4, 2010 at 4:46 am
Viewing 15 posts - 32,596 through 32,610 (of 49,552 total)