SqlQuantumLeap

SqlQuantumLeap's Pastebin

2,422 22,625 7 years ago
Name / Title Added Expires Hits Comments Syntax  
Jackrabbit OAK-8977 (Improve performance) Apr 7th, 2020 Never 899 T-SQL -
SQL_VARIANT_PROPERTY documentation tests Feb 26th, 2020 Never 453 T-SQL -
BACKUP CERTIFICATE documentation test Apr 23rd, 2019 Never 685 T-SQL -
UTF8_Bug_36136810_SilentTruncation Nov 29th, 2018 Never 143 T-SQL -
UTF8_Bug_35606671_SQLCLR-Tests Oct 16th, 2018 Never 231 T-SQL -
UTF8_Bug_35606671_SQLCMD-Tests Oct 15th, 2018 Never 227 None -
UTF8_Bug_35606671_SSMS-Tests Oct 15th, 2018 Never 208 T-SQL -
SQL Agent Job: String Pattern Hidden From History Jun 19th, 2019 Never 242 T-SQL -
T-SQL Module Signing demo: Dynamic SQL and Trigger May 13th, 2019 Never 305 T-SQL -
T-SQL Function (iTVF) to List All Unicode Code Points Mar 26th, 2019 Never 408 T-SQL -
T-SQL Script to Uppercase All Columns Mar 20th, 2019 Never 381 T-SQL -
"CLR strict security" and PERMISSION_SET Oct 28th, 2018 Never 216 T-SQL -
Enable Group Policy Editor In Windows 10 Home Edition Jun 6th, 2018 Never 2,492 Batch -
Unicode 3.2, Part 3: Derived Props (ID Strt &Cnt) Mar 27th, 2018 Never 204 T-SQL -
Unicode 3.2, Part 2: Derived Props (Alpha & Dec) Mar 26th, 2018 Never 202 T-SQL -
Unicode 3.2, Part 1: Unicode Character Database (UCD) Mar 26th, 2018 Never 1,500 None -
Avoiding "Trusted Assemblies" - Demo Aug 25th, 2017 Never 4,655 T-SQL -
"clr strict security" - Solution 2 Aug 20th, 2017 Never 647 T-SQL -
"clr strict security" - Solution 1 Aug 15th, 2017 Never 1,199 T-SQL -
T-SQL script to compare case-insensitive techniques Jan 30th, 2019 Never 456 T-SQL -
T-SQL Stored Proc to PRINT NVARCHAR(MAX) values Jul 12th, 2016 Never 957 T-SQL -
SQLCLR UDF to parse a string into NGrams Jul 9th, 2016 Never 176 C# -
T-SQL query and results for filtering types of characters May 20th, 2016 Never 402 T-SQL -
SQLCLR SP Parses CSV file to Result Set - Testing Apr 15th, 2016 Never 23 T-SQL -
SQLCLR SP Parses CSV file to Result Set - Installer Apr 15th, 2016 Never 32 T-SQL -
SQLCLR SP Parses CSV file to Result Set - Source Code Apr 15th, 2016 Never 22 C# -
SQLCLR UDA for Longest Common Substring - Testing Mar 17th, 2016 Never 489 T-SQL -
SQLCLR UDA for Longest Common Substring - Installer Mar 14th, 2016 Never 541 T-SQL -
SQLCLR UDA for Longest Common Substring - Source Code Mar 11th, 2016 Never 670 C# -
Test Behavior of SqlCommand.Prepare() on SQL Server Feb 19th, 2016 Never 536 C# -
Searching for Case-Sensitive patterns in SQL Server Dec 4th, 2015 Never 283 T-SQL -
Unicode to Code Page mappings in SQL Server Nov 29th, 2015 Never 875 T-SQL -
Get 1000 chars max, up to final period, else to final return Nov 16th, 2015 Never 272 T-SQL -
SQLCLR Stored Proc returns one result set of many XML files Oct 7th, 2015 Never 483 T-SQL -
SQLCLR Meta-data function for cross-database IndexName() Oct 4th, 2015 Never 352 T-SQL -
Tests for exceeding max row size from too many MAX fields Aug 13th, 2015 Never 217 T-SQL -
Binary Substring Tests Jun 8th, 2015 Never 551 T-SQL -