# Steve Gray Takes on SQL Optimization

- URL: https://dynamicaccounting.net/steve-gray-takes-on-sql-optimization/
- Date: 2007-10-16
- Topics: SQL & Data
- Type: link to an external article
- Source: http://www.4penny.net/

Steve Gray of [4Penny.net](http://www.4penny.net/) gets pointed to quite a bit here. Of course, I’ve stood over Steve’s shoulder and told him what I wanted while he wrote some really complex SQL Stored Procs for Crystal Reports. I also called him to help me write the core of our daily balancing routines. So I have a lot of respect for Steve and his abilities and he’s never hauled off and hit me, despite the fact that I can be a pain. That’s always a plus.

In keeping with what is inadvertently becoming SQL week (month!?!) here at DynamicAccounting.net, Steve has a nice, easy to understand post on SQL Optimization, and links back to a much more complete post on SQL troubleshooting. All I can say is clean up your SQL now, because soon it will be year end time and upgrade time and you don’t want to be worrying about a slow SQL server then! OK, I’m off to look at my SQL server.

![](/img/blogger/16fc787e873360e4.jpg)