SqlQuantumLeap's Pastebin

4,206 99,630 0 11 years ago

Name / Title	Added	Expires	Hits	Comments	Syntax
Jackrabbit OAK-8977 (Improve performance)	Apr 7th, 2020	Never	8,237	2	T-SQL	-
SQL_VARIANT_PROPERTY documentation tests	Feb 26th, 2020	Never	7,478	10	T-SQL	-
BACKUP CERTIFICATE documentation test	Apr 23rd, 2019	Never	8,333	12	T-SQL	-
UTF8_Bug_36136810_SilentTruncation	Nov 29th, 2018	Never	7,206	2	T-SQL	-
UTF8_Bug_35606671_SQLCLR-Tests	Oct 16th, 2018	Never	4,366	1	T-SQL	-
UTF8_Bug_35606671_SQLCMD-Tests	Oct 15th, 2018	Never	752	0	None	-
UTF8_Bug_35606671_SSMS-Tests	Oct 15th, 2018	Never	705	0	T-SQL	-
SQL Agent Job: String Pattern Hidden From History	Jun 19th, 2019	Never	7,284	2	T-SQL	-
T-SQL Module Signing demo: Dynamic SQL and Trigger	May 13th, 2019	Never	7,865	11	T-SQL	-
T-SQL Function (iTVF) to List All Unicode Code Points	Mar 26th, 2019	Never	1,180	0	T-SQL	-
T-SQL Script to Uppercase All Columns	Mar 20th, 2019	Never	7,616	12	T-SQL	-
"CLR strict security" and PERMISSION_SET	Oct 28th, 2018	Never	867	0	T-SQL	-
Unicode 3.2, Part 3: Derived Props (ID Strt &Cnt)	Mar 27th, 2018	Never	769	0	T-SQL	-
Unicode 3.2, Part 2: Derived Props (Alpha & Dec)	Mar 26th, 2018	Never	875	0	T-SQL	-
Unicode 3.2, Part 1: Unicode Character Database (UCD)	Mar 26th, 2018	Never	2,894	0	None	-
Avoiding "Trusted Assemblies" - Demo	Aug 25th, 2017	Never	8,875	12	T-SQL	-
"clr strict security" - Solution 2	Aug 20th, 2017	Never	1,458	0	T-SQL	-
"clr strict security" - Solution 1	Aug 15th, 2017	Never	2,815	10	T-SQL	-
T-SQL script to compare case-insensitive techniques	Jan 30th, 2019	Never	1,347	0	T-SQL	-
T-SQL Stored Proc to PRINT NVARCHAR(MAX) values	Jul 12th, 2016	Never	1,845	0	T-SQL	-
SQLCLR UDF to parse a string into NGrams	Jul 9th, 2016	Never	727	0	C#	-
T-SQL query and results for filtering types of characters	May 20th, 2016	Never	1,285	0	T-SQL	-
SQLCLR SP Parses CSV file to Result Set - Testing	Apr 15th, 2016	Never	533	0	T-SQL	-
SQLCLR SP Parses CSV file to Result Set - Installer	Apr 15th, 2016	Never	528	0	T-SQL	-
SQLCLR SP Parses CSV file to Result Set - Source Code	Apr 15th, 2016	Never	457	0	C#	-
SQLCLR UDA for Longest Common Substring - Testing	Mar 17th, 2016	Never	1,214	0	T-SQL	-
SQLCLR UDA for Longest Common Substring - Installer	Mar 14th, 2016	Never	1,369	0	T-SQL	-
SQLCLR UDA for Longest Common Substring - Source Code	Mar 11th, 2016	Never	1,645	0	C#	-
Test Behavior of SqlCommand.Prepare() on SQL Server	Feb 19th, 2016	Never	1,599	12	C#	-
Searching for Case-Sensitive patterns in SQL Server	Dec 4th, 2015	Never	937	0	T-SQL	-
Unicode to Code Page mappings in SQL Server	Nov 29th, 2015	Never	1,838	0	T-SQL	-
Get 1000 chars max, up to final period, else to final return	Nov 16th, 2015	Never	823	0	T-SQL	-
SQLCLR Stored Proc returns one result set of many XML files	Oct 7th, 2015	Never	1,080	0	T-SQL	-
SQLCLR Meta-data function for cross-database IndexName()	Oct 4th, 2015	Never	970	0	T-SQL	-
Tests for exceeding max row size from too many MAX fields	Aug 13th, 2015	Never	718	0	T-SQL	-
Binary Substring Tests	Jun 8th, 2015	Never	1,258	0	T-SQL	-