Conversion Between Unicode and Non-Unicode Data Flow Pattern
I don't think I'm alone when I find myself having to convert several columns in my Data Flow from Unicode...
2010-07-12
977 reads
Blog Posts
Degree Seeker Week at SQL University, Extra Credit
Degree Seeker Week at SQL University, Extra Credit
Welcome back to Degree Seeker Week at SQL University. If you have returned...
2010-07-12
1,747 reads
Enabling Memory Support for over 4GB of Physical Memory
This is something we had to do again recently and its improved our performance and query speeds on one particular system....
2010-07-12
935 reads
Exceptional DBA of the Year 2010 Finalist!
This post is a tad overdue as the public announcement was a few weeks back but it’s been a topsy-turvy...
2010-07-12
441 reads
It is Great to Get Feedback From My Readers
I get a lot of emails from people who read my blog, books, articles, and from people who have attended...
2010-07-12
502 reads
Mix & Match – Day 4
I’ve been scouring my notes (old & new), wading through all my previous research and unearthing advice, tips & tricks that have...
2010-07-12
381 reads
Old McDonalds and The Cow Store
As a child did you have a place that was your ‘thing’, something that just the mention of it would...
2010-07-12
506 reads
PowerShell and Effective Meetings at PASS 2010
Last week, PASS announced this year’s program for the 2010 Summit in Seattle, Washington. The program session are available online....
2010-07-12
437 reads
S3OLV July Recap
This month we had our first adventure in LiveMeeting presentations. We had the pleasure of listening to Jack Corbett give...
2010-07-12
429 reads
Settling or Pushing On
I read a blog recently that was titled: Time to Stop Settling. I think that the author (a friend) was...
2010-07-12
381 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
Happy Holidays, Let's Do Nerdy Stuff
Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...
UNISTR Escape
Comments posted to this topic are about the item UNISTR Escape
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
Question of the Day
UNISTR Escape
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: 
B: 
C: 
See possible answers