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

Author: admin

Why my BEFORE UPDATE trigger takes values from the NEW record? [closed]

By adminPosted on June 10, 2023

Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]

Split a query results multiple times

By adminPosted on June 10, 2023

Question : I need to create a procedure to make statistics on my database. First, I decided to create a […]

Improve reading speed of MySQL table storing stock prices (100 Mil. entries)

By adminPosted on June 10, 2023

Question : I have a table which stores stock prices in a MySQL database with the following structure: CREATE TABLE […]

Adding sql users via linked servers

By adminPosted on June 10, 2023

Question : I need to add a windows user and set role to sysadmin for a bunch of linked servers […]

Postgres – caching of recently inserted data?

By adminPosted on June 10, 2023

Question : Does Postgres cache recently INSERTed data? And if so, how can I increase the amount? Here’s why I’m […]

Does Oracle randomly switch execution plans to check if there is a better solution?

By adminPosted on June 10, 2023

Question : I had a talk with an external colleague about oracle “swinging in” its performance. In detail it was […]

Cannot INSERT into database on a shared server

By adminPosted on June 10, 2023

Question : I have launched an application on a shared server but I cannot INSERT any data. I thought maybe […]

Simple query with a single join very slow

By adminPosted on June 10, 2023

Question : I have this very slow, simple query that joins a large table (~180M rows) with a smaller table […]

How to replicate and sync MongoDB localhost to a remote server using replica set

By adminPosted on June 10, 2023

Question : Initially I started two node(primary and secondary) on same host machine on two different port , secondary was […]

How can I increase performance for select in select statement

By adminPosted on June 10, 2023

Question : The item table is like this id category_id name registered I have to show total number of items […]

  • 1
  • 2
  • 3
  • …
  • 7,010

Recent Posts

  • Why my BEFORE UPDATE trigger takes values from the NEW record? [closed]
  • Split a query results multiple times
  • Improve reading speed of MySQL table storing stock prices (100 Mil. entries)
  • Adding sql users via linked servers
  • Postgres – caching of recently inserted data?
  • Does Oracle randomly switch execution plans to check if there is a better solution?
  • Cannot INSERT into database on a shared server
  • Simple query with a single join very slow
  • How to replicate and sync MongoDB localhost to a remote server using replica set
  • How can I increase performance for select in select statement
  • Optimize UNION query in MySQL
  • Mysql Performance tuning for myisam tables.
  • Get-ClusterParameter Not Returning Expected Results
  • SQL Server Extended Events to Capture Objects access by a User [duplicate]
  • Execution time of triggers fired when a procedure is executed in postgresql
  • Efficient query to get last row group by multiple columns
  • How to use GROUP BY after the Having clause Mysql
  • PGSQL- syntax error at or near “-“
  • Huge database logging of event type rows and ways to optimize it
  • Why is the following query so bad performance-wise

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