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];...
Continue reading...Tutorials
Create network drive using ssh to window env.
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...
Continue reading...How to fix Winrar corrupted files
You downloaded all the files and now WinRar says that the files are corrupted and / or wrong password error. How to solve this?
Continue reading...Increase speed by tweaking prefetcher settings
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.
Continue reading...Correcting System Hang at Startup
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...
Continue reading...Easy Way to Adjust LargeSystemCache
Right click My Computer Select Properties Click Advanced Choose Performance Click Advanced again Select either Programs or System Cache under Memory Usage.
Continue reading...Swap File Tweak
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...
Continue reading...Boot XP faster
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”...
Continue reading...HDD slowdown when booting
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...
Continue reading...Convert FAT32 To NTFS
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
Continue reading...