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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

Replace Spaces and New Lines with One SQL Statement

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Learn an easy way to replace new lines and spaces inside a field.

Setting a Default NULL Date in SQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Beginner - See how easy it is to set a Default NULL Date in SQL.

Determine Which Providers Are Installed on Your Server

Wednesday, December 31, 1969 · Language: SQL, Expertise: Beginner - See how to check which providers are installed on your server.

Understand Permissions Granted to a User in MySQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Learn how to find the permissions available for a given user in MySQL.

Understanding the REPLACE Command in MySQL

Fri, 13 Jul 2018 09:11:00 +0000 · Language: SQL, Expertise: Intermediate - Learn more about an easy way to replace full or partial value in a column.

SET ARITHABORT ON

Wednesday, December 31, 1969 · Language: SQL, Expertise: Beginner - See why you should use SET ARITHABORT ON.

Import Excel Data into SQL

Fri, 06 Jul 2018 09:04:00 +0000 · Language: SQL, Expertise: Intermediate - Learn about how to read from an Excel Spreadsheet via SQL.

Finding Collations

Wednesday, December 31, 1969 · Language: SQL, Expertise: Beginner - Learn how to find collations in your tables.

Temporary Tables in MySQL

Fri, 22 Jun 2018 09:08:00 +0000 · Language: SQL, Expertise: Intermediate - See how to use a temporary table in MySQL.


· 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