Newest Questions
105,298 questions
0
votes
0
answers
10
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
8
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
13
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 ...
- 101
1
vote
1
answer
134
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
0
votes
1
answer
22
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,362
0
votes
0
answers
31
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
29
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
45
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
0
votes
0
answers
18
views
How to build dynamic configuration for maxscale to upload it to Galera DB cluster
I need to configure for 1 maxscale, then upload the configuration to Galera DB Cluster of 3 nodes.
Maxscale nodes added later will pull the configuration from the Database cluster, not synchronize ...
Sơn Nguyễn
0
votes
1
answer
26
views
Why does loading plugins fail with "cannot open shared object file" on an ARM-based Linux VM?
I am running DolphinDB Server (version 2.00.16.4) on a Linux virtual machine on my MacBook (Apple Silicon / ARM architecture).
When I try to load the MySQL plugin, I encounter the following error:
...
1
vote
1
answer
45
views
SQL Server Profiler 22 won't open on ARM
After installing SQL Server Profiler 22, I get the following error when opening the application?
---------------------------
PROFILER.exe - System Error
---------------------------
The code execution ...
- 2,708
3
votes
0
answers
46
views
Does partitioning allow filegroups with LOB data to be shrunk?
It is extensively documented that shrinking any data files that have LOB pages is awful:
Microsoft says you need to read the whole partition once for every page you want to move.
The well-known ...
- 1,362
0
votes
0
answers
10
views
How do I convert RoleIds list from Secodary_role_stats in the query_history view to role_names?
I am trying to confirm a particular role is not in use before I delete it. The query_history view supplies the name of the primary role; however there's a chance it might also be in use as a secondary ...
- 101
0
votes
0
answers
39
views
SQL Server Express programmatic installation gets stuck at "Installing..."
I'm trying to do an automated installation of SQL Server Express via powershell, aided by chocolatey.
First, I install chocolatey using the following PowerShell snippet:
Set-ExecutionPolicy Bypass -...
- 101