Scholar

Scholar

Ask a question and accept an answer.

Awarded 23643 times.

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

Awarded 1 hour ago

Shane

1434 bronze badges

filter a column to show only two values

Awarded 12 hours ago

Leonardo Urbiola

33 bronze badges

Records greater than epoch timestamp using only LIKE operator

Awarded 13 hours ago

Elite298

615 bronze badges

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

Awarded yesterday

Gregg

1233 bronze badges

Pivoting 4 by 44 result set

Awarded yesterday

Poseidon

539 bronze badges

Postgres allow admin role to grant permissions for users on any database

Awarded yesterday

toni

1032 bronze badges

Getting first messages only for every day in a specific date range

Awarded yesterday

33a5G7s9t1e3L

214 bronze badges

How can I correct this mysql join query and put 1 to many in the same row?

Awarded 2 days ago

Andrew Kloos

1134 bronze badges

TVGuide database recurring TV Show

Awarded 2 days ago

LimetaPeta

32 bronze badges

Terminology for Specific Kind of One-to-Many Relationship

Awarded 2 days ago

user1325179

1214 bronze badges

How to Restore to AWS RDS SQL Server from TDE Enabled SQL DB(on-premises) backup file stored in S3

Awarded 2 days ago

swapna s

132 bronze badges

Return inserted entity in mysql stored procedure

Awarded 2 days ago

Amir Jani

1133 bronze badges

Select only rows where all values in a column match a value for an id

Awarded Jun 22 at 23:21

Magrathea

494 bronze badges

Why does my application have over 20,000 idle (sleeping) connections in SQL Server?

Awarded Jun 22 at 16:57

Jake McGraw

514 bronze badges

SSL Encryption for Kafka Pipelines

Awarded Jun 22 at 15:32

Matt Brown

133 bronze badges

One-to-"Zero or One" Relation

Awarded Jun 22 at 14:48

Yosua Lijanto Binar

1731 silver badge9 bronze badges

Dates - start and end vs only start

Awarded Jun 22 at 7:36

Jeremy Belolo

1133 bronze badges

How to improve simple = condition on a large table?

Awarded Jun 21 at 23:41

dabadaba

1335 bronze badges

Cannot connect to a pluggable database via IDE

Awarded Jun 21 at 9:42

Timofey Pasichnik

31 bronze badge

How to decrypt the name of columns from view?

Awarded Jun 21 at 8:55

TAHER El Mehdi

1434 bronze badges

tSQLt test problem for some DDL queries

Awarded Jun 21 at 5:52

Meyssam Toluie

1717 bronze badges

How to remove duplicates and sort in a subquery?

Awarded Jun 21 at 1:09

Jared

1235 bronze badges

Transfer content between local table to remote table

Awarded Jun 21 at 0:09

Sir_Edward

133 bronze badges

I can't create a Database after I uninstalled SQL Server and then reinstalled SQL Server

Awarded Jun 20 at 19:20

joshd2021

33 bronze badges

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

Awarded Jun 20 at 18:11

Daniel C.

3532 silver badges6 bronze badges

extracting ordered list of spatial points from JSON into PostgreSQL array

Awarded Jun 20 at 18:05

rocketboy2000

133 bronze badges

disable autocommit in PostgreSQL 13 on Oracle Linux 8

Awarded Jun 20 at 15:41

Ahmed Aldam

32 bronze badges

Distribute values

Awarded Jun 20 at 15:04

lachauj

32 bronze badges

Awarded Jun 20 at 9:25

Cristofer Feliz

133 bronze badges

FATAL: no pg_hba.conf entry for host "[local]", user "postgres", database "postgres", no encryption

Awarded Jun 20 at 2:48

Dogunbound hounds

113 bronze badges

How can you repair a MySQL 8.0 Installation after changing `character_set_system` from utfmb3 to utfmb4 fails?

Awarded Jun 19 at 19:57

shelleybutterfly

1156 bronze badges

Constraint for 2 foreign keys to have same secondary column value

Awarded Jun 19 at 19:50

Eric Johnson

1234 bronze badges

MySQL - Get counts of `car models` by `car make`

Awarded Jun 19 at 9:18

Mohal

1114 bronze badges

MySQL What charset/collation for Case insensitivity and Accent sensitivity?

Awarded Jun 19 at 1:35

lyeaf

132 bronze badges

Is it safe to use user defined variables inside stored procedures in MySQL?

Awarded Jun 18 at 18:41

Edgar Magallon

1134 bronze badges

Most recent version of SQL Server Management Studio that works with Windows 7 pre SP1?

Awarded Jun 17 at 18:26

FlexMcMurphy

1033 bronze badges

Help With Creating a Trigger

Awarded Jun 17 at 16:01

Astronomic02

32 bronze badges

How to upgrade Postgres minor version from 14.x to 14.4 in Ubuntu 20.04 LTS

Awarded Jun 17 at 13:06

sandre89

1133 bronze badges

Update statement runs for longtime and throws ORA-01654 table space error

Awarded Jun 17 at 11:19

Naga

1233 bronze badges

Update value in one table based on value of another table

Awarded Jun 16 at 1:05

MJM

1115 bronze badges

Converting large database with many tables from latin1 to utf8mb4

Awarded Jun 15 at 17:01

n0nag0n

1338 bronze badges

Do missing index DMVs work with indexed views?

Awarded Jun 15 at 10:06

Inverted Llama

1215 bronze badges

When Insert Press Name Tech Id Take Wrong Number Where Press Name Exist?

Awarded Jun 14 at 19:36

ahmed barbary

32 bronze badges

How to sum nested values from a JSON array based on conditions

Awarded Jun 14 at 16:02

wuku

233 bronze badges

Getting all shared values of two or more given values in one table (SQL)

Awarded Jun 13 at 11:30

Hape

234 bronze badges

Why does MariaDB create another key for this column when it is already part of the primary key?

Awarded Jun 12 at 1:07

jhenninger

1133 bronze badges

Sqlmap - Continuing a large query

Awarded Jun 11 at 14:57

Scott

1234 bronze badges

Why not reduce the database log file size with shrink?

Awarded Jun 10 at 5:06

hmahdavi

973 bronze badges

How to pivot multiple columns in PostgreSQL 9.5?

Awarded Jun 10 at 1:36

user11789512

32 bronze badges

Why does my stackexchange post not produce all rows?

Awarded Jun 9 at 16:25

desert_ranger

1113 bronze badges

Effect of deleting index while table is being use in postgresql

Awarded Jun 9 at 14:18

Charles angsioco

12 bronze badges

Is it a bad idea to have a "kind" column on a join table?

Awarded Jun 9 at 13:15

Thermatix

1234 bronze badges

#1064 - SQL syntax Error while trying to import

Awarded Jun 9 at 10:43

J. Scott Elblein

1035 bronze badges

What is performance impact of indexing UpdatedAt/ModifiedAt of frequently updated tables?

Awarded Jun 9 at 6:56

Ybhaw

132 bronze badges

Improving postgreSQL 13.3 performance on a materialised view?

Awarded Jun 9 at 0:20

gigz

1114 bronze badges

The best approach to abstract the item in storage database (theoretical question - no code required)

Awarded Jun 8 at 17:50

rey4eel

134 bronze badges

How to optimize the simplest SQL query of a very simple table?

Awarded Jun 8 at 12:16

Maxime Dupré

1012 bronze badges

how to join these individual queries into a single query

Awarded Jun 8 at 4:57

Divija Thommandru

52 bronze badges

Idempotent PostgreSQL schema dump that can be applied to an existing DB

Awarded Jun 7 at 15:36

Isac Casapu

1737 bronze badges

Does manual failover of availability group bind an SSL certificate?

Awarded Jun 7 at 14:36

jrdevdba

2782 silver badges7 bronze badges

2 3 4 5

…

395 Next

Stack Exchange Network

current community

your communities

more stack exchange communities