https://wiki.cayu.com.ar/ 2026-04-19T01:53:48+00:00 https://wiki.cayu.com.ar/ https://wiki.cayu.com.ar/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2017-04-24T14:18:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.cayu.com.ar/doku.php?id=notas:bases_de_datos:mssql&rev=1493043499&do=diff Microsoft SQL Server Administración Extras Scripts Ejemplo de volcado CSV de una Tabla sqlcmd -S 192.168.1.56 -d BaseDeDatos -E -W -w 999 -s "," -Q "select * from BaseDeDatos.dbo.TABLA_A_VOLCAR" text/html 2021-01-21T17:47:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.cayu.com.ar/doku.php?id=notas:bases_de_datos:mysql&rev=1611251278&do=diff Task MySQL Administración Scripts Script para listar las tablas fragmentadas y correr un optimize #!/bin/sh echo -n "MySQL username: " ; read username echo -n "MySQL password: " ; stty -echo ; read password ; stty echo ; echo mysql -u $username -p"$password" -NBe "SHOW DATABASES;" | grep -v 'lost+found' | while read database ; do mysql -u $username -p"$password" -NBe "SHOW TABLE STATUS;" $database | while read name engine version rowformat rows avgrowlength datalength maxdatalength indexle… text/html 2017-08-17T15:07:38+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.cayu.com.ar/doku.php?id=notas:bases_de_datos:oracle&rev=1502982458&do=diff Oracle * Hugepages en Linux * An Introduction to Linux Shell Scripting for DBAs * Oracle 11g: Usage of hugepages on Linux Notas de Oracle List all users/schema SET PAGESIZE 50 SELECT DISTINCT USERNAME FROM DBA_USERS; List ONLY your tables SET PAGESIZE 80 COL TABLE__NAME FORMAT a30; COL TABLE_TYPE FORMAT a30; SELECT * FROM CAT; text/html 2016-08-04T14:48:53+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.cayu.com.ar/doku.php?id=notas:bases_de_datos:postgresql&rev=1470322133&do=diff PostgreSQL How to list user accounts SELECT u.usename AS "User name", u.usesysid AS "User ID", CASE WHEN u.usesuper AND u.usecreatedb THEN CAST('superuser, create database' AS pg_catalog.text) WHEN u.usesuper THEN CAST('superuser' AS pg_catalog.text) WHEN u.usecreatedb THEN CAST('create database' AS pg_catalog.text) ELSE CAST('' AS pg_catalog.text) END AS "Attributes" FROM pg_catalog.pg_user u ORDER BY 1;