This past weekend I was in Madison, WI for SQLSaturday #118 and it was a fantastic event. Jes Borland ( b | t ) and her team did a great job of hosting their first SQLSaturday and I was honored to present twice. I presented a new session, DBCC Commands: The Quick and the Dangerous,…
Category Archives: CHECKDB
Details details details
Me: Hey there. You: Hey! Me: How was your day? You: Pretty good, how about yours? Me: Oh, it was interesting. Grab a beer, let me tell you about it… So, it started out with a call from a customer because they had received the error: Could not continue scan with NOLOCK due to data…
Read-only Filegroups, Page Splits/sec and Error 825
You may wonder what these three things have in common. Before you try to play Carnac the Magnificent, humor me for a quick and high-level review of each. A read-only filegroup is one from which data can only be read, not written or updated. Fairly obvious, but it’s always good to define terms. Before marking…
