Browse by Tags

All Tags » SQL Server (RSS)

Never turn off "Auto create & Auto Update Statistics" by Tom Vandaele

As you all know, in SQL Server (any version actually) you have the options "Auto Create Statistics" and "Auto Update Statistics". By default this is enabled (these parameters are set to true on the model database and thus to all newly...

SQL Server 2005 Service Pack 3 released :-) by Tom Vandaele

Old news already (but since everyone was on holiday during most of December): SQL Server 2005 Service Pack 3 was released on December 15. You can download it here . Since you're downloading anyway, don't forget to download the update version of...
Filed under: ,

Auto-shrink should "NEVER" be turned on… by Tom Vandaele

Today I was searching some more information about why you should NOT use Auto-Shrink on your SQL Server databases. This primarily to prove my point to a customer . Then I bumped into this great post by Paul Randal , about never turning on Auto-Shrink...
Filed under:

SQL Server on VMware? No thanks... by Tom Vandaele

This weekend (Friday night and Saturday morning) I had to do some work for a customer of ours. I had to split up databases for SharePoint Portal 2003, so that every Top Level Site (aka Site Collection in MOSS 2007) had his very own database. This because...

IT Talks Event by Tom Vandaele

So last Saturday it was IT Talks Event Day. As everybody has probably read already on Bart's Blog , there were some infrastructural difficulties. My external hard disk, which contained the vmware server image for all the participants, failed to start...
Powered by Community Server (Commercial Edition), by Telligent Systems