SQLYSE with Pankaj Manek

In my previous post, I mentioned the use of functions, specifically ISNULL and the effects on SARGability of the query....

2015-09-07

1,249 reads

ISNULL around the predicate and SARGability

You may have heard of the word, SARGable. In brief, it’s a term derived from the phrase, Search ARGument able,...

2015-08-20

3,737 reads

Time and again I see developers querying SQL Server trying to retrieve TOP (N) records but without using ORDER BY,...

2015-07-31

10,422 reads

This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...

Today is Christmas and while I do not expect anybody to actual be reading...

Until recently, my family's 90,000+ photos have been hidden away in the depths of...

Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...

Comments posted to this topic are about the item UNISTR Escape

Comments posted to this topic are about the item Celebrating Tomorrow

In SQL Server 2025, I run this command:

SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";

What is returned? (assume the database has an appropriate collation) A: