Hottest Questions Today

0

votes

1

answer

19

views

How can I get all data from a given table since my last run?

oracle oracle-12c

modified 59 mins ago Patrick Szalapski 173

0

votes

0

answers

13

views

SQL Agent Job or SQL Alert for Long Running Queries

sql-server

modified 28 mins ago iPorritt 1

0

votes

1

answer

26

views

Shrink data file corruption risks?

sql-server sql-server-2014

answered 4 hours ago Tibor Karaszi 8,138

1

vote

2

answers

35

views

Stop SQL job if it runs past a certain time

sql-server stored-procedures dynamic-sql

answered 3 hours ago WAMLeslie 11

0

votes

0

answers

17

views

Order of tables affects the use of index

postgresql-performance postgis

asked 3 hours ago amball 123

-2

votes

3

answers

28

views

CVE-2021-1636 security update for SQL Server

sql-server security cumulative-update

modified 4 hours ago lidnuq 1

0

votes

2

answers

29

views

Backup to unc path in workgroup environment

sql-server powershell

answered 2 hours ago user1716729 593

0

votes

0

answers

15

views

Install PFX certificate on SQL 2008 R2

sql-server sql-server-2008-r2 windows certificate

asked 4 hours ago Stijn Leenknegt 101

0

votes

0

answers

11

views

How do I set up a self referential relationship using postgresql and sqlalchemy

postgresql sqlalchemy

asked 4 hours ago user2696276 1

0

votes

2

answers

30

views

EMP_DEPT database. Try to SELECT records with smallest salary, NULL column record is missing

sql-server select

modified 4 hours ago Vérace 21.8k

0

votes

1

answer

21

views

How to UPDATE data without locking every record the search encounters?

mysql database-design deadlock application-design design-pattern

modified 4 hours ago Daan 121

-1

votes

1

answer

25

views

insert into OPENROWSET / SET IDENTITY_INSERT

sql-server

modified 4 hours ago Danielle Paquette-Harvey 1,578

0

votes

1

answer

18

views

sql column names with single quotes

mysql

answered 7 hours ago Phill W. 4,210

3

votes

2

answers

144

views

How to handle divide by zero in GENERATED columns in MySQL

mysql generated-columns

modified 13 hours ago Vérace 21.8k

0

votes

1

answer

30

views

SQL (Postgres): Subquery in WHERE clause with IN operator is slow

postgresql performance select subquery

modified 9 hours ago Lennart 19.2k

0

votes

0

answers

13

views

How to check active connections in PostgreSQL?

postgresql

asked 9 hours ago Michał Lipok 1

1

vote

1

answer

88

views

How can I investigate why Sql Server is chosing the “wrong” Index?

sql-server index execution-plan

modified 6 hours ago Josh Darnell 23.4k

3

votes

2

answers

51

views

Is using CLR for regular expressions safer than using external scripts?

sql-server python sql-clr regular-expression external-scripts

modified 50 mins ago Solomon Rutzky 61.2k

0

votes

1

answer

15

views

What contributes to the transaction size on a MySQL UPDATE?

mysql mysql-innodb-cluster group-replication

answered 9 hours ago J.D. 8,831

29

votes

4

answers

3k

views

What does the GO statement do in SQL Server?

sql-server

modified yesterday Colin 't Hart 7,684

-1

votes

1

answer

30

views

Availability Group is not failovering when a cluster core resource is failedover

sql-server availability-groups clustering failover role

modified 15 hours ago MBuschi 364

0

votes

2

answers

16

views

How to use a postgres variable in the select clause

postgresql

answered 16 hours ago a_horse_with_no_name 60.3k

-1

votes

2

answers

55

views

What is the correct way to do a computed column with complex logic with performant sorting and filtering at scale in MS SQL Server?

sql-server materialized-view computed-column

modified 20 hours ago J.D. 8,831

-2

votes

0

answers

39

views

Vm went out of space due to database restore

sql-server restore disk-space vmware

modified 13 hours ago John K. N. 12.8k

0

votes

3

answers

49

views

High CPU and plan cache instability

sql-server memory plan-cache cpu

answered 7 hours ago Josh Darnell 23.4k

0

votes

2

answers

28

views

Multiple disks vs single disk on virtualized environment

performance sql-server-2017 virtualisation

modified 23 hours ago J.D. 8,831

4

votes

2

answers

173

views

Postgres not returning data on array_agg query as below

postgresql join array coalesce sqlalchemy

modified yesterday Erwin Brandstetter 126k

0

votes

2

answers

24

views

Count Rows that exist before and not after and after but not before

sql-server join count

answered 18 hours ago Akina 13.8k

0

votes

1

answer

14

views

Does pg_restore continue after internet connection got lost

postgresql pg-restore

answered 15 hours ago Laurenz Albe 18.6k

-2

votes

0

answers

25

views

conversion failed when converting datetime from character string while inserting and updating to database

sql-server update c#

asked 21 hours ago Mark Luzon 1

0

votes

2

answers

20

views

MySQL high CPU usage under medium load

mysql magento

answered 15 hours ago ROHIT KHURANA 101

2

votes

2

answers

35

views

Retain indent formatting when compiling a stored procedure without Data Studio

stored-procedures db2 command-line deployment

modified 2 hours ago Max Vernon♦ 63.9k

0

votes

1

answer

18

views

Connecting to “foreign” database on the same DBMS

mysql mariadb jdbc

answered 21 hours ago mustaccio 17.3k

0

votes

0

answers

21

views

Looking for some asistance in understanding mysql status

mysql linux debian

modified 12 hours ago plisken 1

2

votes

1

answer

70

views

To reduce recovery time (and save space): Is it possible to ignore some PostgreSQL 13 tables (or schemas) when backing up using Barman?

postgresql backup barman

answered yesterday Laurenz Albe 18.6k

0

votes

2

answers

37

views

Do I need a domain controller for multiple PCs accessing the same SQL server db? How do I configure it?

sql-server windows network windows-10

answered yesterday David Browne - Microsoft 29.2k

0

votes

3

answers

29

views

DB2, How to save all stored procedures as files

stored-procedures db2 scripting version-control

modified yesterday Lennart 19.2k

1

vote

1

answer

23

views

Pointing the database secondary data file towards a network drive

sql-server-2014 storage disk-structures data drive-space

modified yesterday Danielle Paquette-Harvey 1,578

0

votes

2

answers

21

views

Unknown column in 'where clause' when using an alias for a subquery in MySQL

mysql where alias

answered yesterday nbk 4,428

-2

votes

1

answer

29

views

Joining two left join queries

sql-server

modified 14 hours ago McNets 21.2k

1

vote

1

answer

20

views

PostgreSQL: Delete Multiple Rows with multiple Conditions from the same table

postgresql query-performance delete

modified yesterday Erwin Brandstetter 126k

0

votes

1

answer

21

views

Permission denied for view beyond its own schema

postgresql permissions schema view

modified yesterday Chickenmarkus 101

1

vote

2

answers

60

views

Performance issues since migrating from SQL Server 2012R2 to 2019

sql-server performance execution-plan sql-server-2019

modified 14 hours ago user1673665 135

0

votes

1

answer

26

views

“ORA-03146: invalid buffer length for TTC field” after upgrade from Oracle 12 to 19c

oracle upgrade

answered yesterday Balazs Papp 35.4k

1

vote

1

answer

23

views

Accessing Memory Optimised Tables Under Snapshot Isolation

t-sql sql-server-2016 isolation-level memory-optimized-tables

answered yesterday NedOtter 772

2

votes

1

answer

23

views

Different datatypes different execution plans bitmap scan vs index scan POSTGRESQL

postgresql query

answered yesterday raayan 58

-1

votes

1

answer

15

views

Error 1005 errno 150 “Foreign key constraint is incorrectly formed” where no foreign key declared

mysql primary-key mysql-8.0

modified yesterday RolandoMySQLDBA 162k

1

vote

2

answers

31

views

MS SQL Server: Log Backup LSN Mismatch

sql-server

answered yesterday Frederik 23

Top Questions

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