dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
Search the Tips
Tip Bank > Database Development

Database Development

Active Server Pages
Data Access
Database Administration
Database Apis
  ADO   ADOX   JDBC   ODBC   OLE DB   SQL-DMO
Database Tuning
DB2
Informix
MySQL
Oracle
Relational Databases
SQL
  PL/SQL   Transact-sql
Sql Server
Visual Foxpro
1-20 of 226     Previous     Next
Types of Indexes that Exist in SQL
by Hannes du Preez
Language: SQL, Expertise: Beginner - Get an overview of the index types available in SQL.
Getting the Last ID in MySQL
by M S Sridhar
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
by M S Sridhar
Learn how to understand the AES ENCRYPTION method that is supported by MySQL.
Using the WEEKOFYEAR Function in MySQL
by M S Sridhar
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
by Hannes du Preez
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
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn the difference between using not in and not exists in T-SQL.
Use MySQL for Calculations
by Sridhar MS
Language: SQL, Expertise: Intermediate - See a few different ways to use MySQL to compute the result of a mathematical formula.
User Creation and Scenarios
by M S Sridhar
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
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn more about why you should use explicit column names in T-SQL.
Understanding NULL in MySQL
by Sridhar MS
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
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn more about how to improve query performance by including owner or schema name.
Using REGEX Case Sensitively
by Srinath MS
Language: SQL, Expertise: Intermediate - See how to navigate using regex case sensitively in MySQL.
T-SQL FORCEPLAN
by Hannes du Preez
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
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to verify if the related files/contents are not tampered with or corrupted.
Set ARITHIGNORE to On
by Hannes du Preez
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
by M S Sridhar
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
by Hannes du Preez
Language: SQL, Expertise: Beginner - See several math functions that can be used in T-SQL.
Setting Up a PROXY User in MySQL
by M S Sridhar
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
by M S Sridhar
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
by Hannes du Preez
Language: SQL, Expertise: Beginner - See how to specify how long a statement should wait for a lock to be released.
1-20 of 226     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date