Performance

Memory Prices Changed – Have Your SQL Servers?

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 … Read more

Invitation for T-SQL Tuesday #004: IO

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

SQL Server Implicit Conversion: You Could Be Suffering Right Now

Implicit Conversion 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 … Read more

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 … Read more

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 … Read more

A Picture That Says, “Don’t Shrink!” (and other things…)

So I wrote a lot of posts around shrinking (Here, here, here). Some of my posts were turned into a wiki article on SQLServerPedia. I thought I was done posting about this but one more. I talked about why we shouldn’t do it on a regular basis. Why it should really be reserved for use … Read more