Slow DELETE statement in MS SQL

Yesterday I blogged about the slow down issue we encountered in our database server the other night. Our initial solution was to re-index all affected tables but unfortunately it did not solve the problem. The second activity we conducted was to purge records from December 2005 and earlier but still the problem persist. After further analysis of the problem we found out that the slow down was due to the trigger that was firing every record insertion. The following code is the content of the trigger.

Reindex All Tables in a SQL Database

Last night, our database server experienced a dramatic slow down. We found out that the bottleneck is during SELECT statements on one of the main tables. Our initial reaction is to purge data from this tables but doing it requires approval from the system owner. While waiting for the approval, we decided to perform reindexing on all tables. Here is a small script that we used which you can run using Query Analyzer.

Unlock Restricted PDF Files With FreeMyPDF.com

Restricted PDF files prevents users from copying, editing or printing contents. I already blogged about pdfpirate.net which is a website where you can unlock restricted pdf documents. A similar website where you can do the same task is FreeMyPDF.com. It is an online utility where you can upload a PDF file and quickly remove its restrictions. The limitations: it can only supports PDFs that you can open and read, PDFs that require a password for viewing can not be unlocked using this web app.




There is no need for Sign-up and you can unlock unlimited number of PDF documents.

Unlock Restricted PDF Document With FreeMyPDF.com

For More Cool Websites Discoveries, subscribe now.

Monitor Windows System With What’s Running

The other day, one of our server strangely experienced a slow down. Strange because we cannot find the problem, CPU usage is relatively low, there is enough free memory and hard disk space, and our network connection was working fine. Practically there is no problem when you look the system from the Task Manager. So to troubleshoot and analyze the problem, we need a more detailed system monitoring tool and there is What's Running. It is a system monitor that is similar to Process Explorer but it not just show information about running processes but also about Windows services, modules, IP connections, drivers and startup items.




Here is a brief description of What's Running features.

Processes - displays running processes and find all the relevant details that you need. Get performance and resource usage data such as memory usage, processor usage and handles.
Services - shows what services are running and stopped
Modules - displays information about all dll's and exe's in use in your system
Drivers - find information about all drivers, for running drivers you can inspect the file version to find out the supplier of the driver
IP-Connections - list of what remote connections each program have and find out what applications are listening for connections
Startup - manage all your startup programs.
System information - shows system information about your computer, such as installed memory, processor, registered user, OS and OS version.

What's Running installer allows you to choose between normal installation and portable version which you can run from USB drive.

Download What's Running 3.0 via [developer website]

To stay up-to-date on Technology news, subscribe now.

Convert Videos Online for Free

Normally if you need to convert video to another format you download a converter program to do the task. With movav online, you don't need to download any software anymore because you can perform the video conversion online and its free. This web app can convert files that are uploaded from your local computer and videos that are already stored on the Internet. Currently supported online video hosting site are Youtube, Google Videos, MySpace and etc. You can upload up to 5 files limited to 10 min each and 100 Mb total size.


To convert videos online using online.movavi.com, follow these steps.
1. Go to MovAvi Online.
2. Add up to 5 video files (limited to 10 mins each and 100MB Total size).



3. Select an output format. You can also click the advanced link to show more options on the selected format.
4. Check "Merge all videos into one large movie" if you want to combine multiple videos.
5. Click Convert button to start the conversion.

For More Cool and Useful Websites, subscribe now.

Integrate Facebook Chat with Pidgin

If your using Pidgin as your unified chat client then you maybe glad to know that Pidgin can also be integrated to Facebook chat with the help of a plugin. Facebook Chat plugin for Pidgin can connect to the new Facebook Chat IM service without the need for an API key. The plugin can sign you into Facebook, grab your buddy list, send and receive messages, add or remove friends, receive notifications, show your inbox count, organize friend lists, search for Facebook friends and set your Facebook status from Pidgin program.


To use Facebook Chat plugin for Pidgin, follow these steps.
1. Download the plugin installer from Google Code.
2. Run the installer and open Pidgin.
3. From the Menu go to Accounts > Manage Accounts.
4. On the Accounts manager, click Add button to show the Add Account dialog.
5. Choose Facebook from the list of protocols as shown below.



6. Enter username and password then click Add to save the account.

If your Facebook username and password are correct then Pidgin will automatically connect to Facebook, grab your buddy list and it will appear under Facebook group. Now you can enjoy chatting with your Facebook friends without logging into Facebook website.

For More Cool Software Discoveries, subscribe now.

Comprehensive Guide to Ubuntu Linux (Karmic Koala)

Since I've started using Ubuntu 9.10 BETA as one of my OS on my dual boot system, I easily fall in-love with it. This Opensource Linux operating system which I think the best alternative to Windows is so simple and fast. If your switching from Windows then you will find Ubuntu relatively easy to learn. Although there are some advanced features that you might need help and this is what the "Ubuntu Karmic Koala Bible" want to achieve.




The Ubuntu Karmic Koala Bible discuss relevant topics for beginners from fresh installation process up to Software list for Work and Play. The content is divided into four (4) chapters which are:
1. A Fresh Install - Walk thorough to installation process
2. Preparing Your System
3. Cool Tips and Tricks
4. Superb Software List For Work and Play

The complete guide was created by MakeUseOf.com teamed up with Guvnr.com. With this guide, you can be a Ubuntu guru instantly!

Download Ubuntu Karmic Koala Bible via [MakeUseOf.com]

For More Ubuntu Linux Tips & Tricks, subscribe now.