Hottest Questions Today

0 votes

1 answer

15 views

Consolidating Similar Indexes?

sql-server index

Brendan McCaffrey

2,944

answered 3 hours ago

0 votes

1 answer

12 views

MySQL incorrect equality casting bigint to char

mustaccio

21.6k

answered 3 hours ago

-1 votes

0 answers

12 views

SQL Server - Example queries for the WideWorldImporters sample database

sql-server select dml

Joao Heleno

99

asked 6 hours ago

0 votes

1 answer

11 views

Find in what table I can find multiple collumns

oracle oracle-sql-developer data-dictionary catalog-views

Littlefoot

735

answered 6 hours ago

-3 votes

0 answers

35 views

SQL Server 2019 Blue Question Mark in Remote SSMS

sql-server ssms sql-server-2019

Tony

1

modified 10 hours ago

2 votes

0 answers

12 views

SQL Server 2014 SP3 Backup to URL error

sql-server sql-server-2014 backup azure-blob-storage

Charlieface

5,768

modified 7 hours ago

3 votes

5 answers

332 views

Return NULL when distinct values else return value

sql-server group-by

Paul White♦

71k

answered 12 hours ago

-2 votes

1 answer

19 views

Is it possible to access a Windows MSSQL server from an instance of Linux?

sql-server linux command-line

Dominique Boucher

2,859

answered 11 hours ago

0 votes

1 answer

11 views

oracle - Calculate sum or avg in one query based on the their value

oracle plsql

Littlefoot

735

answered 6 hours ago

0 votes

0 answers

20 views

A transport-level error has occurred when receiving results from the server. An existing connection was forcibly closed by the remote host

sql-server sql-server-2017 network

Aleksey Vitsko

4,612

modified 11 hours ago

2 votes

1 answer

87 views

SQL Server PATINDEX issue/bug when using different case-sensitive collations

sql-server t-sql sql-server-2016 collation case-sensitive

Solomon Rutzky

65.8k

modified 11 hours ago

0 votes

1 answer

20 views

Is `innodb_table_locks=0` a good idea?

mysql mysql-8.0

Bill Karwin

9,796

answered 9 hours ago

0 votes

0 answers

17 views

Postgres - how to automatically kill a 'hung' session?

postgresql powershell

ConanTheGerbil

841

modified 14 hours ago

-1 votes

0 answers

14 views

PostgreSQL vs MongoDB which is better in storing Json data and retrieval and perform query operations [closed]

postgresql database-design mongodb json jsonb

Arun

1

modified 15 hours ago

0 votes

1 answer

20 views

Manually change datafile size or let oracle do the job during schema duplication

oracle

ik_zelf

6,552

modified 17 hours ago

2 votes

0 answers

60 views

Is this the correct way to select with updlock and then conditionally insert?

sql-server azure-sql-database deadlock

Twicetimes

263

modified 18 hours ago

0 votes

1 answer

23 views

How to query nested unamed jsonb objects and order?

postgresql query jsonb

Erwin Brandstetter

152k

modified 23 hours ago

0 votes

1 answer

27 views

ola hallengren @databasesinparallel parameter on Azure SQLServer

ola-hallengren

HandyD

9,307

answered 23 hours ago

2 votes

2 answers

297 views

Is a clustered index of 3 columns too big?

sql-server index-tuning clustered-index

Charlieface

5,768

modified yesterday

1 vote

0 answers

30 views

How to change data type of PK for very min to no maintenance while performing this action

sql-server sql-server-2014 alter-table

Newbie-DBA

713

modified yesterday

-2 votes

1 answer

40 views

Can't create MS SQL Server trigger

sql-server trigger sql-server-2019

Paul White♦

71k

answered yesterday

0 votes

2 answers

20 views

How to make unstructured array of object to row?

postgresql jsonb

Charlieface

5,768

answered yesterday

-3 votes

4 answers

62 views

Automate SQL Server reports and send them by mail

sql-server excel reporting senddbmail

Poseidon

69

modified 20 hours ago

0 votes

0 answers

24 views

How to create index for jsonb key existence?

postgresql jsonb

a_horse_with_no_name

71.3k

modified yesterday

5 votes

2 answers

270 views

Records greater than epoch timestamp using only LIKE operator

sql-server sql-server-2014 json like date-math

Paul White♦

71k

modified 2 days ago

-1 votes

0 answers

16 views

Run multiple scripts on multiple databases/servers using Try catch method with output for each individual script

sql-server powershell

ANP

1

asked yesterday

0 votes

1 answer

30 views

How does instagram handle top likes when there are millions of likes for a particular post?

bigtable

J.D.

24.6k

modified yesterday

0 votes

1 answer

20 views

Multi master vs leader-follower

mysql database-design replication distributed-databases

Rick James

68.7k

answered yesterday

26 votes

1 answer

2k views

Why MERGE doesn't insert more than 277 records into a table which is configured with temporal table and a non-clustered index on history table

azure-sql-database merge columnstore

Paul White♦

71k

modified yesterday

1 vote

2 answers

37 views

Load huge mysqldump (500G)

mysql mysqldump

Bill Karwin

9,796

answered 2 days ago

0 votes

2 answers

16 views

Optimizing querying for any of multiple terms in string

mysql query-performance mariadb

Rick James

68.7k

answered yesterday

0 votes

0 answers

16 views

How to set max_execution_time during mysqldump

mysql mysqldump

Kay

111

asked yesterday

-3 votes

0 answers

19 views

Trying to create a table in postgresql column "" of relation "" does not exist [closed]

postgresql configuration node.js

a_horse_with_no_name

71.3k

modified yesterday

0 votes

0 answers

12 views

AWS PostgreSQL RDS read-replica replication failing and lagging

postgresql amazon-rds aws read-only-database pg-hba.conf

crmpicco

145

asked yesterday

0 votes

0 answers

27 views

Why UPDATEs are faster when WHERE key is sorted in SQLite? How to improve performance?

performance update sqlite performance-tuning sqlite3

g00dds

1

asked 2 days ago

4 votes

1 answer

178 views

Can PostgreSQL use indexes to expedite count(distinct) queries?

postgresql index count distinct

Erwin Brandstetter

152k

modified Jun 25 at 1:15

-3 votes

0 answers

57 views

SQL FOR Calculate Month & Year Wise Closing

sql-server sql-server-2008-r2

jaymin

11

modified yesterday

-1 votes

1 answer

37 views

How sum over work

sql-server sum

Vérace - Слава Україні

27.2k

modified 2 days ago

0 votes

0 answers

42 views

Count the number of rows returned by the query

postgresql

philipxy

627

modified 20 hours ago

0 votes

1 answer

60 views

Query to find the count of active days (days with status = ON) between specified dates

sql-server sql-server-2016 gaps-and-islands

Paul White♦

71k

modified Jun 25 at 15:37

2 votes

0 answers

82 views

Sys.dm_os_performance_counters DMV row counts

sql-server sql-server-2017 dmv cardinality-estimates

Paul White♦

71k

modified yesterday

0 votes

1 answer

66 views

SQL Server - Find Memory ALLOCATED vs. Memory ACTUALLY USED

sql-server memory buffer-pool performance-counters

David Browne - Microsoft

40.2k

modified 2 days ago

2 votes

0 answers

23 views

Is there a way to use time series databases effectively without absolute timestamps?

database-design schema timestamp

jonsca

193

asked 2 days ago

3 votes

1 answer

42 views

gin index 'tid' array does not match table array

postgresql

CommunityBot

1

modified Jun 25 at 20:06

0 votes

1 answer

17 views

pt-online-schema-change failed when creating new tablle, specified key was too long; max key length is 767 bytes issue

mysql innodb percona percona-toolkit

Rick James

68.7k

answered 2 days ago

0 votes

1 answer

20 views

Alternate options for REORG...LONGLOBDATA for space management

db2 db2-luw

Geraldine86

1

modified yesterday

2 votes

1 answer

113 views

Can I delete these SQL Server files to clear up disk space?

sql-server sql-server-2016

st100

173

answered Jun 24 at 13:28

Top Questions

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