Newest Questions
105,303 questions
0
votes
0
answers
13
views
Why can’t I detect a previous failed attempt of the current SQL Agent job step during a retry?
I am trying to detect, from within a SQL Agent job step itself, whether the current step is being retried (i.e., whether it has already failed once in the same job execution).
My SQL Agent job is ...
- 57
0
votes
0
answers
9
views
SQL Server with Latin1_General_CI_AS collation migrating to Postgres 18
We are migrating from SQL Server 2022 to Postgres 18.
We were using CIText for case insensitive functionality similar to SQL Server with collation English_United Kingdom.1252.
With the release of ...
- 31
0
votes
1
answer
24
views
Can CREATE DATABASE ... FOR ATTACH be used to seed an Availability Group with a SAN snapshot?
Users of SQL Server 2022 can use SAN snapshots to seed an Availability Group, as shown here. However, this uses 2022 constructs like BACKUP DATABASE ... WITH METADATA_ONLY.
I am on SQL Server 2022, ...
- 1,394
0
votes
1
answer
26
views
Updating stats other than sp_updatestats
I am hosting a SQL Server database at a customer and need to run sp_updatestats.
My user that has been assigned does have db_owner permissions but they cannot give me sysadmin permissions. From what I'...
- 101
0
votes
0
answers
9
views
Why does migrate fail with "Memory size of append data exceeds max limit" when restoring a TSDB table?
I have a DolphinDB table dfs://derived_financial_metrics_bk.financial_metrics which is partitioned by DAY and uses the TSDB engine.
I successfully backed up the entire table using the backup function ...
0
votes
0
answers
2
views
Impact of writes on DC specific Master which is actually slave of Main Group replication
Team have Database architecute where orgnisation having 10 datacenter . On primary datacenter databasee having 3 node Group replication cluster and Group replication cluster replicating data across ...
0
votes
1
answer
25
views
SSAS 2019 Tabular processing returns “Success” with 0 rows when using Snowflake via ODBC (MSDASQL)
I’m migrating an on‑prem SSAS 2019 Tabular model from SQL Server (local) to Snowflake. The model is deployed, and I’ve added a new legacy data source via 64‑bit ODBC. Processing a table in SSMS ...
- 101
0
votes
0
answers
17
views
New infrastructure purchased by organization - best way to proceed
I am a relatively new DBA in a small university which is in the process of large scale infrastructural change. It's my first official role as DBA.
While I'm in charge of the Oracle cloud database (...
- 123
0
votes
2
answers
22
views
Are leaf nodes on an InnoDB secondary index sorted by both secondary and primary key columns?
For example, if a table has columns A, B, ID, and (ID) is the primary key, and (A) is a secondary index.
I wonder if the leaf nodes on the secondary index (A) is sorted by (A,ID), or just (A), and the ...
- 103
1
vote
1
answer
222
views
How to avoid an "invalid locale" error when restoring a dump from Windows to Debian Linux?
Postgres 17 cluster is in Windows server in Estonian locale. Databases are defined like
CREATE DATABASE mydb
WITH
OWNER = mydb_owner
ENCODING = 'UTF8'
LC_COLLATE = 'et-EE'
LC_CTYPE ...
- 143
2
votes
1
answer
82
views
After recovering from session timeout expiry, at what point does the primary start waiting on synchronous replicas to harden?
The documentation tells us what happens when session timeout for a synchronous Availability Group replica expires
"Even if a disconnected replica is configured for synchronous-commit mode, ...
- 1,394
0
votes
0
answers
32
views
MySQL comparing a string to int returns a wrong result when string is numbers seperated by -
Apologies if this is a duplicate question but I was unable to find the correct result but that could be down to the phrasing of my question but here goes.
I have a table with BIGINT primary keys. I ...
0
votes
0
answers
31
views
Are constraints(foreign key)errors being logged on the server side (MySQL 8.0.39)?
Are constraints (specifically: foreign key) errors being logged on the server side (MySQL 8.0.39)?
The question arose because there was a migration problem and the number of errors exploded on the ...
0
votes
1
answer
51
views
What is the name/abbreviation of the PostgreSQL dialect and how to highlight it in Markdown?
Question
I know TSQL is the SQL dialect of Microsoft dialect. However, I failed to find an equivalent for PostgresSQL. Thus I ask, what is the name/abbreviation of the PostgreSQL dialect?
My initial ...
- 103
0
votes
0
answers
13
views
Massive import of blob files in SQLDeveloper
I'd like to know if there's some way to do a massive import of blob files in SQLDeveloper, indicating such blob files in the file system and how it would have to do the import
Right now, it looks that ...
- 145