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.
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.aspxI 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 |
|
|
|
|