info4PHP.com : PHP, MySQL Hosting , HTML Books, News, Links, Free Script Directory, Codes for PHP, php tutorials mysql tutorials free php hosting, forum discussions, XML ,php manual, tips, software, applications, website, mysql tutorials, documentation, reference, PHP and MySQL hosting
   PHP Scripts   |    Add Script/Link   |    PHP 5 Manual   |    PEAR Manual   |    PHP Functions   |    Forums   |
PHP General

PHP Categories

PHP CMS

MySQL General

HTML General

Latest Computer News

Partners

About 5000 PHP Scripts For You - Our PHP Scripts Directory

Discovering the Reason for Poor Query Performance

Language: SQL, Expertise: Beginner - Explore some of the reasons why your query performance might not by up to expected speeds.

Types of Indexes that Exist in SQL

Language: SQL, Expertise: Beginner - Get an overview of the index types available in SQL.

Getting the Last ID in MySQL

Language: SQL Expertise: Intermediate - Explore how MySQL supports AUTO_INCREMENT column types when many instances require the last value that was inserted to be used in reporting.

Understand the AES Encryption Method

Learn how to understand the AES ENCRYPTION method that is supported by MySQL.

Using the WEEKOFYEAR Function in MySQL

Language: SQL, Expertise: Intermediate - Learn how to use calendar functionality in MySQL to figure out in which week a given date belongs.

T-SQL Performance Tip: Stored Procedure Names

Language: SQL, Expertise: Beginner - See why you should avoid prefixing your Stored Procedure names with sp_.

T-SQL Performance Tip: NOT IN vs NOT EXISTS

Language: SQL, Expertise: Beginner - Learn the difference between using not in and not exists in T-SQL.

Use MySQL for Calculations

Language: SQL, Expertise: Intermediate - See a few different ways to use MySQL to compute the result of a mathematical formula.

Check Whether or Not an IP Is Valid in C#

Language: .NET, Expertise: Beginner - Learn more about a short function that validates a given IP address.

User Creation and Scenarios

Language: SQL, Expertise: Intermediate - Learn more about the importance of providing a password during the user creation process itself.

T-SQL Performance Tip: The * Operator

Language: SQL, Expertise: Beginner - Learn more about why you should use explicit column names in T-SQL.

Understanding NULL in MySQL

Language: SQL, Expertise: Intermediate - See how to work with NULL in MySQL. Examine a few examples in which you might be confused with the output unless you are very comfortable using NULL.

T-SQL Performance Tip: Owner or Schema Name

Language: SQL, Expertise: Beginner - Learn more about how to improve query performance by including owner or schema name.

Using REGEX Case Sensitively

Language: SQL, Expertise: Intermediate - See how to navigate using regex case sensitively in MySQL.

T-SQL FORCEPLAN

Language: SQL, Expertise: Beginner - Learn more about what happens in the SQL Server query optimizer when Forceplan is set to on.

Understanding Checksum Table in MySQL

Language: SQL, Expertise: Intermediate - Learn how to verify if the related files/contents are not tampered with or corrupted.

Set ARITHIGNORE to On

Language: SQL, Expertise: Beginner - Learn how to control whether error messages will be returned from overflow or divide-by-zero errors occurring during a query.

Renaming a User in MySQL

Language: SQL, Expertise: Intermediate - Learn how to change a user name in MySQL, as requirements may be updated along the development process.

Explore a Few Math Functions in SQL Server

Language: SQL, Expertise: Beginner - See several math functions that can be used in T-SQL.

Setting Up a PROXY User in MySQL

Language: SQL, Expertise: Intermediate - See how to set up a proxy user that has the same permissions as the original user.

Disabling Binary Logs in MySQL

Language: SQL, Expertise: Intermediate - Sometimes there are just too many logs available to sift through efficiently. Learn how to disable the binary logs in MySQL to cut down on the clutter.

Using LOCK_TIMEOUT in SQL

Language: SQL, Expertise: Beginner - See how to specify how long a statement should wait for a lock to be released.

How to Change the Storage Engine in MySQL

Language: SQL, Expertise: Intermediate - Learn how to change the storage engine used in MySQL to improve application performance.

Using NUMERIC_ROUNDABORT in T-SQL

Language: SQL, Expertise: Beginner - Learn how to specify the level of error reporting that has been generated when an expression being rounded has caused loss of precision.

Get All the Tables with a Count of Their Records

Language: SQL, Expertise: Intermediate - Use this query to get all the tables with a count of their records.

All Computer Programming Related Books

2004-2009 info4PHP.com All rights Reserved. Privacy Policy