Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: data-validation

Validating the GST Identification Number (GSTIN)

By adminPosted on January 9, 2023

Question : The following image describes the format of the GST Identification Number: The first 2 digits denote the unique […]

Post migration MySQL database validation

By adminPosted on November 13, 2022

Question : We are migrating from 5.5 enterprise mysql to 8.0 mysql enterprise edition. And we are migrating version by […]

How do I store phone numbers in PostgreSQL?

By adminPosted on September 26, 2022

Question : Let’s assume I want to store phone numbers in a database. I may accept phone numbers from outside […]

How to validate data before loading it to DB

By adminPosted on September 25, 2022

Question : I have a situation where in I have million records in CSV file, what I need to do […]

Loop through list of fields, check against lookup table

By adminPosted on April 27, 2022

Question : I have a list of fields: FIELD_DOMAIN_ENG_VW +————-+————+————-+ | TABLE_NAME | FIELD_NAME | DOMAIN_NAME | +————-+————+————-+ | ENG.TABLE_1 […]

use cases for db.collection.validate() – checks the structures within a namespace for correctness by scanning the collection’s data and indexes

By adminPosted on July 8, 2021

Question : I found on MongoDB mailing list one use case for db.collection.validate(): The count() command is generally an estimate […]

Validating SQL Server Change Tracking Synchronization

By adminPosted on May 23, 2021

Question : I have some tables that I need to synchronize from one SQL Server database to another. I’m using […]

db.collection.validate() missing output and verify() returned EBUSY on first run

By adminPosted on February 11, 2021

Question : logs of the successful run # grep conn103640 mongodb.log | head -10 2017-01-12T11:29:51.492+0000 I ACCESS [conn103640] Successfully authenticated […]

Validate three digits before decimal and after decimal point six digits

By adminPosted on April 13, 2020

Question : I have columns called longitude and latitude with nvarchar data type. The user can enter something like (23.23424432),(432423.343), […]

Recent Posts

  • Order of returned rows with IN statement
  • Do not want to allow Queries to take more than x minutes?
  • How would i create a report involving multiple many to many relationships
  • web interface port for oracle 11g
  • Getting the exact and closest Search using CONTAINS/CONTAINSTABLE in SQL
  • How can I check if a user have a quota on tablespace
  • Can alias in SQL Server contain slash?
  • Why store /var/lib/mysql when you can just create SQL dumps for backup purposes?
  • Fix OGR2OGR “failed when converting the varchar value to data type int” issue in the MSSQL table –
  • Sum on distinct and group by
  • Is a join optimized to a where clause at runtime?
  • Simple select is taking too long
  • GROUP BY with subqueries for a Group?
  • SERVERPROPERTY(‘Edition’) AS [Edition]
  • Do MySQL sub-queries essentially use as much overhead as separate queries?
  • select fieldvalues and column-description of a table
  • Secure database access from particular applications
  • How to optimize and estimate DB recovery times?
  • How to make a FULLTEXT search with ORDER BY fast?
  • De-duplicate rows in place vs de-duplicate on transfer

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding