The final test query should also be

Use AdventureWorks

go

Select Count(*) As RecCount

From dbo.Contact

Where FirstName = 'Andy'

And LastName = 'Leonard'

If you run the query before executing the...

depending on how fragmented your tables the pointers on the non clustered index pages that point to where the data is on the clustered index page will be invalid and...

Hi Doug,

you're most likely getting your error because you're doing this all in one batch and SQL Server does not know about the Suspension_URL column when it's looking at the...