CAST and CONVERT (Transact-SQL)
MySQL AB :: MySQL 5.0 Reference Manual :: 13 SQL Statement Syntax
SQL Tutorial
Reference / manual for the XmlHttpRequest object
How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server
Funzione PHP per calcolare la dimensione totale di una cartella
MySQL :: MySQL 5.1 Reference Manual :: 11 Functions and Operators
ORACLE-BASE - SQL trace, 10046, trcsess and tkprof in Oracle 10g
Come abilitare il trace SQL in Oracle
SQL Trace - Oracle FAQ
si può sostituire v$session.audsid=sys_context('userenv','sessionid'); con v$session.sid=XXX
Rebuild or Reorganize: Configure SQL Server Index Maintenance
Learn the difference between index 'Rebuild' and 'Reorganize', and how to select which is right for you.
Microsoft SQL Server Version List
V$SQL
Esempio: SELECT EXECUTIONS, ROUND(ELAPSED_TIME/EXECUTIONS/1000000, 3) SEC, MODULE, PARSING_SCHEMA_NAME, SQL_TEXT FROM V$SQL ORDER BY ELAPSED_TIME/EXECUTIONS DESC
ORACLE-BASE - Materialized Views in Oracle
Use materialized views (snapshots) to replicate data to a remote database.
V$SQLSTATS
Simile a V$SQL ma più indicata per analizzare le prestazioni delle query, anche non più in cache
SQL SERVER - Find the Size of Database File - Find the Size of Log File - SQL Authority with Pinal Dave
"SELECT DB_NAME(database_id) AS DatabaseName, Name AS Logical_Name, Physical_Name, (size*8)/1024 SizeMB FROM sys.master_files WHERE DB_NAME(database_id) = 'AdventureWorks'"
SQL Server Backup, Integrity Check, Index and Statistics Maintenance
Award-Winning SQL Server Maintenance Solution for backup, integrity check, index and statistics maintenance in SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016, and 2017
How to migrate a SQL Server database to a lower version
In this tip we take a look at one approach to downgrade a SQL Server database to a lower version of SQL Server since a simple backup and restore will not work.
Oracle SQL materialize Hint
Unable to connect on Ubuntu 16.04 to SQL in container · Issue #2150 · Microsoft/sqlopsstudio · GitHub
SQL Operations Studio Version: 0.31.4 Steps to Reproduce: docker run -d -p 15789:1433 --env SA_PASSWORD=Testing1122 --env ACCEPT_EULA=Y microsoft/mssql-server-linux Error when connecting to 127.0.0...