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

Tag: like

Just 4 Table Join query takes too much time and some time fail to execute

By adminPosted on January 8, 2023

Question : I am working on getting candidate detail from mysql database and for that i have created one query. […]

Update data of one table from another with comparing columns have same initial strings

By adminPosted on December 27, 2022

Question : I have two tables: NewData: EName Job Sal smith clerk 2000 allen sales 2000 jones.domain.com Manager 6000 OldData: […]

Can a Postgres LIKE statement return an exact match?

By adminPosted on December 25, 2022

Question : I’m trying to search a Postgres table using LIKE and %, but the query is not returning results. […]

JOIN on LIKE when input udtt count is > 1

By adminPosted on December 8, 2022

Question : This query accepts a User-Defined Table Type variable and then joins that with a table. If the input […]

Closing bracket ‘]’ in LIKE wildcard

By adminPosted on November 5, 2022

Question : I have a query that looks a bit like this: SELECT * FROM Stuff WHERE name LIKE ‘[a]]%’ […]

Is it a better idea (performance is key) to store in a normalized table and retrieve by JOIN or in a single nvarchar column and retrieve using LIKE?

By adminPosted on October 18, 2022

Question : NOTE: The application is not really about websites or keywords, I am using that here only to provide […]

Overcome LIKE character length limitation

By adminPosted on October 14, 2022

Question : By reading this LIKE character length limitation here, it looks like I can’t send a text longer than […]

Is it a better idea (performance is key) to store in a normalized table and retrieve by JOIN or in a single nvarchar column and retrieve using LIKE?

By adminPosted on September 20, 2022

Question : NOTE: The application is not really about websites or keywords, I am using that here only to provide […]

How to filter a character followed by numbers string pattern in PostgreSQL?

By adminPosted on July 18, 2022

Question : Back in SQL Server, I use the command below to get the matching string pattern of #1234 from […]

If in mysql I have string `xxx yyy` – how can I SELECT this if user input `xxxyyy`?

By adminPosted on June 23, 2022

Question : My online-shop in PHP (OpenCart). On site we have product-search. For example product have name iSport 220, and […]

  • 1
  • 2
  • 3
  • …
  • 5

Recent Posts

  • Should “Long Running with Low CPU” be expected for an SPROC that performs millions of INSERTS?
  • What’s the benefit of CROSS JOIN vs INNER JOIN in recursive CTE queries?
  • Mongoexport halts when it reaches 101 records
  • A Script to insert dummy Data in all tables of DB [duplicate]
  • Will query continue to run even after network times-out
  • Need some support on MySQL Query
  • The sort column must be the last column used in the index – MongoDB Indexing Advice
  • Understanding Backup Types
  • SQL Server sp_configure options?
  • DBA Permissions on LOCAL SERVER containing SQL SERVER [closed]
  • Update table using values from another table in SQL Server
  • Getting 0KB of size file while backup mysql database using mysql dump [closed]
  • Local Backup from Amazon RDS PostgreSQL database
  • Who is using my worker threads? SQL Server 2014 – HADR
  • Data Domain Boost viewing backups
  • One table for all persons
  • Database for building a realtime analytics system
  • Threads_cached 0 while thread_cache_size > 0
  • Why is performance non-linear if I do many UPDATEs in a single transaction
  • Mysql innoDB write operations are extremely slow

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