Newest Questions
105,298 questions
3
votes
1
answer
150
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 ...
- 1,573
0
votes
0
answers
16
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
1
vote
1
answer
39
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 ...
- 3,850
0
votes
0
answers
35
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 ...
- 1
0
votes
0
answers
14
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 ...
- 145
0
votes
0
answers
19
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:
...
- 101
0
votes
1
answer
49
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
...
- 3
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-...
- 1
3
votes
1
answer
158
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 ...
- 33.3k
1
vote
0
answers
23
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 ...
- 51
1
vote
2
answers
100
views
MSSQL Performance gain when clearing out (large size) filestore-table records?
On MSSQL (our DB size is 520g), there is one filestore table that holds tons of files. 65-70% of this 520g is sitting in there. So essentially, it's a 200g database with 320g worth of files in this ...
0
votes
1
answer
29
views
Oracle: Insufficent privileges when compiling a stored procedure as DBA role
I'm complining a stored procedure as user with DBA role. The stored procedure contains several "DELETE" statements. For each of them I'm getting:
PL/SQL: SQL Statement ignored
PL/SQL: ORA-...
- 221
5
votes
0
answers
140
views
Could BEGIN/END really be used inside CASE in SQL Server 2005?
The (still online) documentation for MS SQL Server 2005 states that BEGIN...END blocks can be used within CASE when it needs to execute a sequence of statements:
The BEGIN and END statements are used ...
- 692
0
votes
0
answers
19
views
The flow table exceeded its length and was not automatically deleted
The flow table exceeded its length and was not automatically deleted. The speed of writing quotes to DolphinDB is about 10,000 lines per second.
dolphindb code:
colNames = `securityid`date`time`...
-2
votes
0
answers
27
views
流表超出长度没有自动删除The flow table exceeded its length and was not automatically deleted [closed]
建表代码
// pub_shl2_rapid
colNames = securityiddatetimelocal_timequote_typemarketprecloseopenhighlowlasthighlimitlowlimitiopvtotal_volume_tradetotal_value_tradeask_pricesbid_pricesask_volumesbid_volumes
...