Tag Archives : Tutorials

Remove duplicate entry on mysql record

Remove duplicate entry on mysql record

Posted by on August 31, 2008
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...
Filed in: Blogging
1
Create network drive using ssh to window env.

Create network drive using ssh to window env.

Posted by on May 13, 2008
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...
Filed in: Blogging
1
How to fix Winrar corrupted files

How to fix Winrar corrupted files

Posted by on March 14, 2008
You downloaded all the files and now WinRar says that the files are corrupted and / or wrong password error. How to solve this?
Filed in: Blogging
20

Sponsorship

Increase speed by tweaking prefetcher settings

Increase speed by tweaking prefetcher settings

Posted by on February 15, 2008
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.
Filed in: Blogging
1
Correcting System Hang at Startup

Correcting System Hang at Startup

Posted by on February 15, 2008
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...
Filed in: Blogging
4
Easy Way to Adjust LargeSystemCache

Easy Way to Adjust LargeSystemCache

Posted by on February 15, 2008
Right click My Computer Select Properties Click Advanced Choose Performance Click Advanced again Select either Programs or System Cache under Memory Usage.
Filed in: Blogging
1
Swap File Tweak

Swap File Tweak

Posted by on February 15, 2008
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...
Filed in: Blogging
1
Boot XP faster

Boot XP faster

Posted by on February 15, 2008
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...
Filed in: Blogging
1
HDD slowdown when booting

HDD slowdown when booting

Posted by on February 15, 2008
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...
Filed in: Blogging
0

Sponsorship

Convert FAT32 To NTFS

Convert FAT32 To NTFS

Posted by on February 15, 2008
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
Filed in: Blogging
0
© 2008 Hendra Kharisma. All rights reserved.
Proudly designed by Theme Junkie.