1-20 of 35
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 35
Previous
Next |