jQuery Form Manipulation

Here’s a good site to start using jQuery on form manipulations and validations. It’s splitted it into four parts: http://www.myphpetc.com/2009/10/using-jquery-with-forms-part-1.html http://www.myphpetc.com/2009/11/using-jquery-with-forms-part-2-core.html http://www.myphpetc.com/2009/11/using-jquery-with-forms-part-3_01.html http://www.myphpetc.com/2009/12/using-jquery-with-forms-part-4.html jQuery makes it easy for us to use javascript. For more information about jquery, click here. Download jQuery 1.4.1 here.

Group by Date without Time in MSSQL

Have you ever tried counting your data per day. Lets say you have a customer service Database and you want to query all the days and how many customer service request did you get per day. If you already know the GROUP BY function then you already have an idea on how to do it. [...]

How to query table sizes of a DB in MSSQL 2005

Part of my job is to make sure that our database is optimized all the time. Sometimes you need to actually take a look of which tables in the database are causing the slow downs. This query will list all the tables of your DB as well as the number of records it has, size [...]