Deeejay's Pastebin

3,177 13,559 0 10 years ago

Name / Title	Added	Expires	Hits	Syntax
TSQL - Hash Tables	Jul 11th, 2023	Never	8	None	-
TSQL - Round Robin Tables	Jul 11th, 2023	Never	8	None	-
AutoIt - IE Browser Window	Dec 29th, 2015	Never	319	AutoIt	-
DOS - Windows Server Free Disk Space	Jun 22nd, 2016	Never	55	None	-
dsquery commands for AD	Jun 11th, 2014	Never	304	Batch	-
SQL - Cerner Encounter/SurgiNet Location History	Feb 1st, 2016	Never	387	Oracle 11	-
SQL - Cerner Procedure and Diagnosis queries	Jan 29th, 2016	Never	130	SQL	-
SQL - Get database versions	Nov 23rd, 2015	Never	97	SQL	-
SQL to calculate distance between LAT LONG	Nov 20th, 2015	Never	81	SQL	-
SQL - Date/Time Functions	Nov 10th, 2014	Never	392	T-SQL	-
SQL - Generate combinations of two columns	Mar 11th, 2014	Never	168	Oracle 11	-
MSSQL - Get table names and row count	Dec 26th, 2013	Never	96	SQL	-
psql - Check if table is used in any views	Apr 24th, 2018	Never	83	PostgreSQL	-
PostgreSQL - Find erroneous queries	Dec 14th, 2017	Never	24	PostgreSQL	-
psql - md5 hash entire row	Aug 5th, 2016	Never	101	PostgreSQL	-
psql - List all indexes	Aug 2nd, 2016	Never	95	PostgreSQL	-
PostgreSQL - Use PHP to Output Data in JSON Format (2)	Jun 14th, 2016	Never	176	PHP	-
PostgreSQL - Use PHP to Output Data in HTML Table	Jun 14th, 2016	Never	116	PHP	-
PostgreSQL - Use PHP to Output Data in JSON Format	Jun 14th, 2016	Never	106	PHP	-
PgBench - Commands	Apr 11th, 2016	Never	103	Bash	-
PostgreSQL - Ubuntu Install Script	Apr 8th, 2016	Never	72	PostgreSQL	-
PostgreSQL - Truncate old csv logs	Apr 8th, 2016	Never	47	PostgreSQL	-
psql - Cancel long running queries	Mar 3rd, 2016	Never	127	PostgreSQL	-
PostgreSQL - Aggregate Functions	Feb 16th, 2016	Never	82	PostgreSQL	-
psql - DJ's Table Performance Query	Jan 28th, 2016	Never	111	PostgreSQL	-
psql - PSQL Commands	Jan 5th, 2016	Never	112	PostgreSQL	-
psql - Misc admin queries	Jan 5th, 2016	Never	80	None	-
psql - Create prepared statement with a function	Dec 17th, 2015	Never	43	PostgreSQL	-
psql - Database IO, Cache and Statistics	Dec 16th, 2015	Never	66	PostgreSQL	-
psql - Find most heavily used tables and indexes	Dec 16th, 2015	Never	75	PostgreSQL	-
psql - CRUD SQL	Dec 7th, 2015	Never	79	PostgreSQL	-
psql - View vacuum statistics	Nov 30th, 2015	Never	83	PostgreSQL	-
psql - Table Juggling	Oct 23rd, 2015	Never	104	PostgreSQL	-
psql - List all objects and owners in a database	Aug 12th, 2015	Never	258	PostgreSQL	-
psql - Convert rows to single comma or pipe-delimited row	Aug 11th, 2015	Never	197	PostgreSQL	-
psql - Prepend table name to column name in a view	Jul 17th, 2015	Never	181	PostgreSQL	-
psql - Get database and table attributes	Jul 13th, 2015	Never	193	PostgreSQL	-
psql - View column names and date types for a table or view	Feb 13th, 2015	Never	183	PostgreSQL	-
psql - Change owner of all database objects	Dec 30th, 2014	Never	206	PostgreSQL	-
psql - Table and view permissions	Oct 15th, 2014	Never	165	PostgreSQL	-
psql - Query perf tuning	Aug 7th, 2014	Never	171	PostgreSQL	-
psql - List all groups and its users	Jun 5th, 2014	Never	191	PostgreSQL	-
psql - View group roles for a user	Jun 5th, 2014	Never	210	PostgreSQL	-
psql - View and Cancel Query	Apr 8th, 2014	Never	106	PostgreSQL	-
psql - Generate series in a Select query	Feb 27th, 2014	Never	129	PostgreSQL	-
psql - Generate date series	Feb 27th, 2014	Never	137	PostgreSQL	-
psql - Get column names of a table	Jan 8th, 2014	Never	111	PostgreSQL	-
Pentaho - SQLite In-Memory Database	Sep 13th, 2016	Never	149	None	-
Pentaho - Start Carte Worker Node	Aug 24th, 2015	Never	90	Bash	-
DB2 - Unpivot Data	Jul 27th, 2016	Never	195	SQL	-
DB2 - View table column headings	Jul 31st, 2014	Never	176	SQL	-
Oracle - LISTAGG Examples	Jan 27th, 2016	Never	62	Oracle 11	-
Oracle - SQL Admin Queries	Dec 8th, 2015	Never	136	None	-
Oracle - View available and used database sessions	Jun 26th, 2014	Never	186	Oracle 11	-
Oracle - View running processes	Jun 24th, 2014	Never	198	Oracle 11	-
Oracle - Display Cerner Functions	Mar 31st, 2014	Never	84	Oracle 11	-
Cassandra - nodetool commands	May 13th, 2016	Never	96	Bash	-
Cassandra Commands	Oct 15th, 2015	Never	143	Bash	-
SQL - Cerner MS-DRG Query	Jan 12th, 2016	Never	92	SQL	-
SQL - WITH Clause (CTE)	Jan 9th, 2014	Never	88	SQL	-
Bash - Wireshark Remote Packet Capture	Jun 17th, 2016	Never	65	Bash	-
Bash - tshark commands	Jun 17th, 2016	Never	84	Bash	-
Bash - iftop commands	Jun 15th, 2016	Never	81	Bash	-
Bash - top commands	Jun 15th, 2016	Never	92	Bash	-
Bash - Display all distinct file types in a directory	Mar 30th, 2016	Never	74	Bash	-
Bash - Find the largest files or directories	Mar 29th, 2016	Never	99	Bash	-
Bash - Check status on all services	Feb 19th, 2016	Never	83	Bash	-
Bash - PostgreSQL Admin Commands	Feb 19th, 2016	Never	94	Bash	-
Bash - Find files and directories	Feb 19th, 2016	Never	88	Bash	-
Bash - Jenkins Commands	Jan 7th, 2016	Never	85	None	-
Bash - Create SSH key on remote server	Dec 23rd, 2015	Never	85	Bash	-
Bash - history command with timestamp	Aug 20th, 2015	Never	196	Bash	-
Bash - SCP commands	Jul 31st, 2015	Never	232	Bash	-
Bash - unzip/untar files	Jun 15th, 2015	Never	259	None	-
Bash - sed commands	Jun 15th, 2015	Never	247	Bash	-
Bash - grep commands	Jun 15th, 2015	Never	228	Bash	-
Bash - cron for 1st weekday of month	Dec 22nd, 2014	Never	167	Bash	-
Bash - Find and delete files older than two days	Nov 25th, 2014	Never	39	Bash	-
Bash - Find top 10 largest files 5 directories deep	Jul 16th, 2014	Never	186	Bash	-
Bash - Total specific files in a directory	Apr 24th, 2014	Never	78	Bash	-
Bash - Java Commands	Apr 13th, 2014	Never	70	Bash	-
Bash - Check DF of server and email notification	Apr 13th, 2014	Never	88	Bash	-
Bash - Count all files by name in a directory	Feb 26th, 2014	Never	124	Bash	-
Bash - CHMOD Recursively	Jan 30th, 2014	Never	87	Bash	-
Bash - View running jobs	Jan 6th, 2014	Never	129	Bash	-
Docker - Dockerfile Guide	Dec 17th, 2015	Never	94	None	-
Tableau - Historical Event Types	Nov 1st, 2017	Never	254	None	-
Tableau - Query Tableau Server Users	Aug 8th, 2016	Never	174	None	-
Tableau - User Filter Calculated Field	Jul 25th, 2016	Never	75	None	-
tabcmd - Publish TDE script	May 4th, 2016	Never	85	None	-
Tableau - LOOKUP() Examples	Apr 11th, 2016	Never	87	None	-
Tableau - String Functions	Jul 29th, 2015	Never	228	None	-
tabcmd - Refresh data extract	Jun 17th, 2015	Never	350	Batch	-
tabadmin - Maintenance batch files	Jun 17th, 2015	Never	256	Batch	-
Tableau - Date Calculations	Mar 5th, 2015	Never	228	SQL	-
JS - XML String to JSON	May 2nd, 2016	Never	81	JavaScript	-
Sublime Text 2 - Shortcuts	Feb 25th, 2016	Never	70	None	-
Siri Commands - Apple Watch	Feb 10th, 2016	Never	86	None	-
JS - Open and close a window	Oct 7th, 2015	Never	135	JavaScript	-
SQL - Query Cerner Person Identifiers	Apr 13th, 2015	Never	233	SQL	-