Hottest Questions Today

1

vote

1

answer

45

views

PostgreSQL: query slow, planner estimates 0.01-0.1 of actual results

postgresql execution-plan

modified 1 hour ago Gerard H. Pille 1,870

0

votes

1

answer

15

views

How to delete records with FK constraint using Delete Trigger

sql-server trigger

answered 11 mins ago Aaron Bertrand♦ 168k

1

vote

1

answer

14

views

Get next row based on current row and conditional ordering

sqlite sqlite-3.33

modified 4 hours ago Colin 't Hart 7,482

0

votes

1

answer

16

views

order by slowing down query with multiple joins and limit/offset on larger result sets

query-performance innodb mariadb query

modified 11 hours ago user756659 111

0

votes

0

answers

12

views

How exactly does PostgreSQL expect me to read in/delete the CSV log files?

postgresql configuration copy logging

asked 15 hours ago Jenrri N. 1

1

vote

1

answer

11

views

How to know how full the MySQL redo log is?

mysql

answered 15 hours ago Rick James 55.5k

0

votes

0

answers

21

views

Why does CAST AS VARCHAR2 truncate text instead of throwing an error?

oracle etl varchar cast oracle-18c

modified 20 hours ago User1973 109

-1

votes

0

answers

16

views

Unpivot Issue adding additional records for every column [closed]

sql-server unpivot

asked 20 hours ago Travis Irby 1

0

votes

0

answers

17

views

Modelling a bitemporal data set in a data warehouse

database-design data-warehouse eav snowflake

asked yesterday ayushgp 101

5

votes

1

answer

155

views

How do pages get updated checksum when switching page verification mode from torn page to checksum?

sql-server sql-server-2014 corruption checksum

modified yesterday user2368632 53

0

votes

2

answers

39

views

What does it mean that a “clustered index does not store pointers to the data”? [duplicate]

clustered-index nonclustered-index

modified yesterday Paul White♦ 57.1k

0

votes

1

answer

12

views

MongoDB - count current read/write operations

replication mongodb

answered 5 hours ago Joe 248

0

votes

0

answers

12

views

How to pass query string containing variable names into mysql stored procedure

mysql stored-procedures prepared-statement

asked yesterday Ifedi Okonkwo 235

0

votes

2

answers

19

views

Sort by ID when ID < 1000, otherwise sort by name

sqlite

answered yesterday Colin 't Hart 7,482

-1

votes

1

answer

31

views

MSSQL delete with output [closed]

sql-server

answered 2 days ago gbn 67.2k

1

vote

1

answer

30

views

MYSQL Huge Data migration (5TB) from old server to new server

mysql backup migration etl

answered 23 hours ago Rick James 55.5k

2

votes

1

answer

11

views

MySQL High Memory / Threads - Ubuntu

mysql ubuntu

yesterday

0

votes

0

answers

48

views

Legacy CE vs current

sql-server cardinality-estimates

modified yesterday armitage 1,079

0

votes

1

answer

33

views

“Cannot continue the execution because the session is in the kill state” Error?

sql-server sql-server-2019

modified yesterday Laurenz Albe 15k

0

votes

2

answers

35

views

What are the benefits of moving redologs, data- and controlfiles to another location?

oracle oracle-18c

answered yesterday Albert Godfrind 1,168

0

votes

2

answers

51

views

Avoid downtime of Microsoft SQL Server during restarts

sql-server sql-server-2016 high-availability

modified Sep 17 at 13:32 Paul White♦ 57.1k

0

votes

2

answers

28

views

Two records in the same table must be related somehow

schema table

answered yesterday Sean McCarthy 103

-3

votes

0

answers

12

views

number weeks from April to September for every year

t-sql

asked yesterday KVD 1

0

votes

1

answer

11

views

Temprary tables on Mariadb with no activity on the server

mariadb

answered yesterday Rick James 55.5k

1

vote

1

answer

26

views

how to speed up / fix this Ubuntu Apache MySQL Server Configuration?

mysql performance-tuning ubuntu

answered yesterday Rick James 55.5k

1

vote

3

answers

32

views

MariaDB master to master replication auto increment is not sequential

mysql mariadb linux

answered yesterday Rick James 55.5k

0

votes

0

answers

25

views

Can't open SQLite file with HeidiSQL [closed]

sqlite heidisql

asked 2 days ago VanessaF 11

0

votes

1

answer

38

views

Inadvertently created a table named “select * from table where …”

postgresql

answered yesterday CL. 4,059

0

votes

1

answer

36

views

Query optimizer triggering statistics update seems to be slowing down queries

sql-server query-performance sql-server-2016 statistics

answered 2 days ago Tibor Karaszi 5,403

0

votes

1

answer

37

views

Ensuring relationship between child tables exists prior to SQL insert

sql-server mysql postgresql

answered 2 days ago Akina 12.7k

0

votes

0

answers

87

views

Increasing CPU count to 64 results in slower SQL Server response time [closed]

sql-server sql-server-2017 hardware cpu

modified yesterday Lumpy 1,999

0

votes

1

answer

22

views

grant select in just one DMV instead of grant VIEW SERVER STATE

sql-server

answered 2 days ago Mo64 499

0

votes

1

answer

23

views

SQL Server-Is It possible 'lock waits and timeouts high but average wait time does not'?

sql-server

answered 2 days ago Mo64 499

0

votes

1

answer

51

views

What is the best way to store optional values in table?

sql-server performance null sql-server-2019

modified 2 days ago bbaird 1,379

2

votes

1

answer

116

views

Why is the ROW keyword needed when constructing a row with one element, but not two?

postgresql syntax row

modified Sep 16 at 15:27 mustaccio 15.9k

0

votes

0

answers

21

views

Can parameter sniffing happen in other RDBMSs, not just SQL Server? [duplicate]

sql-server rdbms parameter-sniffing

modified 2 days ago user2652379 359

0

votes

0

answers

12

views

Is it disaster to use Mysql IN operator with 10000 ids (primary key col) on a table of 1M records

mysql

asked 2 days ago NkTheGame 1

0

votes

0

answers

42

views

Ensure data integrity in relational DB?

mysql database-design referential-integrity data-integrity

modified 2 days ago bbaird 1,379

0

votes

1

answer

32

views

Postgres query slow despite index being used

postgresql index optimization

modified 2 days ago Gerard H. Pille 1,870

0

votes

1

answer

51

views

Clustered Index during data load in MS SQL Server

sql-server performance ssms

answered Sep 17 at 13:01 bbaird 1,379

0

votes

1

answer

19

views

Issues Designing ER Diagram

erd

answered 2 days ago nosurprisespls 21

1

vote

1

answer

23

views

Postgres Query not using Index but faster with Index

postgresql postgresql-performance postgresql-11

answered 2 days ago Laurenz Albe 15k

1

vote

1

answer

14

views

Is there a plugin to add a map behind the spatial results?

sql-server ssms spatial

answered 2 days ago Mo64 499

-1

votes

1

answer

23

views

Is InfluxDB faster than PostgreSQL [closed]

postgresql performance influx-db

modified Sep 17 at 14:18 Tobi Akinyemi 119

0

votes

2

answers

30

views

oracle - hashing method, excluding DBMS_CRYPTO

oracle hashing

answered 2 days ago pmdba 967

0

votes

0

answers

16

views

SQL Server 2016 Altering avaibilty group listener IP

sql-server availability-groups

modified 2 days ago a_horse_with_no_name 57.3k

1

vote

0

answers

25

views

Update and insert performance with partial indexes

postgresql index postgresql-performance

asked Sep 17 at 13:35 Markeli 111

Top Questions

Looking for more? Browse the complete list of questions, or popular tags. Help us answer unanswered questions.