Dec 20, 2010 | Index, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server Internals |
This is kind of a follow up to a post I published last week regarding autogrowth. A forum poster said they had turned on AutoGrow and they were using autogrow as way of managing the growth of their databases – No! This post titled “Should I have AutoGrowth enabled on...
Dec 18, 2010 | SQL Server 2005, SQLServerPedia Syndication |
Steve Jones mentioned recently that SP4 for SQL Server 2005 is on its way because Microsoft closed his connect item. Well looks like it was released yesterday, you can download it here:...
Dec 17, 2010 | Database Books, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server Blog |
Last Friday I posted a short note on what books I have read this year past, so this Friday keeping up with the same theme and the fact we are quickly approaching the end of the year I thought I would write a post on what books I want to read next year: SQL...
Dec 15, 2010 | SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server Internals |
I was reading a few forum posts yesterday where a few people were complaining that the transaction log had grown during index maintenance and they were asking: If they should have autogrowth enabled?If they should restrict the size of the file?I think autogrowth...
Dec 10, 2010 | books, SQL Server 2005, SQL Server 2008 |
This is just a short post for a Friday. This is my list of the Top 3 SQL Server books from the year[ish]: SQL Server MVP Deep Dives Microsoft SQL Server 2008 Internals (Pro – Developer) Professional SQL Server 2008 Internals and Troubleshooting Granted some of...
Oct 12, 2010 | Recovery, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server Internals, TSQL Tuesday |
I haven’t written a post for a TSQL Tuesday for a little while and I know that I’m late getting this one out too. This month’s party is being hosted by Sankar Reddy This topic I think, maybe expect, really I know, that this topic has been covered already, I know...
