Daily news, white papers, tutorials and articles on databases.


The links below take you to the DevX: Latest Database Content web site. This is a free off site content service. We're not responsible for the linked content. If nothing displays below, the DevX: Latest Database Content blog or news channel is currently unavailable, please try again later.

DevX: Latest Database Content

www.DevX.com

Using the HASHBYTES Function in SQL Using the HASHBYTES Function in SQL

Wednesday, December 31, 1969 · Learn how to use the hashbytes function in SQL.

Easy One-Step Process to Rename a Table in MySQL Easy One-Step Process to Rename a Table in MySQL

Mon, 12 Nov 2018 09:50:00 +0000 · Language: SQL, Expertise: Intermediate - Learn an easy one-step process for renaming a table in MySQL.

Knowing the Sign of a Given Number in MySQL Knowing the Sign of a Given Number in MySQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Beginner - See how to learn the sign of the number for computation purposes.

Know if LIKE Results are True or False Know if LIKE Results are True or False

Mon, 05 Nov 2018 09:45:00 +0000 · Language: SQL, Expertise: Beginner - See how to know if LIKE results are true or false in MySQL.

Learn the Storage Engine Type of a Table in MySQL Learn the Storage Engine Type of a Table in MySQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - There are plenty of commands in MySQL that are supported for particular types of storage engines. Use this command to know the engine type.

Find Indices on a Table in MySQL Find Indices on a Table in MySQL

Wednesday, December 31, 1969 · Language: Enterprise, Expertise: Intermediate - Find the indices on a table in MySQL.

Adding a New Column in a Specific Position Adding a New Column in a Specific Position

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Learn how to specify the location of a new column, rather than just adding it to the end of the current table.

Get Detailed Information on Tables in MySQL Get Detailed Information on Tables in MySQL

Fri, 28 Sep 2018 09:18:00 +0000 · Language: SQL, Expertise: Intermediate - See how to get detailed information on available tables, record counts, etc., in MySQL.

Find Tables with an XML Column Find Tables with an XML Column

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - See how to find tables with an XML column.

Finding Duplicate Data Available for Multiple Records Finding Duplicate Data Available for Multiple Records

Mon, 24 Sep 2018 08:20:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how to find data available for multiple records with MySQL.

Update the Metadata of a Database Object Update the Metadata of a Database Object

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Learn how to refresh a database object with the help of the sp_refreshsqlmodule function.

Understanding the INSTR Function Understanding the INSTR Function

Fri, 14 Sep 2018 08:50:00 +0000 · Language: SQL, Expertise: Intermediate - Learn more about using the INSTR function in MySQL.

Find Tables Referenced by Foreign Keys Find Tables Referenced by Foreign Keys

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Find tables referenced by foreign keys with a script similar to this one.

SQL Not Equal To Operator SQL Not Equal To Operator

Fri, 07 Sep 2018 08:57:00 +0000 · Language: SQL, Expertise: Beginner - See two ways to indicate not equal to in SQL.

Trimming Decimal Places Using TRUNCATE Trimming Decimal Places Using TRUNCATE

Mon, 03 Sep 2018 08:48:00 +0000 · Language: SQL, Expertise: Intermediate - See how it is possible to have use cases that result in varying decimal places.

Getting Information About the Structure of Tables in SQL Getting Information About the Structure of Tables in SQL

Wed, 29 Aug 2018 08:51:00 +0000 · Language: SQL, Expertise: Intermediate - Learn more about how to get information about the structure of the tables inside your database.

Using MySqlCheck Using MySqlCheck

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Learn more about this MySQL utility that provides for verifying and taking corrective actions in case of failures.

Tip: Using MySqlCheck Tip: Using MySqlCheck

Wednesday, December 31, 1969 · Learn more about this MySQL utility that provides for verifying and taking corrective actions in case of failures.

Understanding Usage of the Position Function Understanding Usage of the Position Function

Fri, 24 Aug 2018 08:54:00 +0000 · Language: SQL, Expertise: Intermediate - See why POSITION is a powerful function in MySQL.

Obtain the Oldest Open Transaction Obtain the Oldest Open Transaction

Wednesday, December 31, 1969 · Language: SQL, Expertise: Advanced - See how to determine the oldest transaction in SQL.

Speed Up Entity Framework Queries Speed Up Entity Framework Queries

Wednesday, December 31, 1969 · Language: .NET, Expertise: Intermediate - Learn how explicitly specifying the type can speed up EF queries.

Compare Only Alphabetic Values Compare Only Alphabetic Values

Wednesday, December 31, 1969 · Language: SQL, Expertise: Beginner - Learn how to force a like condition to compare only alphabetic values.

Improve Performance of Select Queries with LIMIT Keyword in MySQL Improve Performance of Select Queries with LIMIT Keyword in MySQL

Mon, 13 Aug 2018 09:06:00 +0000 · Language: Enterprise, Expertise: Intermediate - Learn a simple trick to make certain queries perform correctly in MySQL.

Fetching Common Records Between Two Tables Fetching Common Records Between Two Tables

Wednesday, December 31, 1969 · Language: SQL, Expertise: Beginner - See how to fetch records that are common to one or more tables.

Optimize Your SQL Queries with Schema Names Optimize Your SQL Queries with Schema Names

Fri, 03 Aug 2018 09:01:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how to make possible for the query plan cache to be reused by all users.


· Home

· Databases

· DevX

· Web Links

· Link to us

· Contact

· What's new

· Site map

· Get Help


Most popular:

· Site Feeds

· Database Design Guide

· Google Sitemaps

· smartDataPump

· Spider Support

· How To Link Properly


Free Tools:

· Sitemap Validator

· Simple Sitemaps

· Spider Spoofer

· Ad & Click Tracking



Search Google
Web Site

Add to My Yahoo!
Syndicate our Content via RSS FeedSyndicate our Content via RSS Feed



To eliminate unwanted email from ALL sources use SpamArrest!






Digg this · Add to del.icio.us · Add to Furl · We Can Help You!




Home · Categories · Articles & Tutorials · Syndicated News, Blogs & Knowledge Bases · Web Log Archives


Top of page

No Ads


Copyright © 2004, 2005 by Smart IT Consulting · Reprinting except quotes along with a link to this site is prohibited · Contact · Privacy