I was using SQL Server Profiler on a SQL Server 2005 Enterprise Edition looking for performance culprits, when I stumbled upon this very long running process.
I think this must be a world record. 
This statement has only used 16 milliseconds of CPU but it has been running for more than 500.000 years!
Anders Lybecker is an chief architect at Kring Development A/S, a consultancy firm in Copenhagen, Denmark.
He holds a degree in software engineering specializing in software development.
His primary expertises are the Microsoft .Net framework and SQL Server which he has been working with since the start of this century!
He enjoys discussing technical topics, teaching and speaking at conferences. Related posts:
Tags: SQL Server