Is your SQL Server Linked Server Query running slow? Check your permissions. Maybe this is old news to you but it wasn’t for me –> It was a good day. We had finally migrated onto brand new hardware (and saw a 250% improvement in run times of most warehouse jobs). I had finally cleaned up … Read more
Yes, it is already time for T-SQL Tuesday again (well one week away, time for the invite). I have been thoroughly enjoying T-SQL Tuesday (especially the posts ones from Brad Schulz) but the fact that this is #004 means time is flying too fast lately. You Don’t Know What T-SQL Tuesday Is Yet? Adam Machanic … Read more
What some of our SQL Server consulting clients have to say about working with Mike: Mike is very knowledgeable with SQL. He has helped my company many times to get the most power out of our SQL installation. Mike also is very good at teaching others. Mike is my number one resource when it comes … Read more
Expert SQL Server Consulting Working with Straight Path Solutions for your SQL Server consulting needs ticks all the boxes with our team of SQL Server gurus, speakers, bloggers, and authors: We get it. We’ve all been in the trenches and understand how frustrating these problems can be and how much they impact your business. A … Read more
You deserve a partner who understands your data from the inside out, not just the buzzwords and trending gimmicks. Straight Path has spent fifteen plus years helping organizations keep their SQL Servers healthy, secure, and fast. It’s what built our reputation and still drives most of what we do today. Our SQL Server consulting and … Read more
SQL Server Implicit Conversion – A Silent Perf Killer I recently had the opportunity to work with a developer at the day job. He was using a loop (for what he was doing, it makes sense 🙂 ), and he had a query that ran great when he stripped the question out of the process, … Read more
All of our SQL Server instances need benchmarks! So the title is somewhat of a trick question… I hear and sense a lack of priority around taking periodic benchmarks in a system with a lot of folks. How often do you take benchmarks? Do you know what “normal” means for your system? Do you know … Read more