Questions tagged [documentation]
The documentation tag has no summary.
55 questions
0 votes
1 answer
35 views
WAL record action code dictionary
I'm exploring the module wal2json for the first time. I've set up the replication slot using the ReadMe examples. When peeking the replication slot, every data value begins with an "action" ...
- 5,951
4 votes
1 answer
132 views
"The data type of a column of a partitioned table can't be changed."
The documentation claims The data type of a column of a partitioned table can't be changed. It repeats this claim elsewhere such as here. Yet I have never seen this fail. CREATE PARTITION FUNCTION ...
- 1,342
1 vote
0 answers
90 views
Understanding of sqlplus STARTUP command syntax
On https://docs.oracle.com/en/database/oracle/oracle-database/19/sqpug/STARTUP.html, the document states that: Startup command ... where db options has the following syntax: [FORCE] [RESTRICT] [...
- 2,126
-3 votes
1 answer
102 views
How do you document an existing SQL database owned by someone else? [closed]
I am working with an existing Microsoft SQL database that does not have documentation. I want to write documentation for myself. However, because I did not create this database myself, I want to avoid ...
- 111
-2 votes
1 answer
30 views
Online docs has incorrect JVM flag unsafe_aggressive_sstable_expiration for TimeWindowCompactionStrategy
I was installing the unsafe_aggressive_sstable_expiration and found out that there is a mistake in the documentation. The documentation told us that we needed to enable in the jvm -Dcassandra....
1 vote
1 answer
114 views
Understanding "Mode" Parameter and Finding Documentation for Event Properties in SQL Server
I'm working with an extended event session in SQL Server and encountered a part of the T-SQL code that I don't fully understand. Specifically, I'm puzzled by the use of "Mode = 3 OR Mode = 4"...
- 1,239
-1 votes
1 answer
87 views
Is there any pattern behind the naming conventions of PostgreSQL Table-Level Locks?
I know that PostgreSQL has 8 level of table locks which are, from least restrictive to most: ACCESS SHARE ROW SHARE ROW EXCLUSIVE SHARE UPDATE EXCLUSIVE SHARE SHARE ROW EXCLUSIVE EXCLUSIVE ACCESS ...
- 113
3 votes
1 answer
163 views
Error in the documentation MariaDB -> mysqlbinlog: `--rewrite-db` and `--database`
In the mysqlbinlog utility documentation, the --rewrite-db=name option has the following explanation Filtering (e.g. with --database=name ) happens AFTER the database rewrites have been performed. ...
- 614
1 vote
2 answers
3k views
Is it possible to create a comment for a table in postgres? If not - how is a table typically documented in a similar manner to columns
It's possible to have documentation of a particular column within a postgres table, as it outlined here: How to add comment to a column in a table in Postgres? I'm not sure how to create a comment for ...
- 326
0 votes
2 answers
587 views
How does SQL Server delayed durability work?
I'm reading documentation for the delayed durability feature of SQL Server and saw this table: It states that database level settings always take precedence over commit level seeing. But I'm not able ...
- 1,239
0 votes
2 answers
238 views
I think SQL Docs are wrong for sys.dm_db_index_physical_stats
Go to this documentation page: https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-index-physical-stats-transact-sql?view=sql-server-ver15 Then go to ...
- 363
0 votes
1 answer
97 views
What does "through another column" mean in the MySQL docs?
In the MySQL doc section on avoiding full table scans, one of the cases in which MySQL will use a full table scan is described like so: You are using a key with low cardinality (many rows match the ...
- 599
0 votes
1 answer
74 views
How to organise and understand a terribly modelled database
I have recently joined a company where there are hundreds of schemas and thousands of tables. All the schemas we have are from other vendors who have allowed us access to their database. The entire ...
2 votes
2 answers
136 views
Where is the documentation for version 1.0 of PostgreSQL wire protocol
The current documentation refers only to version 3 of the wire protocol. However, there is the following note in the documentation: For descriptions of the earlier protocol versions, see previous ...
- 145
14 votes
1 answer
2k views
Is this an error in SQL Server's documentation for ROLLBACK?
This is the SQL Server's document talking about the ROLLBACK statement. On that page it states that the syntax of it is as follows: ROLLBACK { TRAN | TRANSACTION } [ transaction_name | @...
- 2,126