Skip to main content

GENERAL

Speed Up Ubuntu 12.04 With Low Memory By Changing Swappiness

If you're running Ubuntu 12.04 Precise Pangolin on a machine with low memory you could experience issue with Ubuntu performance. It could become sluggish and slow. In this case Ubuntu accesses the hard disk often and it will impact the performance very much.

Swap partition is a separate partition on hard disk dedicated for virtual memory. The machine could slow down a lot if RAM memory recources are low.

Linux Swappiness Explained

What is swappiness

Swappiness is a property for the Linux kernel that changes the balance between swapping out runtime memory, as opposed to dropping pages from the system page cache.

Swappiness can be set to values between 0 and 100 inclusive. A low value means the kernel will try to avoid swapping as much as possible where a higher value instead will make the kernel aggressively try to use swap space.

How to Revert Back Email on Facebook

Facebook changed users' email addresses and forced them to use new emails ending with @facebook.com.

However, here are easy steps for reverting back your email address on Facebook.

Ubuntu 12.04 - GEdit Too Slow Problem

GEdit is default text editor in GNOME environment. It could be extremelly slow in Ubuntu 12.04, even on powerful machines (e.g. dual core CPU, 2GB of RAM...).

The solution is to disable File Browser plugin in GEdit.

1) Start GEdit

2) Select Edit > Preferences

3) Choose Plugins tab

4) Deselect File Browser Panel plugin

5) Close the window

SQL Server - How to Disable / Enable All Triggers

Working on a software project can be time consuming and it is useful if any task could be shortened or automatized.

If you often work on SQL Server you might come across a requirement to disable or enable all triggers in database.

Here are instructions how you can achiveve that:

Disable all triggers in database

exec sp_msforeachtable @command1 = 'ALTER TABLE [table_name] DISABLE TRIGGER ALL'

Enable all triggers in database

exec sp_msforeachtable @command1 = 'ALTER TABLE [table_name] ENABLE TRIGGER ALL'