Database


No Image

CODING TIPS FOR PERFORMANCE IMPROVEMENT

In this post I cover most performance improvement tips related JavaScript, CSS and PHP. While working with small web application its OK to ignore these tips but whenever you are going to dealing with large web application…


No Image

Reset MD5 password using phpMyAdmin?

As you know MD5 (Message-Digest algorithm 5) is one way encryption method. In order to reset MD5 password you have to run database query. Here I have got one direct solution for resetting MD5 password…




No Image

coalesce in MySql and MSSql

COALESCE function returns first not null value from list of all arguments. If all passed arguments are NULL, COALESCE returns NULL. COALESCE has N number of arguments. It works same for both MSSql and MySql….


No Image

MySql Storage Engines

You may know about MySql storage Engine. Recently, I have taken back up of my one of site and set it up in my local machine and see there are two different storage engines with…


No Image

Sql Server Partition By Clause

This is nothing new to many. The PARTITION BY Clause is used to do partition on query result as per given category. I love PARTITION BY Clause and after reading this you may love PARTITION…


No Image

MySql import or export excel data

This is nothing new to many. We have already seen how to import or exports excel data in or from SQL Server. MySql has also ability to import or exports excel data. It is very…


No Image

Sql Server Truncate VS Delete Statement

Truncate and Delete statement used for same purpose. I.e. it’s for removing data but there are some different between both commands. TRUNCATE The TRUNCATE Statement delete all rows from a table by deallocating data pages…