I Feel Like a Heel
It’s now 3 events that I’ve canceled in the last 6 months, and a 4 or 5 more that I’ve...
2010-02-22
878 reads
Blog Posts
IgnoreUnrelatedDimensions in Analysis Services 2008
Once of the more common issues with working with data in a cube is that it does not always line...
2010-02-22
457 reads
Introduction to Using Profiler with SSAS 2008
There are many ways to optimize your analysis services cubes, but the real trouble is how do you know where...
2010-02-22
604 reads
It will happen on a spring day in May...
"The world's favorite season is the spring. All things seem possible in May." - Edwin Way Teale This spring, the Portland,...
2010-02-22
462 reads
Power Plans and Windows Server 2008 R2
After seeing an interesting blog post on AnandTech IT last week that showed slower query response time in x64 SQL...
2010-02-22
3,442 reads
SQL Server 2008 - Adding Row Totals
During a recent client engagement I was asked if there was a quick way to add a row containing totals...
2010-02-22
732 reads
What Does It Look Like When Everything Is Okay?
I'm a big believer in looking at systems when everything is okay. I'm not the only one, as Joe Richards, a...
2010-02-22
867 reads
What’s up with the reads?
So the other day I read Andrew Kelly’s article, Do You Have Hidden Cache Problems, in the latest electronic edition...
2010-02-22
366 reads
When Should You Start Speaking?
I know it’s daunting and a little intimidating, but there are so many people with knowledge to share. I see...
2010-02-22
935 reads
Data Type Precedence and Implicit Conversions
In my last post, I noted that one of the biggest differences between ISNULL and COALESCE was the fact that...
2010-02-21
4,493 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