April Blog Post Wrap-up
by Steve Stedman and the Stedman Solutions Team Optimize For Ad-Hoc Workloads – Video Tip Tue, 27 Apr 2021 Learn how Optimize For Ad-Hoc Workloads… Read More »April Blog Post Wrap-up
Questions Following Corruption Presentation – Video
These are 5 questions asked after our February 2020 corruption presentation. Hope these answers help you as well. Transcription: 0:10Q: So our very first question… Read More »Questions Following Corruption Presentation – Video
Index Seek vs Index Scan
The question comes up when looking at an execution plan of whats the difference between an index seek and an index scan. What it really… Read More »Index Seek vs Index Scan
How to Reducing the Impact of Database Corruption – Video Tips
The Stedman Solutions team shares ways to reduce the impact of server corruption. Transcription: Steve Stedman 0:10All right. Ways to reduce impact are backups, good… Read More »How to Reducing the Impact of Database Corruption – Video Tips
Multiple CTE’s in a single Query
Common Table Expressions are a great way to simplify complex derived table queries. If it makes sense to break out one derived table or subquery… Read More »Multiple CTE’s in a single Query
Optimize For Ad Hoc Workloads
Optimizing SQL Server for Ad Hoc Workloads: A Comprehensive Guide SQL Server is a robust relational database management system designed to handle a wide range… Read More »Optimize For Ad Hoc Workloads
SQL Server Parallelism Settings – Video Tip
Cost threshold for parallelism and the max degree of parallelism ( maxdop ) are 2 important setting for your SQL Server. Find out how to… Read More »SQL Server Parallelism Settings – Video Tip
TSQL Basics: SQL Server Join Types Webinar
Join us May 11th @ 12 pm PST – Steve Stedman will teaching a FREE lesson on SQL Server Join Types. TSQL joins – what’s… Read More »TSQL Basics: SQL Server Join Types Webinar
Common Expression Tables – Introduction
Have you ever wanted to create a recursive query, but didn’t see how to do it. With the Common Table Expressions session you will learn… Read More »Common Expression Tables – Introduction
Ransomware and Database Corruption, What’s the Difference?
Steve Stedman and Derrick Bovenkamp explain the difference between ransomware and database corruption. We offer SQL server corruption repair and even Emergency repair. Generally we… Read More »Ransomware and Database Corruption, What’s the Difference?