SqlQuantumLeap

SqlQuantumLeap's Pastebin

1,736 12,146 5 years ago
Name / Title Added Expires Hits Syntax  
Jackrabbit OAK-8977 (Improve performance) Apr 7th, 2020 Never 588 T-SQL -
SQL_VARIANT_PROPERTY documentation tests Feb 26th, 2020 Never 370 T-SQL -
BACKUP CERTIFICATE documentation test Apr 23rd, 2019 Never 428 T-SQL -
UTF8_Bug_36136810_SilentTruncation Nov 29th, 2018 Never 50 T-SQL -
UTF8_Bug_35606671_SQLCLR-Tests Oct 16th, 2018 Never 107 T-SQL -
UTF8_Bug_35606671_SQLCMD-Tests Oct 15th, 2018 Never 116 None -
UTF8_Bug_35606671_SSMS-Tests Oct 15th, 2018 Never 111 T-SQL -
SQL Agent Job: String Pattern Hidden From History Jun 19th, 2019 Never 66 T-SQL -
T-SQL Module Signing demo: Dynamic SQL and Trigger May 13th, 2019 Never 83 T-SQL -
T-SQL Function (iTVF) to List All Unicode Code Points Mar 26th, 2019 Never 170 T-SQL -
T-SQL Script to Uppercase All Columns Mar 20th, 2019 Never 128 T-SQL -
"CLR strict security" and PERMISSION_SET Oct 28th, 2018 Never 44 T-SQL -
Enable Group Policy Editor In Windows 10 Home Edition Jun 6th, 2018 Never 2,071 Batch -
Unicode 3.2, Part 3: Derived Props (ID Strt &Cnt) Mar 27th, 2018 Never 49 T-SQL -
Unicode 3.2, Part 2: Derived Props (Alpha & Dec) Mar 26th, 2018 Never 37 T-SQL -
Unicode 3.2, Part 1: Unicode Character Database (UCD) Mar 26th, 2018 Never 66 None -
Avoiding "Trusted Assemblies" - Demo Aug 25th, 2017 Never 2,785 T-SQL -
"clr strict security" - Solution 2 Aug 20th, 2017 Never 374 T-SQL -
"clr strict security" - Solution 1 Aug 15th, 2017 Never 725 T-SQL -
T-SQL script to compare case-insensitive techniques Jan 30th, 2019 Never 144 T-SQL -
T-SQL Stored Proc to PRINT NVARCHAR(MAX) values Jul 12th, 2016 Never 594 T-SQL -
SQLCLR UDF to parse a string into NGrams Jul 9th, 2016 Never 87 C# -
T-SQL query and results for filtering types of characters May 20th, 2016 Never 179 T-SQL -
SQLCLR UDA for Longest Common Substring - Testing Mar 17th, 2016 Never 187 T-SQL -
SQLCLR UDA for Longest Common Substring - Installer Mar 14th, 2016 Never 239 T-SQL -
SQLCLR UDA for Longest Common Substring - Source Code Mar 11th, 2016 Never 305 C# -
Test Behavior of SqlCommand.Prepare() on SQL Server Feb 19th, 2016 Never 218 C# -
Searching for Case-Sensitive patterns in SQL Server Dec 4th, 2015 Never 155 T-SQL -
Unicode to Code Page mappings in SQL Server Nov 29th, 2015 Never 494 T-SQL -
Get 1000 chars max, up to final period, else to final return Nov 16th, 2015 Never 146 T-SQL -
SQLCLR Stored Proc returns one result set of many XML files Oct 7th, 2015 Never 334 T-SQL -
SQLCLR Meta-data function for cross-database IndexName() Oct 4th, 2015 Never 221 T-SQL -
Tests for exceeding max row size from too many MAX fields Aug 13th, 2015 Never 92 T-SQL -
Binary Substring Tests Jun 8th, 2015 Never 390 T-SQL -