Browse by Tags

• Design
• Events
• Personal
• SQL Server 2005
• SQL Server 2008

• Auto update statistics and auto create statistics - should you leave them on and/or turn them on??

  YES!!! OK, well, I guess I should be more specific because as in most things in SQL Server, the real answer is "it depends". And for these two options, it depends mostly on your SQL Server version. Since SQL Server 7.0, the way that auto update works, Read More... Posted Monday, August 25, 2008 5:12 AM from Kimberly L. Tripp: Improving *my* SQL skills through your questions! | (Comments Off) Filed under: indexes, SQL Server 2008, tips, SQL Server 2005

• SQL Server 2008 fails to send database mail, Sparse columns with filtered indexes, Upcoming Events, and - as usual - catching up (i.e. cookies)!

  OK, so, I don't blog very often. I don't know what it is... I think it's that I feel like I always need to blog huge posts and the thought of writing my huge post makes me not want to blog... so, sometimes my time-between-blogging (TBB :) is long. I'm Read More... Posted Monday, August 25, 2008 3:27 AM from Kimberly L. Tripp: Improving *my* SQL skills through your questions! | (Comments Off) Filed under: Events, Personal, indexes, SQL Server 2008, tips, Design