Hottest Questions Today

0

votes

0

answers

11

views

Aggregate arrays with overlapping values

postgresql

modified 1 hour ago yaugenka 101

3

votes

1

answer

39

views

Show current row “win streak”

postgresql gaps-and-islands

modified 6 hours ago Paul White♦ 54.3k

1

vote

1

answer

35

views

Best method of creating constant value [on hold]

sql-server database-design sql-server-2016

modified 8 hours ago Paul White♦ 54.3k

0

votes

1

answer

11

views

Another - ERROR: column “da2.dependency_device_name” must appear in the GROUP BY clause or be used in an aggregate function

postgresql group-by aggregate string-aggregation

answered 5 hours ago jjanes 14.4k

0

votes

1

answer

18

views

Finding all users with access to a table in SQL server

sql-server security

answered 8 hours ago Learning_DBAdmin 623

0

votes

0

answers

23

views

Configure CPU/IO affinity - SQL 2017 Standard

sql-server sql-server-2017

asked 10 hours ago Kris 14

0

votes

0

answers

18

views

Optimize MySql Self Cross Join and Grouping - Preorder Tree Traversal Algorithm

mysql optimization mysql-8.0 tree

modified 10 hours ago Prabakaran 1

10

votes

3

answers

268

views

Converted a Scalar function to a TVF function for parallel execution-Still running in Serial mode

sql-server query-performance performance-tuning parallelism scalar-function

modified yesterday Martin Smith 64.6k

16

votes

2

answers

1k

views

Is it possible for SQL statements to execute concurrently within a single session in SQL Server?

sql-server sql-server-2012

modified 2 days ago David Browne - Microsoft 12.7k

1

vote

0

answers

20

views

Why Mysql Fabric is end of life, and what is an alternative?

mysql mysql-fabric

modified 16 hours ago Wayne Wang 106

15

votes

4

answers

906

views

What is the appropriate index architecture when forced to implement IsDeleted (soft deletes)?

sql-server sql-server-2012 index

answered yesterday Rick Ryker 141

1

vote

0

answers

25

views

In memory table vs temporary table - benefits if temdb in already on ram disk

sql-server sql-server-2016 tempdb in-memory-database

asked 18 hours ago gotqn 1,555

1

vote

2

answers

46

views

Database recovery pending on external drive

sql-server sql-server-2016

answered 8 hours ago Karan.T. 16

1

vote

1

answer

25

views

Postgesql non-deterministic order of result with LIMIT and ORDER BY

postgresql

answered 22 hours ago Aaron Bertrand♦ 154k

0

votes

0

answers

17

views

Is it possible to create a has many relationship between a pivot table and another table?

mysql pivot many-to-many

modified 19 hours ago Pouneh 1

0

votes

1

answer

25

views

Why does year 0 become year 2000?

postgresql date

modified yesterday dvtan 314

7

votes

1

answer

275

views

Why doesn't SQL Optimizer use my constraint?

t-sql sql-server-2016

modified yesterday Martin Smith 64.6k

-1

votes

0

answers

37

views

SQL Server: how to get statistics sizes? [on hold]

sql-server t-sql statistics

asked yesterday Covi 102

0

votes

1

answer

24

views

SQLServer - Multiple PIVOT on same column

sql-server

answered 10 hours ago Avinash Kumar 19

11

votes

1

answer

648

views

If a VARCHAR(MAX) column is included in an index, is the entire value always stored in the index page(s)?

sql-server varchar

modified 2 days ago Joe Obbish 22.2k

0

votes

1

answer

22

views

Entity-relationship model decision

database-design

answered yesterday Michael Kutz 2,227

0

votes

1

answer

34

views

How to JOIN with missing rows?

mysql join query

modified yesterday Vérace 16.5k

0

votes

0

answers

16

views

TimescaleDB performance

postgresql performance timescaledb

asked yesterday Vladimir Kanazir 1

0

votes

0

answers

64

views

Differences between CTE and subquery select tables

sql-server t-sql subquery cte

modified yesterday Andriy M 16.3k

1

vote

0

answers

33

views

is it possible to trim the table output for a specific job?

sql-server jobs scripting logs troubleshooting

asked yesterday marcello miorelli 6,211

1

vote

1

answer

22

views

PostgreSQL (10) show all NOTICE messages

postgresql

answered yesterday a_horse_with_no_name 41.8k

0

votes

0

answers

13

views

Unique sets of IDs from table

postgresql many-to-many

asked yesterday Tom O'Connell 1

0

votes

1

answer

32

views

mysql - can a slave have a different primary key than the master?

mysql replication primary-key

modified 12 hours ago RolandoMySQLDBA 144k

1

vote

1

answer

27

views

Optimize MySQL InnoDB query for SUM and Order By

mysql query-performance innodb optimization

modified yesterday Acidon 112

1

vote

0

answers

33

views

Postgres serializable transactions not enforcing isolation when joins are involved

postgresql isolation-level

modified yesterday sudont 6

4

votes

2

answers

112

views

Run Powershell Script From Agent As Administrator

sql-server-2014 powershell windows-server-2012

modified 2 days ago Max Vernon 52.6k

1

vote

1

answer

24

views

How to setup encryption on a column that joins two tables in two different databases

sql-server sql-server-2012 encryption

answered 12 hours ago Michael Keleher 679

0

votes

1

answer

24

views

Upgrading PostgreSQL 9.3 to 9.5

postgresql upgrade

modified yesterday Paul White♦ 54.3k

1

vote

1

answer

23

views

How should I build the architecture of my MongoDB database?

mongodb node.js

answered yesterday Mani 421

1

vote

2

answers

26

views

SQL Job Agent Service Account - Access is denied to run Powershell

sql-server sql-server-2008-r2

modified yesterday Randi Vertongen 5,071

0

votes

0

answers

15

views

Machine Requirement for Config Server of a MongoDB Sharding Cluster

mongodb sharding

asked yesterday Christian Sicari 6

6

votes

2

answers

246

views

Is there such thing as an Availability Group failover trigger?

sql-server

modified Apr 17 at 19:31 Allan Hirt 74

0

votes

0

answers

30

views

Create indexed view with fluctuating data behind

sql-server view materialized-view

asked yesterday Grashee 1

0

votes

0

answers

21

views

Multiple MySQL database to One database - Bidirectional

mysql merge-replication data-synchronization dimensional-modeling

asked yesterday Thanga Pandiyan GSR 1

3

votes

2

answers

58

views

Merge Only Events that Start immediately after the Previous Event without any Gap

sql-server gaps-and-islands date-math

modified 2 days ago Thomas Newton 23

6

votes

2

answers

822

views

On SQL Server, is it possible to restrict certain users from using certain functions, operators or statements?

sql-server query-performance execution-plan

modified Apr 17 at 15:24 James Jenkins 2,282

1

vote

0

answers

17

views

SQL Server replication - Could not add new article to publication

sql-server replication

asked yesterday bontade 118

3

votes

0

answers

24

views

How are Transaction IDs compared in Postgres?

postgresql

asked yesterday dsinecos 16

2

votes

1

answer

41

views

Why Subquery do not filter the result in multiple Subquery

mysql subquery mysql-8.0

modified yesterday Rhidoy 24

0

votes

1

answer

39

views

PostgreSQL 11: how to partition 1000 tenants

postgresql partitioning

modified yesterday Laurenz Albe 158

0

votes

0

answers

14

views

RDS Aurora postgres temp files removal

postgresql postgresql-9.6 amazon-rds-aurora

asked yesterday Spike 292

Top Questions

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