2017-07-24 (first published: 2017-07-12)
532 reads
Simon Hundleby
HashBytes Nvarchar(MAX)
SQL SERVER Includes a Hashbytes function, however it's limited to VARCHAR(8000). This can cause a problem when trying to build hashes over wide datasets.
Solution
Expose the C# Hashbytes function using CLR
2015-12-01 (first published: 2015-11-06)
837 reads
Blogs
Azure SQL vCore vs DTU
By Arun Sirpal
If you are building database solutions in Azure , using Azure SQL Database then...
Synapse Analytics Spark Example 2 - ROW_NUMBER()
By Ed Elliott
The next example is how to do a ROW_NUMBER(), my favourite window function. T-SQL SELECT...
Synapse Analytics Spark Example 1 - Group By
By Ed Elliott
I have been playing around with the new Azure Synapse Analytics, and I realised...
Forums
Transaction was deadlocked on lock resources with another process
I have table in SQL Server 2014. Please find the structure below: CREATE TABLE...
Conditional Column calculation
Hello All, I have the following SQL Query, what I need is to have...
The media family on device incorrectly formed for read only file group restore
Yes the databases (source and destination) are the same version. I have checked 3...
Ask SSC