Hottest Questions Today

0

votes

1

answer

17

views

how to connect to PostgreSQL using a stable way

postgresql

answered 33 mins ago Burak Yurdakul 79

1

vote

1

answer

29

views

Is using of subqueries more efficient than using Limit offset and orderby in mysql?

modified 1 hour ago Rick James 61.6k

3

votes

2

answers

141

views

How can we restrict tempdb usage for specific users or queries on SQL Server?

sql-server sql-server-2016 tempdb sybase

modified 5 hours ago Peter Mortensen 293

18

votes

3

answers

2k

views

Why is the default page size for databases so small?

sql-server mysql postgresql db2 size

modified 11 hours ago Vérace 24.3k

0

votes

1

answer

24

views

Partition table design and house keeping (MSSQL)

sql-server stored-procedures partitioning

answered 6 hours ago Dan Guzman 22k

0

votes

0

answers

42

views

Converting IN to EXISTS in Sql [closed]

sql-server mysql

asked 9 hours ago Rami Danish 1

0

votes

0

answers

14

views

User followers - Embed or reference

database-design mongodb

modified 5 hours ago prasad_ 262

0

votes

0

answers

20

views

Remove columns from denormalized db and still have same results

postgresql join normalization

asked 8 hours ago chenny 101

-1

votes

0

answers

17

views

What is the most efficient way to migrate away from AWS RDS?

amazon-rds aws

modified 6 hours ago Daniel Huesca 1

0

votes

0

answers

14

views

how do I find out the redundant foreign key constraint details for the table which causing the performance issue in the db

oracle oracle-12c plsql oracle-sql-developer plsql-developer

asked 9 hours ago SONU 1

0

votes

1

answer

37

views

How to SELECT DISTINCT records with INNER JOIN?

sql-server

answered 8 hours ago J.D. 16.2k

0

votes

0

answers

11

views

pg_dump fills up memory but does not write to disk

postgresql backup pg-dump

asked 9 hours ago r0tt 776

0

votes

1

answer

28

views

Error Restore database to secondary - Log Shipping

sql-server log-shipping

modified 10 hours ago SqlWorldWide 11k

0

votes

1

answer

12

views

labeling the codes in SQLite

sqlite code

answered 7 hours ago Phill W. 4,856

0

votes

0

answers

37

views

Super complex Schema will not migrate to PaaS

sql-server-2016 schema migration azure

modified 12 hours ago Community♦ 1

0

votes

1

answer

28

views

How to configure Always ON High Availability on this infrastructure?

sql-server availability-groups clustering high-availability

answered 13 hours ago MBuschi 2,265

-3

votes

1

answer

39

views

SQL Server to PostgreSQL equivalent

postgresql postgresql-9.5

answered 14 hours ago a_horse_with_no_name 64k

0

votes

0

answers

14

views

why postgresql data files differ in size significantly

postgresql datafile size

asked 17 hours ago Tim He 69

1

vote

0

answers

21

views

Search by first and last name of the Instructor

mysql string-searching like

modified 9 hours ago Swapnil 119

0

votes

1

answer

21

views

Cannot set foreign key when creating tables

mysql database-design foreign-key

modified 18 hours ago matigo 1,396

0

votes

1

answer

13

views

why could not add comment in generate column in MySQL 5.7

mysql

answered 17 hours ago Dolphin 239

0

votes

1

answer

45

views

Fresh SQL Server 2019 can't query Excel files

sql-server sql-server-2019

answered 23 hours ago Hannah Vernon♦ 64.8k

1

vote

1

answer

47

views

Why sp_WhoIsActive blocking_session_id IS NULL

sql-server sql-server-2014

answered yesterday Erik Darling 31.2k

0

votes

1

answer

14

views

removing dates from generate_Series in postgreSQL

postgresql postgresql-12

answered 18 hours ago Laurenz Albe 23.7k

1

vote

3

answers

48

views

TABLOCK hint for SELECT statements when blocking writers is not an issue

sql-server locking blocking

answered 7 hours ago Tibor Karaszi 10.6k

0

votes

0

answers

15

views

MySQL Group Replication add node to (long) existing cluster fails

mysql group-replication

modified 13 hours ago TVA van Hesteren 101

0

votes

2

answers

22

views

Precautions before relocating the RMAN backups?

oracle backup rman parameter

answered yesterday EdStevens 1,781

0

votes

1

answer

12

views

Is it possible to do WAL physical replication to a db without making that db read-only?

postgresql

answered 18 hours ago Laurenz Albe 23.7k

0

votes

1

answer

17

views

Pivot/transpose rows into columns efficiently with multiple columns

sql-server ssms pivot

answered yesterday nbk 6,621

0

votes

1

answer

22

views

How to use multiple SELECTs within a single INSERT?

postgresql select bulk-insert

answered yesterday a_horse_with_no_name 64k

10

votes

3

answers

1k

views

DB backups have suddenly gotten smaller

sql-server backup sql-server-2017 database-size

modified yesterday inquisitive pukeko 101

0

votes

0

answers

12

views

Remove inserted data from wrong dump file

mysql dump

asked yesterday Samrat 1

0

votes

3

answers

33

views

Get the most recent 2 entries for each group based on timestamp

mysql mysql-5.7 greatest-n-per-group

modified yesterday nbk 6,621

0

votes

1

answer

21

views

Select query with multiple joins

join

answered yesterday matigo 1,396

1

vote

2

answers

95

views

How can a cheap function in a SELECT make the whole query slow?

postgresql postgresql-performance functions cte parallelism

modified yesterday LaVache 161

-1

votes

0

answers

17

views

find a problem into mongodb cpu usage in mongodb atlass

mongodb mongodb-4.0

modified yesterday Ali Ebrahimi 1

0

votes

0

answers

15

views

Join on Jsonb Path Query with filter condition

postgresql index

asked yesterday ivans 11

1

vote

1

answer

26

views

SQL Dynamic Query based on user input in PowerBI

sql-server query dynamic-sql powerbi

answered yesterday Sir Swears-a-lot 3,022

0

votes

0

answers

13

views

Average amount of orders per hour in the last X days per merchant

select

modified yesterday jugarugabi 1

-1

votes

2

answers

25

views

MySQL Upgrade Procedure in a production environment

mysql mysql-5.6 mysql-5.7 upgrade

modified yesterday Rick James 61.6k

2

votes

3

answers

54

views

Slow query when multiple users connected to MariaDB

query-performance index mariadb optimization query

modified 6 mins ago Rick James 61.6k

7

votes

2

answers

683

views

Should stored financial transactions include some data redundancy?

database-design normalization

modified Jun 18 at 7:13 Paul White♦ 60.9k

1

vote

1

answer

35

views

Data missing on Subscriber Database in SQL server transactional replication

sql-server replication

answered 18 hours ago SqlWorldWide 11k

0

votes

2

answers

44

views

What can go wrong while querying INFORMATION_SCHEMA for schema names? [duplicate]

sql-server information-schema

modified 2 days ago Paul White♦ 60.9k

8

votes

2

answers

965

views

Nested CTEs Returning Incorrect Results in Certain Situations

sql-server cte

modified Jun 15 at 22:15 Erik Darling 31.2k

1

vote

0

answers

18

views

DB2 Linux authentication fails

linux db2 authentication db2-luw db2-10.5

asked 2 days ago haba713 111

0

votes

1

answer

53

views

Storage configuration for faster queries [closed]

sql-server storage

modified yesterday Aleksey Vitsko 3,357

Top Questions

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