Tag

Tips

Insert multiple record into table

In SQL, basically there are two ways to Insert data into a table; one is insert it one row per time, another way is insert multiple rows at a times. For the first method (insert one row per time) is the most common way to insert data into database that…

Get the number of row in database table

Normally to get the number of row for a particular table, where we will do is as the following query: select count(*) from Table_name Yes, you may get your result very fast if your table is very small, but if your table is more then 100k rows, then you may…

MS SQL Server – Index Optimization checklist

I believe all the DBA know that how important is “Index” in the database if you would like to optimize the database server performance. It maybe a pain for your server if you create the index wrongly. Here are some check lists on the index optimization that you should bear…

T-SQL: Concatenate something + null=null

This whole morning just spent about 1 hours+ just to try out one very simpel query on MS SQL 2005. I keeping get the null value whenever i run this query, even in my program or run directly from the MS SQL 2005 management studio. Finally I found out that…

Magento – How to display products on your home page

Recently just start to learn on one of the famous e-commerce shopping cart – Magento. But found out that is not as simple as other open source shopping cart such as osCommerce, ZenCart or even Joomla Virtual Mart. It take me about 1 – 2 days just to find out…

Paypal fee calculator

Paypal Fee Calculator is a small and simple tools for you to calculate the amount of money that you going to charge your customer if you want to transfer the finance charges to them. Paypal fee calculator available in 2 difference mode which are simple mode and advance mode. If…

Email signature SEO

A small tips for all the website owner. You may include your web blog url, web site url or RSS link in your email signture to help you in attracting some free traffic to your site. You may design the signature in HTML form with the editor tools such as…

Gmail shortcut key

Gmail are provided with the full access/navigate the webmail using your keyboard shortcut key. The keyboard shortcuts actually help you to save time by allowing your hand just stick on your keyboard. But in order to avoid to crash with your browser or system shortcut key, Gmail pre-define shortcut may…

Customize your ad unit font face in AdSense

Google AdSense official blog had announce that now the site owner can customize the font face for Google AdSense ad unit. This is a great news for all of the webmaster because now you have more flexibility when you design the ad to be place in your website. “However, you…

Interlink – Boost your search engine ranking

Some of you may not know that what is Interlink actually? This is the most easy way for you to increase the number page indexed page in Google when the Google Bot visit your page. Put it in the simple word, interlink actually is the link url within your blog.…