"Timeout expired" in SQL Server 2005

If you are running a query that needs to make changes to quite a few rows within a database (in my case 8700 rows). You might get an error exception pop up which says the following:

"Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding."

After some investigating I found that there are two ways to overcome this error:

1) Use Database Engine Query (or formally known as Query Analyser) to run your query instead of using SQL Panel in table view. I think that the SQL Query panel within table view is only used for smaller query operations. Thats just my guess because it didn't work for me. When using Database Engine query there is pretty much no limit to the amount of data you need.

2) Override connection timeout in SQL Server Options:


I found an option to change the timeout limit in the least place I expected. Under the "Designers" selection within SQL Server Options you will be able to change the timeout amount. But you cannot uncheck the override amount, you will have to specify the amount of seconds you require. 

Windows Disk Cleanup Alternative

To keep a PC running smoothly, regular maintenance is critical. Many users shy away from maintenance tasks, thinking it is a long, drawn out manual affair, but the Disk Cleanup Utility can easily determine which files on a hard drive may no longer be needed and delete those files. In addition to freeing up potentially significant amounts of hard drive space, using a Disk Cleanup on a regular basis can significantly improve system performance.

I have always used Microsoft Windows Disk Cleanup and I was interested in seeing if there were any free software that could do a better job. After trawling through the net I was surprised to find how many programs claim to help you get back your PC into original working condition by removing all the clutter. Just as I expected most of the Disk Cleaning utilities were not free. But I did find one cleanup utility that fitted the mark quite nicely called Cleanup (well what else would it be called Tongue out!). 

CleanUp is a powerful and easy-to-use application that removes temporary files created while surfing the web, empties the Recycle Bin, deletes files from your temporary folders and more. It frees disk space and reduces the "clutter" on your computer helping it to run more efficiently. It also can be used as a way to protect your privacy on the Internet. You can even instruct CleanUp to securely delete files making it impossible to retrieve their contents using lower-level disk tools - just another way of protecting your privacy.

You can download the program here.

WARNING!: This program is a really thorough piece of kit because it can even delete your Bookmarks if you have not selected the right options:

 

Cleanup Options