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

Tag: best-practices

Splitting a large table to improve performance

By adminPosted on January 30, 2023

Question : This is a follow-up to an earlier question. I have a SQL Server 2008 R2 Standard server, that […]

Granting access to all tables for a user

By adminPosted on January 27, 2023

Question : I’m new to Postgres and trying to migrate our MySQL databases over. In MySQL I can grant SELECT, […]

When should I use a unique constraint instead of a unique index?

By adminPosted on January 26, 2023

Question : When I want a column to have distinct values, I can either use a constraint create table t1( […]

Database modelling best practice question

By adminPosted on January 24, 2023

Question : I am modelling a database for an application I am developing and I am in front of a […]

Is EXECUTE AS OWNER in msdb a security risk?

By adminPosted on January 23, 2023

Question : I’ve been tasked with creating a system that allows non-privileged users to start and stop SQL Server Agent […]

Mongodb performance: compound query vs moving to other collection

By adminPosted on January 19, 2023

Question : My application uses mongodb to store order information. At some point orders are sent after which I need […]

What’s a good use case for SELECT * in production code?

By adminPosted on January 15, 2023

Question : Out of habit, I never use SELECT * in production code (I only use it with ad-hoc scrap […]

Should I use mysql_upgrade after mysqld_safe when upgrading MariaDB?

By adminPosted on January 13, 2023

Question : I’m wanting to know the best practice to do a MariaDB upgrade on opensuse. I am getting this […]

How to encode a known date but unknown year?

By adminPosted on January 10, 2023

Question : I am using a Postgres database, and have a table with a date-time field. For many records, we […]

How do I tactfully bring up database shortcomings? [closed]

By adminPosted on January 8, 2023

Question : Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the […]

  • 1
  • 2
  • 3
  • …
  • 23

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