Soundex - Experiments with SQLCLR Part 3
Acknowledging fundamental design flaws lead to a more flexible, maintainable phonetic framework
2018-11-23 (first published: 2015-08-27)
3,768 reads
Acknowledging fundamental design flaws lead to a more flexible, maintainable phonetic framework
2018-11-23 (first published: 2015-08-27)
3,768 reads
In this second article I provide the means to restore a binary file to its original state.
2015-05-28
11,092 reads
2016-08-23 (first published: 2015-05-01)
1,420 reads
2014-02-20
1,927 reads
You have imported an assembly into a SQL Server database to use the CLR functions and stored procedures it contains. However later, you lost the original .dll file and you would like to create the .dll file again from what's in the database. In this tip, we look at how you can recreate the .dll file.
2014-01-06
2,453 reads
SQL Server 2012 supports SHA-256 and SHA-512 through the HASHBYTES() function, but earlier versions of SQL Server do not. SHA-256, SHA-384 and SHA-512 can, however, be implemented in SQL Server 2005 or SQL Server 2008 with the CLR assembly described in this article.
2013-10-07
6,241 reads
Learn how to simplify deployment and maintenance of SQL CLR assemblies by using T-SQL instead of Visual Studio.
2013-05-07
10,613 reads
Sometimes a procedure returns more than 1 result set. The article describes how to save all result sets into new database tables
2012-09-06
17,337 reads
Three CLR-resident functions for 16-, 32-, and 64-bit FNV1a hashing
2012-02-20
5,955 reads
Are Common Language Runtime routines in SQL Server faster or slower than the equivalent T-SQL code? How would you go about testing the relative performance objectively? Solomon Rutzky creates a test framework to try to answer the question and comes up with some surprising results that you can check for yourself.
2011-08-01
2,863 reads
By SQLPals
Measuring and Improving SQL Server Query Plan Cache Efficiency The query...
By Brian Kelley
I may think I'm trying to reach the crowd, but I'm really trying to...
By Steve Jones
During a demo of Redgate Monitor Enterprise to a customer, they asked about how...
Comments posted to this topic are about the item The Technical Debt Anchor
Comments posted to this topic are about the item Getting the Updated Column List
Here's the complete error: An error occurred during local report processing. The definition of...
What happens when I run this code in SQL Server 2022?
UPDATE dbo.CustomerLarge SET CustomerContactFirstName = 'Andy' WHERE CustomerID = 1 SELECT COLUMNS_UPDATED()See possible answers