Pinned Loading

1. Sql Server SQL Sql Server SQL

   1

   2

   -- Al crear columna añadir COLLATE Modern_Spanish_CI_AS justo tras el tipo varchar:

   3

   ColumnaTexto varchar(XXX) COLLATE Modern_Spanish_CI_AS

2. SQL Server 2014 - Useful queries SQL Server 2014 - Useful queries

   1

   https://stackoverflow.com/a/1433384/2906290

   2

   3

   declare @schema_name nvarchar(256)

   4

   declare @table_name nvarchar(256)

   5

   declare @col_name nvarchar(256)

3. OracleDB Resources OracleDB Resources

   1

   2

   https://oracle-base.com/dba/scripts

   3

   4

   https://www.morganslibrary.org

   5

4. Oracle DB 12c - DWH Optimization Oracle DB 12c - DWH Optimization

   1

   Cuestiones a estudiar

   2

   =====================

   3

   Cuestiones a plantearse para cada layer (Staging -> Foundation/Integration -> Dimension/Performance). 

   4

   5

   Generales

5. ORACLE DB - snippets, tips, best pra... ORACLE DB - snippets, tips, best practices

   1

   -- ¡¡¡¡Resumenes con ejemplos de cada tema!!!!

   2

   http://www.morganslibrary.org/library.html

   3

   4

   https://lalitkumarb.wordpress.com/2014/05/31/oracle-explain-plan/

   5