Psst – My services are likely more expensive than the memory your SQL Server needs and wants. Your CIOs and Directors need to stop thinking they are buying servers and components in 2004, or even 2010. I do all sorts of consulting gigs for all different reasons, but a lot of tuning gigs and wellness [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
© 2013 Straight Path Solutions, a SQL Server Consultancy. All Rights Reserved.
Powered by WordPress. Designed by 
Recent Comments