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 the [...]
Archive | Performance RSS feed for this section
![reports_file_database_thumb[7]](http://www.straightpathsql.com/wp-content/themes/delegate/thumb.php?src=wp-content/uploads/2010/04/reports_file_database_thumb7.png&w=100&h=100&zc=1&q=90)
Linked Server Query Running Slow?
T-SQL Tuesday #005 – Reporting For Duty
Aaron Nelson is hosting this week’s T-SQL Tuesday. His topic, like mine from last week, has a lot of ways I could go. He basically said to talk about something that has to do with reporting. I decided to take the hodgepodge approach and talk about a couple things.
Disclaimer – I am not syndicating this [...]
You Could Be Suffering Right Now
Implicit Conversions In SQL Server – 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 actually makes sense ) and he had a query that ran great when he stripped the query out of [...]
Benchmarking… Who Needs It?
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 when [...]
Worked fine in development…
How many times have you heard or uttered those words? You work hard and understand the business requirements, you try and get the logic to work to make the procedure return what was expected or update the data as expected. You do some unit tests in your environment, it may not scream but it comes [...]
Manage Your Transactions (So They Don’t Manage You – Part 2)
This is the final in a series on shrinking and transactions. You can see them all in the Shrinking & Transactions category.
In part 1, we talked about factors that affect transaction log growth. We talked about what a SQL Server transaction is and the various modes SQL interacts with a transaction (Autocommit, Implicit Transactions and Explicit [...]
Just add a join hint!
When I posted about Empirical Evidence and finding a Troubleshooting Methodology, I talked about implementing a solution just because it seemed to work. This can manifest itself in different ways. Some are alright and harmless (what your shotgun hit happened to be the right fix) and some can be dangerous and hide the real problem.
One [...]
Follow Straight Path
Recent Comments