SqlQuantumLeap

SqlQuantumLeap's Pastebin

2,936 32,848 0 9 years ago
Name / Title Added Expires Hits Comments Syntax  
Jackrabbit OAK-8977 (Improve performance) Apr 7th, 2020 Never 1,192 0 T-SQL -
SQL_VARIANT_PROPERTY documentation tests Feb 26th, 2020 Never 544 0 T-SQL -
BACKUP CERTIFICATE documentation test Apr 23rd, 2019 Never 1,047 0 T-SQL -
UTF8_Bug_36136810_SilentTruncation Nov 29th, 2018 Never 233 0 T-SQL -
UTF8_Bug_35606671_SQLCLR-Tests Oct 16th, 2018 Never 328 0 T-SQL -
UTF8_Bug_35606671_SQLCMD-Tests Oct 15th, 2018 Never 355 0 None -
UTF8_Bug_35606671_SSMS-Tests Oct 15th, 2018 Never 305 0 T-SQL -
SQL Agent Job: String Pattern Hidden From History Jun 19th, 2019 Never 420 0 T-SQL -
T-SQL Module Signing demo: Dynamic SQL and Trigger May 13th, 2019 Never 631 0 T-SQL -
T-SQL Function (iTVF) to List All Unicode Code Points Mar 26th, 2019 Never 628 0 T-SQL -
T-SQL Script to Uppercase All Columns Mar 20th, 2019 Never 662 0 T-SQL -
"CLR strict security" and PERMISSION_SET Oct 28th, 2018 Never 383 0 T-SQL -
Enable Group Policy Editor In Windows 10 Home Edition Jun 6th, 2018 Never 2,864 0 Batch -
Unicode 3.2, Part 3: Derived Props (ID Strt &Cnt) Mar 27th, 2018 Never 358 0 T-SQL -
Unicode 3.2, Part 2: Derived Props (Alpha & Dec) Mar 26th, 2018 Never 412 0 T-SQL -
Unicode 3.2, Part 1: Unicode Character Database (UCD) Mar 26th, 2018 Never 2,039 0 None -
Avoiding "Trusted Assemblies" - Demo Aug 25th, 2017 Never 6,759 0 T-SQL -
"clr strict security" - Solution 2 Aug 20th, 2017 Never 920 0 T-SQL -
"clr strict security" - Solution 1 Aug 15th, 2017 Never 1,849 0 T-SQL -
T-SQL script to compare case-insensitive techniques Jan 30th, 2019 Never 791 0 T-SQL -
T-SQL Stored Proc to PRINT NVARCHAR(MAX) values Jul 12th, 2016 Never 1,319 0 T-SQL -
SQLCLR UDF to parse a string into NGrams Jul 9th, 2016 Never 272 0 C# -
T-SQL query and results for filtering types of characters May 20th, 2016 Never 689 0 T-SQL -
SQLCLR SP Parses CSV file to Result Set - Testing Apr 15th, 2016 Never 105 0 T-SQL -
SQLCLR SP Parses CSV file to Result Set - Installer Apr 15th, 2016 Never 111 0 T-SQL -
SQLCLR SP Parses CSV file to Result Set - Source Code Apr 15th, 2016 Never 84 0 C# -
SQLCLR UDA for Longest Common Substring - Testing Mar 17th, 2016 Never 723 0 T-SQL -
SQLCLR UDA for Longest Common Substring - Installer Mar 14th, 2016 Never 833 0 T-SQL -
SQLCLR UDA for Longest Common Substring - Source Code Mar 11th, 2016 Never 1,070 0 C# -
Test Behavior of SqlCommand.Prepare() on SQL Server Feb 19th, 2016 Never 847 0 C# -
Searching for Case-Sensitive patterns in SQL Server Dec 4th, 2015 Never 417 0 T-SQL -
Unicode to Code Page mappings in SQL Server Nov 29th, 2015 Never 1,142 0 T-SQL -
Get 1000 chars max, up to final period, else to final return Nov 16th, 2015 Never 410 0 T-SQL -
SQLCLR Stored Proc returns one result set of many XML files Oct 7th, 2015 Never 595 0 T-SQL -
SQLCLR Meta-data function for cross-database IndexName() Oct 4th, 2015 Never 471 0 T-SQL -
Tests for exceeding max row size from too many MAX fields Aug 13th, 2015 Never 329 0 T-SQL -
Binary Substring Tests Jun 8th, 2015 Never 722 0 T-SQL -