Another Successful Corruption Repair
Today I finished another corruption repair. This time on a SQL Express database. What made the repair interesting was that they not only had corruption,… Read More »Another Successful Corruption Repair
2020
Query Tuning 2 hour Run Time To 53 Seconds
One of my favorite SQL Server jobs is query tuning, especially on those really long running SQL queries. Today I had the opportunity with one… Read More »Query Tuning 2 hour Run Time To 53 Seconds
SQL DB Recovery
At Stedman Solutions, LLC we regularly do SQL Database recovery and repair, on broken and corrupt databases. We can do database corruption repair and recovery… Read More »SQL DB Recovery
Recent Posts at SteveStedman.com
Here are some of the recent posts at SteveStedman.com. Enjoy! July is JSON and XML monthJuly 2, 2020 I have decided that for the month… Read More »Recent Posts at SteveStedman.com
SQL Mentoring Help
How I can help? At Stedman Solutions we have a SQL Mentoring package, it is almost what you could call a micro consulting offering. There… Read More »SQL Mentoring Help
REPAIR_ALLOW_DATA_LOSS Example
If you have heard me present on database corruption and repair, you’ve likely heard me vent about how damaging REPAIR_ALLOW_DATA_LOSS can be. Please schedule a… Read More »REPAIR_ALLOW_DATA_LOSS Example
Another Successful Corruption Repair
Recently we had another successful corruption repair, here is what the client had to say after the repair was complete. We were having trouble with… Read More »Another Successful Corruption Repair
Clustered Index vs Nonclustered Index
Clustered Index vs Nonclustered Index: A guide to understanding the Difference. When it comes to SQL Server performance optimization, understanding indexes is critical. Two key… Read More »Clustered Index vs Nonclustered Index
5 year Anniversary of the Database Corruption Challenge
In 2015, around the time I started Stedman Solutions LLC, I created the Database Corruption Challenge as a way to share knowledge of how to repair corrupt… Read More »5 year Anniversary of the Database Corruption Challenge
Open for Business
Stedman Solutions, LLC is open for business during the Covid-19 pandemic and growing our team. This week the Stedman Solutions team grew by adding our… Read More »Open for Business