Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
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 Administration

Database Administration

1-20 of 73     Previous     Next
Suppress Errors When Duplicate Data Is Inserted in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - See how to use INSERT IGNORE in MySQL for cases in which ignoring duplicates might be useful.
A Handy Delete Stored Procedure
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Ensure that your data is safe when you make use of Transactions to do any data manipulation with this sample stored procedure.
Identifying all the Index(s) Available on a Table in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn a way to increase performance in MySQL.
Create a Snapshot of Your Database
by Hannes du Preez
Language: SQL, Level: Intermediate: - Use this code to create a snapshot of your current database.
Identify Tables Without an Identity Column
by Hannes du Preez
Language: SQL, Level: Beginner: - This query will enable you to list all the tables in your database that don't have an IDENTITY column.
Get the Total Number of Rows for Each Table in Your Database
by Hannes du Preez
Language: SQL, Level: Beginner: - Use the following query to get the total number of rows for each table in your database
Knowing the Version and Supported Engines in MySQL
by M S Sridhar
Language: SQL, Level: Intermediate: - These commands are handy to find out the current version and supported engines in the MySQL.
Purging Binary Logs in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Stay out of trouble regarding reaching maximum disk space by purging old logs in MySQL when they are no longer needed.
Making a Column Autoincrement the Value Itself in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to make a column auto-increment the value every time a record is inserted in that table.
Check if a Primary Key Exists on a Table
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn how to check whether a Primary Key is missing, and if so, add it.
Updating a Column with the Current Time Stamp in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate Learn how to add the current time from the database when updating a column.
Identifying Unused Tables with T-SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn how to easily identify unused Tables.
Identify Tables with Large Column Counts
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Check out this simple way to identify tables with a large number of columns.
Find Out the Column Name Using the COL_NAME() Function
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Use this code snippet to quickly find out a column's name.
Using the Replace Command in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - The REPLACE command behaves as INSERT when there is no record matching the constraints.
The sp_spaceused Procedure in SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - See an example of how to use the sp_spaceused special SQL procedure.
Merge Two DataTables, Preserving the Old Values
by Srinath M S
Language: .NET, Expertise: Beginner - Learn how to maintain all the old values when merging two databases.
Turn Off the Index Maintenance of DataTable when you Load Data
by Srinath M S
Language: .NET, Expertise: Intermediate - Learn how to turn indexing on and off when loading data.
Encrypting and Decrypting a Database Connection String
by Hannes du Preez
Language: .NET, Expertise: Intermediate — Learn to encrypt your connection string to a database
Using the SET NOCOUNT SQL Method
by Hannes du Preez
Language: SQL, Expertise: Beginner — Learn how to use the NOCOUNT method to switch off the DONE_IN_PROC messages and boost the performance of queries and network traffic.
1-20 of 73     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date