Browse by Tags

• Internals
• SQL Programming

• Better Ways to Get Transaction Log Information

  If you've been around a while, you tend to do things the way you first learned how to do them. This can turn you into an "old timer" whose oblivious to new and better ways to do things that have appeared in the newer releases of the technology. Take measuring Read More... Posted Wednesday, November 05, 2008 2:12 PM by KKline | 6 Comments Filed under: SQL Programming, Tips, Troubleshooting

• WHY ISN'T AUTO_UPDATE STATISTICS RUNNING?

  I find that auto_update statistics in SQL Server is a really good thing. Without it, many third-party applications would simply fall over from lack of preventative maintenance. W ith it, they are able to run for extraordinarily long periods of time without Read More... Posted Monday, May 19, 2008 11:58 AM by KKline | 13 Comments Filed under: Internals, Tips, Troubleshooting