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 |
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
 Posted - 2013-03-07 : 22:55:32
|
| any clues what is the difference between these Ghost_record_count vs KILL/ROLLBACK ? |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-03-09 : 05:35:11
|
| Ghost_record_count is count of Rows in the leaf level of an index that has been marked for deletion, but has not yet been deleted by the database engine.KILL/ROLLBACK - If a rollback is in progress for a specific SPID, the cmd column in the sp_who result set for that SPID will indicate KILLED/ROLLBACK.Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
|
|
|
Ghost_record_count vs KILL/ROLLBACK