Blog

I have a stored procedure which returns results from an indexed view via a covering index. Usually, it runs fast (~10ms), sometimes it can run up to 8 seconds. Here’s an example random execution (note: this isn’t a slow one, but the query text is the same apart from the value passed through): declare @p2Read more