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 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...
Nov 4, 2010 | Backup, SQL Server 2008, SQL Server Internals, SQLServerPedia Syndication |
I got asked a question today that I though was quite interesting. If my backup starts at 6pm and it runs for say 30 minutes what happens to the transactions that occur during the 30 minutes that the backup is running? The short answer: All committed transactions that...
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...
Oct 12, 2010 | Recovery, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server Internals |
A SQL Server database can be in one of three recovery models. FULL, BULK_LOGGED and SIMPLE. The recovery model you choose for your databases will affect your restore plans in the event of failure or need to restore, the recovery model you pick will also...
Sep 10, 2010 | Powershell, SQL Server 2008, SQL Server 2008 R2, SQL Server Internals, SQLServerPedia Syndication |
Someone who I follow on twitter posted a tweet recently with a link to a free eBook on PowerShell. I have forgotten who posted the link, sorry. I followed the link and downloaded the book. I have been ‘learning’ PowerShell for a little while, from various...
