Adaptive Query Processing - Adaptive Joins - Plan resue - 3
Continuing on the series on Adaptive Query Processing covered overhere, this post would cover what happens to adaptive joins when...
2017-12-23
558 reads
SQL and SQL Only
Data Channel Interview - 09 - Mr.Madhivanan on Best Practices in TSQL Programming
Dear All,Very happy to share the 9th interview of #DataChannel. Mr.Madhivanan Ramachandran, 10 time Microsoft MVP Award winner and a Data Platform expert from India discusses "Best Practices for...
2017-12-02
22 reads
Data Channel Interview - 09 - Mr.Madhivanan on Best Practices in TSQL Programming
Dear All,Very happy to share the 9th interview of #DataChannel. Mr.Madhivanan Ramachandran, 10 time Microsoft MVP Award winner and a Data Platform expert from India discusses "Best Practices for...
2017-12-02
7 reads
Data Channel Interview - 09 - Mr.Madhivanan on Best Practices in TSQL Programming
Dear All,
Very happy to share the 9th interview of #DataChannel. Mr.Madhivanan Ramachandran, 10 time Microsoft MVP Award winner and a...
2017-12-02
541 reads
Adaptive Query Processing and Automatic Tuning - Adaptive Joins - 2
Continuing from the introduction written over here, let’s look at one of the aspects of Adaptive Query Processing which is Adaptive Joins.Before we start Adaptive Joins, SQL Server's Query...
2017-11-29
56 reads
Adaptive Query Processing and Automatic Tuning - Adaptive Joins - 2
Continuing from the introduction written over here, let’s look at one of the aspects of Adaptive Query Processing which is Adaptive Joins.Before we start Adaptive Joins, SQL Server's Query...
2017-11-29
5 reads
Adaptive Query Processing and Automatic Tuning - Adaptive Joins - 2
Continuing from the introduction written over here, let’s look at one of the aspects of Adaptive Query Processing which is...
2017-11-29
738 reads
Tricks - Copy T SQL Result to Excel
Sometimes, some of the silliest of tricks save so much of time and effort. Very common scenario is to copy a query result to excel. Most take either of...
2017-11-25
174 reads
Tricks - Copy T SQL Result to Excel
Sometimes, some of the silliest of tricks save so much of time and effort. Very common scenario is to copy a query result to excel. Most take either of...
2017-11-25
5 reads
Tricks - Copy T SQL Result to Excel
Sometimes, some of the silliest of tricks save so much of time and effort. Very common scenario is to copy...
2017-11-25
683 reads
Blogs
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
A New Word: Fawtle
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
Post-quantum key exchange – Insurance policy for your packets
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
Forums
Where Your Value Separates You from Others
Comments posted to this topic are about the item Where Your Value Separates You...
Fixing the Error
Comments posted to this topic are about the item Fixing the Error
T-SQL in SQL Server 2025: Encoding Functions
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Fixing the Error
On SQL Server 2025, I have a database that has this collation: SQL_Latin1_General_CP1_CI_AS. I decide I want to run this code:
SELECT UNISTR('*3041*308A*304C*3068 and good night', '*') AS 'A Classic';
I get this error:Msg 9844, Level 16, State 4, Line 24 The char/varchar input type uses an unsupported collation. Only a UTF8 collation is supported with char/varchar input type in UNISTR function.What is the easiest way to fix this error? See possible answers