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

Tag: substring

Single query approach to split and copy string values in a column

By adminPosted on January 26, 2023

Question : This is a part of my previous question. I have the below logic to split a string value […]

Mass update all cells in a column with a substring of it’s original value

By adminPosted on December 2, 2022

Question : I need to trim the last seven characters off of all the cells in a column. This query […]

Is there a SQL Server implementation of the Longest Common Substring problem?

By adminPosted on September 14, 2022

Question : Is there a SQL Server implementation of the Longest Common Substring problem? A solution that checks with all […]

Is there a SQL Server implementation of the Longest Common Substring problem?

By adminPosted on July 13, 2022

Question : Is there a SQL Server implementation of the Longest Common Substring problem? A solution that checks with all […]

Timestamp and substring with regular expression

By adminPosted on July 7, 2022

Question : I am using postgresql and I have the following table Table “public.test” Column | Type | Modifiers ——–+————————–+———– […]

Is there a more concise way in Postgres to extract a portion of a string?

By adminPosted on July 4, 2022

Question : I’m using Postgres 9.5. I have a table with a column that records URLs. Sometimes the URL has […]

How to simplify repeating variables in where clause for multiple columns SQL Server

By adminPosted on June 28, 2022

Question : I know there has to be a better way to evaluate a set of repeating variables against multiple […]

Changes to estimates on predicates that contain SUBSTRING() in SQL Server 2016?

By adminPosted on June 5, 2022

Question : Is there any documentation or research about changes in SQL Server 2016 to how cardinality is estimated for […]

Remove substring from one column and put it on other column

By adminPosted on May 30, 2022

Question : I have a table like this: CREATE TABLE `mytable` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `column1` varchar(255) […]

SQL Split Row Data Separated by Spaces

By adminPosted on May 24, 2022

Question : I am looking for a query to find nth value in a list. The separator is anything greater […]

  • 1
  • 2
  • 3
  • 4

Recent Posts

  • Reasons for avoiding large ID values
  • Sql Statement to display multiple true statement
  • How do I force SQL Server to use my spatial index through a view?
  • How to optimize selection of pairs from one column of the table (self-join)?
  • Unable to drop the table since its showing waiting for meta data lock
  • SQL Server: localhost vs MSSQLLocalDB
  • Exclude rows when a column has matches
  • Converting 3 Master + 1 Slave to 4 Master – Any advice?
  • Creating a test database from Production database (different machines & servers)
  • Wrong results on queries with join for some MariaDB versions
  • Find any employees who earn less than the employee hired immediately after them [closed]
  • SQL Server Replication Agent Permission
  • Index usage on a temporary table
  • MySQL – Simple update is very slow and causing high load average with large amount of server
  • PostgreSQL is not using index with large data
  • During installation can’t change directory
  • Column order for better index
  • Why is this PostgreSQL volatile function faster than an inline subquery?
  • Ignoring temp table in Postgres event trigger
  • How do I get the difference in minutes from 2 timestamp columns?

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