Most active questions

Ask Question
20 questions from the last 7 days
Newest Active Bountied Unanswered
3 votes
1 answer
150 views

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 ...
Artashes Khachatryan's user avatar
  • 1,573
1 vote
1 answer
138 views

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 ...
Andrus's user avatar
  • 143
0 votes
1 answer
45 views

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 ...
rugk's user avatar
  • 103
1 vote
1 answer
45 views

After installing SQL Server Profiler 22, I get the following error when opening the application? --------------------------- PROFILER.exe - System Error --------------------------- The code execution ...
Mitch's user avatar
  • 2,708
0 votes
1 answer
22 views

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, ...
J. Mini's user avatar
  • 1,362
3 votes
0 answers
46 views

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 ...
J. Mini's user avatar
  • 1,362
0 votes
0 answers
39 views

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 -...
Josh Brunton's user avatar
  • 101
0 votes
0 answers
35 views

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 ...
Smee's user avatar
  • 1
0 votes
0 answers
29 views

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 ...
AndersonCode42's user avatar
  • 1
0 votes
2 answers
13 views

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 ...
Name Null's user avatar
  • 101
0 votes
0 answers
31 views

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 ...
UrbanwarfareStudios's user avatar
  • 101
0 votes
1 answer
26 views

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: ...
xiyan zheng's user avatar
  • 1
0 votes
0 answers
14 views

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 ...
user2638180's user avatar
  • 145
1 vote
1 answer
39 views

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 ...
tinlyx's user avatar
  • 3,850
0 votes
0 answers
13 views

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 ...
user2638180's user avatar
  • 145

15 30 50 per page
1
2