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

Reseed All Autonumber Fields in All Tables

Mon, 27 May 2019 08:13:00 +0000 · Language: SQL, Expertise: Beginner - Learn more about a query that will allow you to reseed all auto-numbered fields.

Using the Locate Command in MySQL

Wednesday, December 31, 1969 · Language: MySQL, Expertise: Intermediate - Finding a particular string in a large data set can be extremely tedious. Fortunately, MySQL has a command called locate to help you find what you need.

Get the First Day of the Current Month

Wed, 22 May 2019 09:10:00 +0000 · Language: SQL, Expertise: Beginner - Learn how to find the first date of the current month.

Adjusting Views to Reduce Visibility of Data in MySQL

Mon, 20 May 2019 08:54:00 +0000 · Language: MySQL, Expertise: Intermediate - See how to make it so that tables with sensitive information are not viewable by all.

Get All Columns in All Tables of a Specific Data Type

Fri, 17 May 2019 09:09:00 +0000 · Language: SQL, Expertise: Beginner - See how to find a specific data type across all tables and columns in a database.

How to Use the Show ProcessList in MySQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Learn how to list all of the processes that hold a valid connection to the database.

Get the Last Day of the Current Month

Wednesday, December 31, 1969 · Language: SQL, Expertise: Beginner - Use this easy query to discover the last day of the current month.

Get Current Precision Level Used by Numbers in SQL Server

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - See how to get the current precision by executing the following command.

Rebuild All Database Indexes

Mon, 06 May 2019 09:08:00 +0000 · Language: SQL, Expertise: Intermediate - See how to rebuild all of the indexes in your database with this query.

Get Current Language of SQL Server

Wed, 01 May 2019 08:27:00 +0000 · Language: SQL, Expertise: Beginner - Learn an easy query to get the current language in SQL Server.

Recompile a Stored Procedure

Fri, 26 Apr 2019 08:17:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how to recompile certain stored procedures.

Using Find_in_Set in MySQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Learn how to search for, or look up, a given string.

RESEED Identity Columns of All Tables

Mon, 22 Apr 2019 08:26:00 +0000 · Language: SQL, Expertise: Beginner - See how to loop through all the tables and execute the DBCC CHECKIDENT command.

Working with the IIF Statement in T-SQL

Wed, 17 Apr 2019 08:25:00 +0000 · Language: SQL, Expertise: Beginner - See how to quickly check for certain conditions.

Using the Insert on Duplicate Key Update in MySQL

Mon, 15 Apr 2019 08:21:00 +0000 · Language: SQL, Expertise: Intermediate - Learn more about the insert on duplicate key update and how to use it in MySQL.

Resize Your TempDB in SQL

Wed, 10 Apr 2019 08:56:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how to resize the tempdb temporary database in SQL.

Understanding the AVG Function in MySQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Learn how to use the AVG function to calculate the average in MySQL.

Get Current Language ID

Wednesday, December 31, 1969 · Language: SQL, Expertise: Beginner - See which select statement to use to get the language ID.

Using sys.dm_db_index_physical_stats

Wed, 27 Mar 2019 08:35:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how to return size and fragmentation information for the data and indexes of the specified table or view in SQL Server.

Using AUTO_INCREMENT in MySQL

Mon, 25 Mar 2019 09:10:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how to set AUTO_INCREMENT values when they need to start from a number of your choice or as per some other criteria.

Write SQL Results to a Text file

Wednesday, December 31, 1969 ·

Finding the Current User in MySQL

Fri, 15 Mar 2019 09:08:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how MySQL provides a mechanism to find the current user.

Diagnose System Slowdowns

Wed, 13 Mar 2019 08:54:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how to quickly diagnose System slowdowns.

Identify Tables Storing GUID Values

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Learn how to identify tables that store a GUID (Globally Unique Identifier) value.

Using sys.dm_db_missing_index_group_stats

Wed, 27 Feb 2019 09:35:00 +0000 · Language: SQL, Expertise: Intermediate - See how to return summary information about groups of missing indexes, excluding spatial indexes.


· 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