Curb those Cursors !
With query performance becoming a constant battle, its often a forgotten fact that cursors should be avoided (in the majority...
2010-07-15
681 reads
Blog Posts
Defensive Db Programming Chapter 02
This is the review of the second chapter of the book Defensive Database Programming. The title of this chapter is...
2010-07-15
1,822 reads
Free SQL Server Training for the Week of July 19, 2010
This will start a new trend on my blog. Every Friday morning I'll have a blog post covering the free SQL...
2010-07-15
745 reads
Making Choices Narrows Your Remaining Options
I’ve had variations of this conversation a couple of times lately and thought it was worth writing down some thoughts....
2010-07-15
505 reads
MDX Puzzle #3 Solution
Download Script
Sorry that it’s taken me so long to write this post, but I have been a little busy with...
2010-07-15
690 reads
Pruning the Blog List
I went through the exercise months ago where I tried to re-organize my blog reading to be more efficient at...
2010-07-15
840 reads
Scanning Without Wires - Epson Workforce 610
We are trying to buy another property here at the ranch. My wife had to leave town in the middle...
2010-07-15
743 reads
SQL Saturday Advice - Build a Foundation
I think this is a good idea, and I’ll give you some reasons, but every SQL Saturday ought to consider...
2010-07-15
975 reads
Building My New Home, SQL Server IO
April of 2009 I decided it was time to blog about my SQL Server experiences in earnest. Steve Jones (twitter|blog)...
2010-07-14
531 reads
Core DBA Skill – Backing up the tail log
I’ve never had to do this in production, and I’ve only practiced it a few times, but I think this...
2010-07-14
2,263 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