Newest Questions
105,298 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
4
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
30
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
votes
0
answers
23
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 ...
0
votes
0
answers
5
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 ...
0
votes
0
answers
29
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 -...
2
votes
1
answer
113
views
Does SQL Server have a mechanism to recover from torn page writes like PostgreSQL's full_page_writes?
I am comparing how PostgreSQL and SQL Server protect data pages from torn writes.
PostgreSQL has a feature called full_page_writes.
On the first modification to a page after a checkpoint, PostgreSQL ...
0
votes
0
answers
14
views
Oracle Database 11g refresh group
--EN
Hello. Oracle Database 11gR2.
There are two Refresh Groups: RG01 and RG02. Both refresh groups use the same database link. RG01 contains non-updatable materialized views, while RG02 contains ...
1
vote
1
answer
32
views
Is it possible to use scientific notation to display large numbers in psql?
I have tables with very large numbers, which are entered using scientific notation (e.g. 1e100). But when in the PostgreSQL's psql client (as of 18.x), they get expanded into the full length:
# SELECT ...
0
votes
0
answers
30
views
SQL AG with Windows Server 2025 Fail-over cluster
I wonder if anyone is up-to-date with the workings of Fail-over cluster in Windows Server 2025.
Since each version has their changes.
We are doing a test setup of 3 nodes on 1 location, 3 nodes on the ...
0
votes
0
answers
13
views
Problem when importing a dmp file in SQLDeveloper
I'm trying to import a dmp file in my database, so far this is the steps I've followed in a guide about how to import a dmp file in SQLDeveloper:
Open SQL Developer and connect to your database.
Go to ...
0
votes
0
answers
17
views
Configure Postgres to listen to VRF interface
I'm looking into Linux VRFs i.e. support for virtual routing and forwarding.
The documentation mentions:
Applications that are to work within a VRF need to bind their socket to the VRF device:
...
0
votes
1
answer
20
views
Datanode startup failure: Failed to unmarshall scheduled job (Invalid message format)
I encounter a startup failure when initializing my DolphinDB node. The error message points to a scheduled job deserialization issue:
:Failed to unmarshall the job [schedulejob1]. Failed to
...
0
votes
0
answers
30
views
Problems connecting with oracle through the mongodb-relational-migrator
First time asking a question here.
I'm making an assignment for my database class where I need to migrate a few tables from an OracleDB relational database to a MongoDB database using the mongodb-...
3
votes
1
answer
136
views
Querying sys.databases in a peculiar way results in "transport-level error has occurred when receiving results from the server" error
On three different production servers, the following query against sys.databases:
USE master;
GO
SELECT name
FROM sys.databases
WHERE name NOT IN ('master','tempdb','model','msdb');
Results in this ...
1
vote
0
answers
21
views
How does GridDB ensure read consistency when a TimeSeries container expands its partition during high-frequency writes?
I'm evaluating GridDB Cloud for a high-throughput IoT workload and encountered behavior that I can’t fully explain using the available documentation.
I have a TimeSeries container using default ...