Hottest Questions Today

0

votes

1

answer

13

views

Running queries/jobs via SMSS - SQL service and SQL agent service accounts (SQL Server)

modified 46 mins ago Sayadian 74

0

votes

1

answer

12

views

CASE in WHERE clause - retuns a single-row result instead of 4 rows?

t-sql join case where

answered 1 hour ago MrPshaw 91

1

vote

2

answers

25

views

I want to get all the weeks of a month with starting and end dates of a weeks without creating table

postgresql postgresql-9.6 datetime date

modified 4 mins ago O. Jones 435

1

vote

0

answers

16

views

How to find the number of queries executed since server startup in PostgreSQL

postgresql

modified 3 hours ago Vérace 20.2k

0

votes

0

answers

26

views

Can filtering be done more efficiently with/without sql joins?

mysql index mariadb nosql

modified 6 hours ago David Browne - Microsoft 24.1k

0

votes

0

answers

13

views

SQL DR Availability Group cluster validation failure

sql-server clustering failover disaster-recovery

modified 5 hours ago Fylix 171

1

vote

1

answer

11

views

mysqldump locks all tables even when specifically grabbing a few?

mysql backup mysqldump

answered 5 hours ago Gordan Bobic 552

1

vote

2

answers

36

views

What are the benefits of storing columns in JSON instead of traditional tables?

postgresql json

modified 2 hours ago Vérace 20.2k

0

votes

0

answers

27

views

Are there any major changes from Postgres version 11 to postgres version 12?

postgresql upgrade postgresql-11 postgresql-12

modified 8 hours ago Vérace 20.2k

0

votes

1

answer

19

views

PostgreSQL: date/time field value out of range

postgresql import csv date-format

modified 9 hours ago Laurenz Albe 12.3k

-2

votes

0

answers

16

views

create a procedure without parameter in order to create table with a specific structure pasing part of the name of the table as an argument

postgresql postgresql-performance

modified 10 hours ago Akina 11.7k

0

votes

1

answer

17

views

Flip a flag from one row to another in a single query

postgresql postgresql-10

answered 11 hours ago a_horse_with_no_name 54.2k

0

votes

0

answers

14

views

MariaDB stops responding unexpectedly

mysql mariadb

modified 8 hours ago Vérace 20.2k

0

votes

1

answer

14

views

How to access the error log

mysql mysql-5.7

answered 9 hours ago O. Jones 435

0

votes

0

answers

24

views

To automatically stop/disable transactional replication whenever table get altered

sql-server sql-server-2016 transactional-replication

asked 14 hours ago user26979 53

-1

votes

0

answers

12

views

Use MS Access to join and save tables via Form

join ms-access

asked 12 hours ago thanksalot 1

3

votes

2

answers

1k

views

Is there any way I can speed up this large full-table query?

sql-server query-performance

modified yesterday Nzall 191

1

vote

1

answer

46

views

Why does MySQL consecutive JOIN give an unexpected result?

mysql join

modified 13 hours ago Laurenz Albe 12.3k

0

votes

2

answers

49

views

Vastly different query run-times on different servers

sql-server sql-server-2012 sql-server-2016

answered 12 hours ago j.v. 116

0

votes

1

answer

17

views

Does the SQL/JSON Path specification allow accessing the property of a filter expression's result

postgresql oracle json-path

modified 13 hours ago a_horse_with_no_name 54.2k

0

votes

0

answers

16

views

Slow performance when joining a small table and filtering out on a non-key column in MariaDB (MySQL)

mysql query-performance join mariadb

modified 3 hours ago Gorgi Rankovski 103

1

vote

0

answers

21

views

MySQL server keeps crashing every few minutes

mysql phpmyadmin wordpress

modified 8 hours ago Okomikeruko 111

0

votes

1

answer

23

views

MySQL InnoDB Insertion Faster Than MyISAM

mysql performance innodb myisam bulk-insert

answered 13 hours ago Gordan Bobic 552

1

vote

1

answer

15

views

How can I ONLY get the query execution time on the command line without waiting till the data is displayed?

mysql command-line

modified 13 hours ago Vérace 20.2k

0

votes

2

answers

40

views

How to create an user with permission to do everything but drop databases?

sql-server permissions

answered yesterday Sayadian 74

0

votes

0

answers

13

views

Postgres “fuzzy” join / dedupe

postgresql

asked 18 hours ago lurf jurv 119

0

votes

1

answer

74

views

SQL Server - Prevent Clustered Index Scan on a specific table

sql-server query-performance sql-server-2016 execution-plan

modified 16 hours ago John aka hot2use 11.2k

1

vote

3

answers

31

views

Is storing data that can be inferred go against data normalization?

database-design normalization

answered 21 hours ago Michael Green 19k

0

votes

0

answers

15

views

Postgres vs MySQL: Commands out of sync;

mysql postgresql transaction concurrency c++

modified 17 hours ago a_horse_with_no_name 54.2k

1

vote

0

answers

12

views

Calculate total running time of pods using two date/timestamp columns

postgresql query-performance query

modified 15 hours ago John aka hot2use 11.2k

1

vote

1

answer

11

views

Creating a TYPE that is an Array within a Function (or a predefined Array TYPE) in PostgreSQL

postgresql datatypes array domain

modified 18 hours ago Erwin Brandstetter 116k

0

votes

0

answers

27

views

How to make email joins run faster? [closed]

mysql innodb join

modified yesterday LOSTinDB 463

0

votes

1

answer

26

views

How to ensure only a single row with a certain value

postgresql postgresql-10

answered yesterday a_horse_with_no_name 54.2k

3

votes

0

answers

45

views

Can backups done through external clients cause memory pressure on SQL Server?

sql-server backup memory sql-server-2019

modified yesterday LowlyDBA 9,250

0

votes

0

answers

13

views

Will PostgreSQL hash all columns

join postgresql-performance postgresql-12

asked yesterday Rasmus 1

1

vote

1

answer

14

views

When to break down attributes in tables into sub-tables for normalisation

database-design

answered 20 hours ago Michael Green 19k

2

votes

1

answer

35

views

Is it acceptable to use the presence of a value in a NULLable column as a flag? [closed]

sql-server

answered yesterday Michael Green 19k

0

votes

1

answer

42

views

How can I backup a SQL Server database to another SQL Server instance? [closed]

sql-server

modified yesterday marc_s 8,223

1

vote

1

answer

49

views

Break down calendar table based on custom dates in SQL Server 2017

sql-server t-sql sql-server-2017 table

modified yesterday Graham 368

0

votes

1

answer

21

views

oracle package to migrate postgresql with plpython

postgresql

answered yesterday Laurenz Albe 12.3k

0

votes

0

answers

23

views

Calculate correlation coefficient in PostgreSQL

postgresql query functions

modified yesterday Marcello Miorelli 12.4k

3

votes

1

answer

78

views

+50

Changing database compatibility from legacy CE to 120

sql-server query-performance sql-server-2014 optimization cardinality-estimates

answered 5 hours ago Oreo 1,368

0

votes

1

answer

19

views

total drinks per day column

mysql aggregate count

modified yesterday til_b 531

-1

votes

1

answer

30

views

SQL merging 2 rows

mysql

modified yesterday Vérace 20.2k

0

votes

0

answers

17

views

Choosing database type and schema for rental availability

schema cassandra

modified yesterday CircularRecursion 101

0

votes

1

answer

16

views

query an indexed jsonb column

postgresql index full-text-search json

answered yesterday Laurenz Albe 12.3k

0

votes

0

answers

20

views

Propagate a key along database inheritance structure

postgresql inheritance surrogate-key

modified yesterday Michael Green 19k

Top Questions

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