<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Wayne Sheffield
»
Ghost Cleanup
31 posts, Page 1 of 4
1
2
3
4
»
»»
Ghost Cleanup
Rate Topic
Display Mode
Topic Options
Author
Message
WayneS
WayneS
Posted Monday, January 14, 2013 9:41 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 5:29 PM
Points: 6,367,
Visits: 8,226
Comments posted to this topic are about the item
Ghost Cleanup
Wayne
Microsoft Certified Master: SQL Server 2008
If you can't explain to another person how the code that you're copying from the internet works, then
DON'T USE IT
on a production system! After all,
you
will be the one supporting it!
Links:
For better assistance in answering your questions
,
How to ask a question
,
Performance Problems
,
Common date/time routines
,
CROSS-TABS and PIVOT tables Part 1
&
Part 2
,
Using APPLY Part 1
&
Part 2
,
Splitting Delimited Strings
Post #1407016
Lokesh Vij
Lokesh Vij
Posted Monday, January 14, 2013 10:04 PM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 12:58 AM
Points: 1,169,
Visits: 1,244
Thanks Wayne. Got to learn something new today
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions
Link to my Blog Post -->
www.SQLPathy.com
Follow me
@Twitter
Post #1407021
demonfox
demonfox
Posted Monday, January 14, 2013 10:18 PM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 6:46 PM
Points: 1,074,
Visits: 1,076
I got it right for wrong reasons ;
Learned something.. thanks for the question..
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one
Post #1407026
SQLRNNR
SQLRNNR
Posted Monday, January 14, 2013 11:13 PM
SSCoach
Group: General Forum Members
Last Login: 2 days ago @ 1:46 PM
Points: 18,732,
Visits: 12,329
Thanks Wayne
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1407034
okbangas
okbangas
Posted Tuesday, January 15, 2013 12:10 AM
Right there with Babe
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 3:36 AM
Points: 721,
Visits: 1,330
As far as I understand it, there is something missing from the explanation. If we assume that only what's written in the scenario has happened, the scenario is as follows:
* Table is created
* Records are inserted
* Records are deleted -> Marked as ghost
* Ghost Cleanup Task is running (every 5 seconds).
But, there has not been any scan between the marking of ghost records and Ghost Cleanup Task, hence it has nothing to do.
The ghost cleanup task doesn't just start up when it's told to – it starts up in the background every 5 seconds and looks for ghost records to cleanup. Remember that it won't be told to go cleanup a specific page by a delete operation – it's a subsequent scan that does it, if a scan happens.
http://www.sqlskills.com/blogs/paul/inside-the-storage-engine-ghost-cleanup-in-depth/
Ole Kristian Velstadbråten Bangås -
Virinco
-
Facebook
-
Twitter
Concatenating Row Values in Transact-SQL
Post #1407050
Koen Verbeeck
Koen Verbeeck
Posted Tuesday, January 15, 2013 12:35 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Yesterday @ 6:54 AM
Points: 9,364,
Visits: 6,462
Great question Wayne, thanks. Definately learned something.
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1407053
Stuart Davies
Stuart Davies
Posted Tuesday, January 15, 2013 12:49 AM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 1:19 AM
Points: 2,473,
Visits: 2,131
Good question Wayne - thanks
-------------------------------
Posting Data Etiquette - Jeff Moden
Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
Post #1407058
Carlo Romagnano
Carlo Romagnano
Posted Tuesday, January 15, 2013 1:33 AM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 2:04 AM
Points: 1,968,
Visits: 1,819
Interesting!
Thanks!
Post #1407075
sqlnaive
sqlnaive
Posted Tuesday, January 15, 2013 2:45 AM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 7:28 AM
Points: 2,637,
Visits: 1,632
Great question. I needed to know. Lost a point but worth the knowledge.
Post #1407114
Gazareth
Gazareth
Posted Tuesday, January 15, 2013 2:55 AM
UDP Broadcaster
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 6:22 AM
Points: 1,474,
Visits: 2,341
Nice question, thanks.
Post #1407117
« Prev Topic
|
Next Topic »
31 posts, Page 1 of 4
1
2
3
4
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
