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 2466     Previous     Next
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.
How to Change the Storage Engine in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to change the storage engine used in MySQL to improve application performance.
Using NUMERIC_ROUNDABORT in T-SQL
by Hannes du Preez
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
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Use this query to get all the tables with a count of their records.
Understanding What Grants a User Has in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to view what permissions a given user has been granted.
Reseed All Autonumber Fields in All Tables
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn more about a query that will allow you to reseed all auto-numbered fields.
Using the Locate Command in MySQL
by Sridhar M S
Language: MySQL, Expertise: Intermediate - Finding a particular string in a large data set can be extremely tedious. Fortunately, MySQL has a command called locate to help you find what you need.
Get the First Day of the Current Month
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn how to find the first date of the current month.
Adjusting Views to Reduce Visibility of Data in MySQL
by Sridhar M S
Language: MySQL, Expertise: Intermediate - See how to make it so that tables with sensitive information are not viewable by all.
Get All Columns in All Tables of a Specific Data Type
by Hannes du Preez
Language: SQL, Expertise: Beginner - See how to find a specific data type across all tables and columns in a database.
How to Use the Show ProcessList in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to list all of the processes that hold a valid connection to the database.
Get the Last Day of the Current Month
by Hannes du Preez
Language: SQL, Expertise: Beginner - Use this easy query to discover the last day of the current month.
Get Current Precision Level Used by Numbers in SQL Server
by Hannes du Preez
Language: SQL, Expertise: Intermediate - See how to get the current precision by executing the following command.
Rebuild All Database Indexes
by Hannes Du Preez
Language: SQL, Expertise: Intermediate - See how to rebuild all of the indexes in your database with this query.
Understanding the Behavior of the AUTO_INCREMENT Column in MySQL
by Sridhar M S
Language: MySQL, Expertise: Intermediate - Auto_Increment can be tricky to use in MySQL, learn more about how it works.
1-20 of 2466     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date