SqlQuantumLeap

SqlQuantumLeap's Pastebin

3,338 36,288 0 10 years ago
Name / Title Added Expires Hits Comments Syntax  
Jackrabbit OAK-8977 (Improve performance) Apr 7th, 2020 Never 1,384 0 T-SQL -
SQL_VARIANT_PROPERTY documentation tests Feb 26th, 2020 Never 631 0 T-SQL -
BACKUP CERTIFICATE documentation test Apr 23rd, 2019 Never 1,359 0 T-SQL -
UTF8_Bug_36136810_SilentTruncation Nov 29th, 2018 Never 302 0 T-SQL -
UTF8_Bug_35606671_SQLCLR-Tests Oct 16th, 2018 Never 390 0 T-SQL -
UTF8_Bug_35606671_SQLCMD-Tests Oct 15th, 2018 Never 440 0 None -
UTF8_Bug_35606671_SSMS-Tests Oct 15th, 2018 Never 392 0 T-SQL -
SQL Agent Job: String Pattern Hidden From History Jun 19th, 2019 Never 548 0 T-SQL -
T-SQL Module Signing demo: Dynamic SQL and Trigger May 13th, 2019 Never 857 0 T-SQL -
T-SQL Function (iTVF) to List All Unicode Code Points Mar 26th, 2019 Never 758 0 T-SQL -
T-SQL Script to Uppercase All Columns Mar 20th, 2019 Never 855 0 T-SQL -
"CLR strict security" and PERMISSION_SET Oct 28th, 2018 Never 483 0 T-SQL -
Unicode 3.2, Part 3: Derived Props (ID Strt &Cnt) Mar 27th, 2018 Never 458 0 T-SQL -
Unicode 3.2, Part 2: Derived Props (Alpha & Dec) Mar 26th, 2018 Never 517 0 T-SQL -
Unicode 3.2, Part 1: Unicode Character Database (UCD) Mar 26th, 2018 Never 2,442 0 None -
Avoiding "Trusted Assemblies" - Demo Aug 25th, 2017 Never 7,721 0 T-SQL -
"clr strict security" - Solution 2 Aug 20th, 2017 Never 1,103 0 T-SQL -
"clr strict security" - Solution 1 Aug 15th, 2017 Never 2,252 0 T-SQL -
T-SQL script to compare case-insensitive techniques Jan 30th, 2019 Never 991 0 T-SQL -
T-SQL Stored Proc to PRINT NVARCHAR(MAX) values Jul 12th, 2016 Never 1,491 0 T-SQL -
SQLCLR UDF to parse a string into NGrams Jul 9th, 2016 Never 355 0 C# -
T-SQL query and results for filtering types of characters May 20th, 2016 Never 860 0 T-SQL -
SQLCLR SP Parses CSV file to Result Set - Testing Apr 15th, 2016 Never 181 0 T-SQL -
SQLCLR SP Parses CSV file to Result Set - Installer Apr 15th, 2016 Never 175 0 T-SQL -
SQLCLR SP Parses CSV file to Result Set - Source Code Apr 15th, 2016 Never 144 0 C# -
SQLCLR UDA for Longest Common Substring - Testing Mar 17th, 2016 Never 872 0 T-SQL -
SQLCLR UDA for Longest Common Substring - Installer Mar 14th, 2016 Never 1,003 0 T-SQL -
SQLCLR UDA for Longest Common Substring - Source Code Mar 11th, 2016 Never 1,248 0 C# -
Test Behavior of SqlCommand.Prepare() on SQL Server Feb 19th, 2016 Never 1,063 0 C# -
Searching for Case-Sensitive patterns in SQL Server Dec 4th, 2015 Never 574 0 T-SQL -
Unicode to Code Page mappings in SQL Server Nov 29th, 2015 Never 1,371 0 T-SQL -
Get 1000 chars max, up to final period, else to final return Nov 16th, 2015 Never 514 0 T-SQL -
SQLCLR Stored Proc returns one result set of many XML files Oct 7th, 2015 Never 729 0 T-SQL -
SQLCLR Meta-data function for cross-database IndexName() Oct 4th, 2015 Never 576 0 T-SQL -
Tests for exceeding max row size from too many MAX fields Aug 13th, 2015 Never 424 0 T-SQL -
Binary Substring Tests Jun 8th, 2015 Never 837 0 T-SQL -