Post

Visualizzazione dei post da novembre, 2022

Oracle Administration. How to create a table partitioning. #oracle #dba #database #administration #plsql #partition #tuning #query

Immagine
  Oracle Administration. How to create a table partitioning. #oracle #dba #database #administration #plsql #partition #tuning #query

Postgresql Administration. Query for count rows into Schema.

Immagine
  Postgresql Administration. Query for count rows into Schema. #postgresql #psql #pgplsql #sql #dba #database #administration

Postgresql Administration. How to build a script for Analysis Logs in Bash Language, for Tuning.

Immagine
  Postgresql Administration. How to build a script for Analysis Logs in Bash Language, for Tuning. #bash #postgresql #pgplsql #sql #query #dba #database #administration #tuning

Sql Server Administration. How to load Blob image in table.

Immagine
  Sql Server Administration. How to load Blob image in table. #sqlserver #tsql #blob #varbinary #dba #database #administration #query

Postgresql Administration. How to load 'large object' (image file) into table.

Immagine
  Postgresql Administration. How to load 'large object' (image file) into table. #postgresql #dba #database #administration #plpgsql #query #sql #largeobject #lo #import

Postgresql Administration. In this example, show 'ctid' system column, which identifies the row version for each table. Furthermore, show 'xmin' and 'xmax', which identifies the ID transaction, insert,delete or update, for each row version.

Immagine
  Postgresql Administration. In this example, show 'ctid' system column, which identifies the row version for each table. Furthermore, show 'xmin' and 'xmax', which identifies the ID transaction, insert,delete or update, for each row version. #postgresql #database #dba #plgsql

Linear Regression and Sql Server. How to calculate a regression with stored. An example.

Immagine
  Linear Regression and Sql Server. How to calculate a regression with stored. An example. #statistics #mathematics #sqlserver #dba #database #tsql #sql #query