What does it mean when pg_stat_activity.datname is NULL?
postgresql
PeterVandivier
PeterVandivier
How do I change a cte expression to a regular query?
5
mysql-8.0
Anonymous 1440
Anonymous 1440
5
The part inside the brackets in `AS ( … )`, i.e. the nested query itself:
Mikael Eriksson
Do multiple updates to the same row cause more table bloat?
5
postgresql
Jack Douglas
Jack Douglas
6
**tl;dr**: No. Yes. Multiple updates to the same row within a transaction will add additional dead tuples to the heap. However this is not the case for multiple updates within a single statement.
Jack Douglas
FORMAT 'G17' vs 'G'
sql-server-2019
Cade Roux
Cade Roux
11
`FORMAT` is implemented in CLR, but the overall question can be answered in T-SQL terms.
Paul White
How to apply filter to rows that belong to the same "group"?
sqlite
FoggyFinder
FoggyFinder
3
This is a perfect example of where "Window Functions" are useful.
Jack Douglas
Problem with CHARACTER SETs and ENCODING on MySQL fiddle.
4
dbfiddle
mysql
Vérace
Vérace
8
I found the problem. As I had suspected, the following system session variables are all set to `latin1`:
Solomon Rutzky
I have to put the tempdb on the same disk with data and logs, how to mitigate risk?
2
sql-server
James Jenkins
James Jenkins
6
Probably the simplest way would be to turn off autogrowth for all tempdb files, making sure to set them to a reasonable fixed-size based on your workload and available space.
Josh Darnell
edit the code so that it calculates post reference year as well.
37
netezza
Anonymous 1299
Anonymous 1299
Reverse string by parts with strict ordering
postgresql
PeterVandivier
PeterVandivier
4
If you want to guarantee ordering (and you should), you can use [with ordinality](https://www.postgresql.org/docs/12/queries-table-expressions.html#QUERIES-TABLEFUNCTIONS) since version 9.4, along with an aggregate with [order by](https://www.postgresql.org/docs/12/sql-expressions.html#SYNTAX-AGGREGATES):
Jack Douglas
