Wait Stats#2: PAGEIOLATCH
PAGEIOLATCH is one of the most commonly seen wait types and basically represents the time that SQL Server had to wait while pages were being read from disk into memory. When the data pages that SQL Server needs to traverse in order to resolve a particular query are not cached, they must be read from… Read More ›
Preventing SELECT * Queries – The “I’ve Had Enough” Edition
A while back, I was talking to someone about how it was just a matter of time before I do something spectacularly wrong. That person replied with a picture of a cigar cutter saying “I keep this for that day, even though I don’t smoke. You can imagine what other things, besides cigars, it can… Read More ›
Follow My Blog
Get new content delivered directly to your inbox.
