Why Tune Queries?

PASS, TSQL
It's just a query against the database. If things are running slow, buy some more memory, a faster CPU or get a few more disks. Right? Seriously, tuning queries is just a pain and there's no clear evidence that writing them correctly or tuning them has a major impact. Right? Yeah, I'm being facetious. I've spent a considerable portion of my career  trying to make T-SQL code run faster. The fact is, throwing moneyhardware at the performance problem can fix it in many instances. At least temporarily. But let's face it, you're constantly changing the code. There are new queries, changes to old queries, it's always changing. The code is probably the most volatile aspect of a database system because it is the easiest to change. So, you may think…
Read More