Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 ghost cleanup

Author  Topic 

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2011-06-14 : 02:52:49
Hi,

Today i was going through paul randauls ghost records.
http://www.sqlskills.com/blogs/paul/post/inside-the-storage-engine-ghost-cleanup-in-depth.aspx

I have two queries on this regard.

1. If the table has a clustered index then we can fix this issue by rebuiding the clustered index. This is fine. I have tested and absolutely working fine.

2. Secondly, which is my actual question, if it is a heap table or has non-clusterred or a table which has duplicate values in all columns, meaning i cannot create a clustered index on the table, the how to resolve this problem.
Also,recreating a table and loading data again can be done but if the table has dependencies then it becomes cumbersome. Am trying to test this on sql server 2005 sp3 and sql server 2008 sp1.

3. last thing, i was looking around. while reading i came accorss SNAPSHOT ISOLATION level. Does ghost cleanup appears only when a database is set snapshot isolation level or what is so special all are taking an example of snapshot isolation level and explaining a ghost cleanup scenario?

Any help would be greatly appreciated.

Thanks in advance.



GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-06-14 : 04:21:33
Asked and partially answered: http://www.sqlservercentral.com/Forums/Topic1124772-391-1.aspx

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -