Database Administration

1-20 of 34 Previous Next
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.
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.
Obtain the Oldest Open Transaction by Hannes du Preez Language: SQL, Expertise: Advanced - See how to determine the oldest transaction in SQL.
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.
1-20 of 34 Previous Next