SqlQuantumLeap

SqlQuantumLeap's Pastebin

3,045 34,117 0 9 years ago
Name / Title Added Expires Hits Comments Syntax  
Jackrabbit OAK-8977 (Improve performance) Apr 7th, 2020 Never 1,216 0 T-SQL -
SQL_VARIANT_PROPERTY documentation tests Feb 26th, 2020 Never 556 0 T-SQL -
BACKUP CERTIFICATE documentation test Apr 23rd, 2019 Never 1,096 0 T-SQL -
UTF8_Bug_36136810_SilentTruncation Nov 29th, 2018 Never 242 0 T-SQL -
UTF8_Bug_35606671_SQLCLR-Tests Oct 16th, 2018 Never 343 0 T-SQL -
UTF8_Bug_35606671_SQLCMD-Tests Oct 15th, 2018 Never 365 0 None -
UTF8_Bug_35606671_SSMS-Tests Oct 15th, 2018 Never 319 0 T-SQL -
SQL Agent Job: String Pattern Hidden From History Jun 19th, 2019 Never 442 0 T-SQL -
T-SQL Module Signing demo: Dynamic SQL and Trigger May 13th, 2019 Never 685 0 T-SQL -
T-SQL Function (iTVF) to List All Unicode Code Points Mar 26th, 2019 Never 651 0 T-SQL -
T-SQL Script to Uppercase All Columns Mar 20th, 2019 Never 700 0 T-SQL -
"CLR strict security" and PERMISSION_SET Oct 28th, 2018 Never 399 0 T-SQL -
Enable Group Policy Editor In Windows 10 Home Edition Jun 6th, 2018 Never 2,951 0 Batch -
Unicode 3.2, Part 3: Derived Props (ID Strt &Cnt) Mar 27th, 2018 Never 371 0 T-SQL -
Unicode 3.2, Part 2: Derived Props (Alpha & Dec) Mar 26th, 2018 Never 431 0 T-SQL -
Unicode 3.2, Part 1: Unicode Character Database (UCD) Mar 26th, 2018 Never 2,064 0 None -
Avoiding "Trusted Assemblies" - Demo Aug 25th, 2017 Never 6,978 0 T-SQL -
"clr strict security" - Solution 2 Aug 20th, 2017 Never 955 0 T-SQL -
"clr strict security" - Solution 1 Aug 15th, 2017 Never 1,940 0 T-SQL -
T-SQL script to compare case-insensitive techniques Jan 30th, 2019 Never 825 0 T-SQL -
T-SQL Stored Proc to PRINT NVARCHAR(MAX) values Jul 12th, 2016 Never 1,349 0 T-SQL -
SQLCLR UDF to parse a string into NGrams Jul 9th, 2016 Never 284 0 C# -
T-SQL query and results for filtering types of characters May 20th, 2016 Never 719 0 T-SQL -
SQLCLR SP Parses CSV file to Result Set - Testing Apr 15th, 2016 Never 116 0 T-SQL -
SQLCLR SP Parses CSV file to Result Set - Installer Apr 15th, 2016 Never 123 0 T-SQL -
SQLCLR SP Parses CSV file to Result Set - Source Code Apr 15th, 2016 Never 92 0 C# -
SQLCLR UDA for Longest Common Substring - Testing Mar 17th, 2016 Never 763 0 T-SQL -
SQLCLR UDA for Longest Common Substring - Installer Mar 14th, 2016 Never 893 0 T-SQL -
SQLCLR UDA for Longest Common Substring - Source Code Mar 11th, 2016 Never 1,113 0 C# -
Test Behavior of SqlCommand.Prepare() on SQL Server Feb 19th, 2016 Never 901 0 C# -
Searching for Case-Sensitive patterns in SQL Server Dec 4th, 2015 Never 433 0 T-SQL -
Unicode to Code Page mappings in SQL Server Nov 29th, 2015 Never 1,184 0 T-SQL -
Get 1000 chars max, up to final period, else to final return Nov 16th, 2015 Never 436 0 T-SQL -
SQLCLR Stored Proc returns one result set of many XML files Oct 7th, 2015 Never 620 0 T-SQL -
SQLCLR Meta-data function for cross-database IndexName() Oct 4th, 2015 Never 488 0 T-SQL -
Tests for exceeding max row size from too many MAX fields Aug 13th, 2015 Never 351 0 T-SQL -
Binary Substring Tests Jun 8th, 2015 Never 740 0 T-SQL -