SQLManager: SQL Articles(c) 1999-2005 EMS Database Management Solutions, Inc. All rights reserved.http://www.sqlmanager.net/fr/articlesSQL Articlesfr86400MySQL 5.1 partitions in practicehttp://www.sqlmanager.net/fr/articles/1318http://www.sqlmanager.net/fr/articles/1318This article explains how to test the performance of a large database with MySQL 5.1, showing the advantages of using partitions.UNIQUE Column with multiple NULL valueshttp://www.sqlmanager.net/fr/articles/1306http://www.sqlmanager.net/fr/articles/1306In this article, author illustrates how to maintain uniqueness on a column and also allow multiple NULL values...Oracle, MySQL and PostgreSQL feature comparison – Part 2http://www.sqlmanager.net/fr/articles/1280http://www.sqlmanager.net/fr/articles/1280Though the feature sets certainly differ between Oracle, Postgresql, and MySQL, most of your daily needs are met in these areas. This time around, we'll hit upon some areas where the platforms differ more significantlyA Primer on Falcon Tablespaceshttp://www.sqlmanager.net/fr/articles/1272http://www.sqlmanager.net/fr/articles/1272This article takes a quick look at how tablespaces are used within Falcon and what you can and can’t do with them.How MySQL Treats Security Vulnerabilitieshttp://www.sqlmanager.net/fr/articles/1271http://www.sqlmanager.net/fr/articles/1271The purpose of this article is to describe how MySQL has treated security vulnerabilities.Setting Up Delegation for Linked Servershttp://www.sqlmanager.net/fr/articles/1251http://www.sqlmanager.net/fr/articles/1251This article will discuss how to set up delegation on your SQL Server instances so you can use the impersonate options when setting up the security properties of linked server definitions. Oracle, MySQL and PostgreSQL feature comparison – Part 1http://www.sqlmanager.net/fr/articles/1220http://www.sqlmanager.net/fr/articles/1220This is a first article to take a look at Postgresql, MySQL, and Oracle and discover which ones do what you need.Using Non-Standard Port for SQL Serverhttp://www.sqlmanager.net/fr/articles/1209http://www.sqlmanager.net/fr/articles/1209In this article author discusses how to use different port number than 1433 and the issues he came across when setup up SQL Server 2005 to use a non-standard port numberManaging Hierarchical Data in MySQLhttp://www.sqlmanager.net/fr/articles/725http://www.sqlmanager.net/fr/articles/725Two models for dealing with hierarchical data in MySQL.A Practical Look at the MySQL Query Cachehttp://www.sqlmanager.net/fr/articles/704http://www.sqlmanager.net/fr/articles/704A quick look on how the popular database vendors implement their caching strategies...Firebird for the Database Expert: Episode 1 - Indexeshttp://www.sqlmanager.net/fr/articles/692http://www.sqlmanager.net/fr/articles/692This paper focuses on the unusual characteristics of Firebird indexes.Firebird Null Guidehttp://www.sqlmanager.net/fr/articles/691http://www.sqlmanager.net/fr/articles/691NULL behaviour and pitfalls in Firebird SQLPoint-in-Time Data Recoveryhttp://www.sqlmanager.net/fr/articles/682http://www.sqlmanager.net/fr/articles/682Binary logging will slow a server by only one percent. In return, though, it allows for up to the minute data recovery.An Overview of SQL Server 2005 for the Database Developerhttp://www.sqlmanager.net/fr/articles/655http://www.sqlmanager.net/fr/articles/655PostgreSQL Authenication with pam_ldaphttp://www.sqlmanager.net/fr/articles/654http://www.sqlmanager.net/fr/articles/654This article will discuss how to setup PostgreSQL to authenticate against an LDAP system.Choosing the Right MySQL Versionhttp://www.sqlmanager.net/fr/articles/653http://www.sqlmanager.net/fr/articles/653Which MySQL version you should use, whether you should consider upgrading, what to do when you find a bug?..MySQL 5.0 New Features: Stored Procedureshttp://www.sqlmanager.net/fr/articles/652http://www.sqlmanager.net/fr/articles/652This article shows you how to write stored procedures and shares the implementation details of Stored Procedures in MySQL 5.0.MySQL Network and Youhttp://www.sqlmanager.net/fr/articles/646http://www.sqlmanager.net/fr/articles/646MySQL Network is presented in the press. What it all means for you?SQL Constraints With PostgreSQLhttp://www.sqlmanager.net/fr/articles/636http://www.sqlmanager.net/fr/articles/636This article has covered a variety of constraints that help restrict user data within specified limits.Using PostgreSQL User-Defined Functions to solve the Tree Problemhttp://www.sqlmanager.net/fr/articles/593http://www.sqlmanager.net/fr/articles/593In this article we demonstrate how to solve the classic tree problem using PostGreSQL user-defined functions.Prepared Statementshttp://www.sqlmanager.net/fr/articles/592http://www.sqlmanager.net/fr/articles/592Benefits (and trade-offs) of the new server-side prepared statements and the support for it from various programming languages.Structure Means Subqueries: Nesting SELECTs in MySQL 4.1http://www.sqlmanager.net/fr/articles/591http://www.sqlmanager.net/fr/articles/591Subqueries are another way to get data from multiple tables using a single query, and MySQL 4.1 includes support for this standard SQL construct.New in MySQL 4.1: All the Little Featureshttp://www.sqlmanager.net/fr/articles/590http://www.sqlmanager.net/fr/articles/590We've covered the major features in 4.1, now we wrap up our 'New in 4.1' series with an article about all of the little features.Writing Secure Transact-SQLhttp://www.sqlmanager.net/fr/articles/589http://www.sqlmanager.net/fr/articles/589There are plenty of good sources of information about how to deploy SQL Server in a secure fashion.Extending InterBase with User Defined Functionshttp://www.sqlmanager.net/fr/articles/588http://www.sqlmanager.net/fr/articles/588An overview of UDF's - User Defined FunctionsPackaging SQL Procedures into iSeries Applicationshttp://www.sqlmanager.net/fr/articles/587http://www.sqlmanager.net/fr/articles/587This article explains a cost-effective way to package SQL procedures that does not require additional software.