This is more of a “what I’ve been reading” rather than a link dump from previous week’s RSS feed.
A Plea for Plain English – Tony Davis’s “A Plea for Plain English” rings home with me. Far too much writing is full of heavy, pompous words used purely to make the author feel smarter. Joseph [...]
Bonus link dump week! Since I haven’t done one of these in several weeks, some of these links go all the way back to October 29th, enjoy.
SQL Server
Suggested Max Memory Settings for SQL Server 2005/2008 – Windows Live – Ever wonder how to set up the max memory settings for SQL Server? On our production [...]
These are a day late. Sorry about that. It’s been one helluva week.
Also, November 1st marks the beginning of National Novel Writing Month. So, if you’ve had a story inside you waiting to get out, wait no further!
SQL Server
Find the complete call tree for a stored procedure – Linchi Shea shares a perl script that [...]
SQL Server
Optimizing Queries That Access Correlated datetime Columns DATE_CORRELATION_OPTIMIZATION is some good stuff. If you have an InvoiceDate column that happens to be close to the OrderDate column in a related table, and this setting is on, the compiler will generate what could be a much better optimization plan.
Difference between an index and a primary [...]