Sankar Reddy, SQL Server Developer/DBA

This post is participating in T-SQL Tuesday #005 hosted by Aaron Nelson (@sqlvariant). This is an exciting recurring blog post party invented by Adam Machanic (@adammachanic) few months ago, which gives good exposure to budding blog writers and happy to participate.

Problem

Although I don’t remember who asked this question in the forums but the user was surprised . . . → Read More: T-SQL Tuesday #005 : Who put my database offline?

Update: This post is participating in the 4th installment of the T-SQL Tuesday hosted this time by Mike Walsh.

One of the side affects of having Heaps in a system is the possibility of generating forwarded records. When reading data from a heap, Forwarded records (if they are present in a heap) can generate extra, random and . . . → Read More: How can I tell if a SQL Server system is affected by Forwarded records?

This post is participating in Adam Machanic’s new invention and exciting blog party tradition in SQL Server community known as T-SQL Tuesday. Here is my second story for T-SQL Tuesday #002: A Puzzling Situation as I didn’t get to participate for the first one.

This particular issue happened to me last year and its worth sharing with . . . → Read More: T-SQL Tuesday #002 : A Puzzling Situation [2]