When I have very lot of duplicate entry in my database, I searching on the net about how to eliminate unnecessary entry on my Database. Here’s the magic command I found on the net. CREATE TABLE new_table AS SELECT * FROM old_table WHERE 1 GROUP BY [COLUMN TO remove duplicates BY]; Many thanks to Justin for this great magic trick Extend This Post Reach Read More →

OK. Before I start on this one, I’m stating for the record that I’m posting this as much so I don’t have to find it again as anything. However, given the number of places online that I found this question asked, but not answered, I hope it proves useful to the folks who’ve been looking for it. Extend This Post Reach Read More →

You downloaded all the files and now WinRar says that the files are corrupted and / or wrong password error. How to solve this? Extend This Post Reach Read More →

This is an unique technique for XP, which could improve the performance significantly by tweaking the prefetcher. Recommended hardware: PIII 800 or higher, 512M RAM or more. Extend This Post Reach Read More →

If your system hangs about 2 or 3 minutes at startup, where you can’t access the Start button or the Taskbar, it may be due to one specific service (Background Intelligent Transfer) running in the background. Microsoft put out a patch for this but it didn’t work for me. Here’s what you do: Extend This Post Reach Read More →

Right click My Computer Select Properties Click Advanced Choose Performance Click Advanced again Select either Programs or System Cache under Memory Usage. Extend This Post Reach Read More →

For Users with 256 MB RAM or more this tweak will boost their Windows- and Game-Performance. What it does: It tells Windows not to use any Swap File until there is really no more free RAM left. Open the System Configuration Utility by typing msconfig.exe in the RUN command. There in your System.ini you have to add “ConservativeSwapfileUsage=1″ under the Extend This Post Reach Read More →

Open notepad.exe, type “del c:\windows\prefetch\ntosboot-*.* /q” (without the quotes) & save as “ntosboot.bat” in c:\ From the Start menu, select “Run…” & type “gpedit.msc”. Double click “Windows Settings” under “Computer Configuration” and double click again on “Shutdown” in the right window. In the new window, click “add”, “Browse”, locate your “ntosboot.bat” file & click “Open”. Click “OK”,... 

If you have a 3min+ or slower boot time where Windows XP seems to sit for 2+ or so minutes with the XP logo doing nothing before everything comes to life, then do the following. Download Bootvis from Microsoft and run it the next time you boot. Do a ‘Trace’ If it shows a very long ‘HDD init’ time of minutes rather than seconds then this is how to fix it. Extend This Post Reach Read More →

To change from FAT 32 to NTFS for more stability and security, open the command prompt and type: “Convert C: /FS:NTFS”. Make sure there is a space between the C: and the foward slash (/). Once you press enter it will ask you for confirmation and press Extend This Post Reach Read More →