What a difference a temp table makes over a table variable
I was working on performance tuning the data deletion process that I use to remove data from our database. We delete massive amounts of data on a daily basis, so our data deletion process is pretty important to us. As we’ve grown our customer base the amount of data to be deleted every day has […]
Do your servers take for ever to reboot?
One company I worked at the newer SQL Servers started taking forever to reboot the OS. The older servers didn’t take all that long. It finely dawned on us one day what it was.
Installing SQL Server 2005 SP3 or SQL Server 2008 on XP Prep SP3 can cause Bug Check
The SQL Server CSS team has just posted a blog post saying that it you install SQL Server 2005 SP3 or SQL Server 2008 on a Windows XP Machine which is pre SP 3 you can get a Bug Check (Blue Screen). If you are running Windows XP I highly recommend that you read this […]
Mirroring isn’t a backup solution
In case you live under a rock and haven’t heard about Journalspace.com‘s little mistake, they have gone out of business due to a database problem. Here’s a screenshot in case the site is down when you look at it. In a nutshell it appears that they were relying on a RAID1 array as the database […]