Using a UDF as a SARG. Make a hash of it!
I am somewhat uncomfortable blogging this, as I feel that it falls into “Polish a turd” category. Having said that,...
2010-07-02
725 reads
Blog Posts
Winner of the June SQL Aloha Contest
This month’s question of the month was:
What is your best advice for boosting index performance?
As usual, selecting the winning entry...
2010-07-02
437 reads
Congrats to all MVPs (New and Renewed)
Today twitter is buzzing with news about MVPs being confirmed. Some new and some old getting renewed. I am sure...
2010-07-01
567 reads
Delegating
I think all managers are told they must delegate to succeed and/or survive. Seems obvious, a manager can’t do it...
2010-07-01
322 reads
Electricity Conservation and Solar PV Power
Since I got my grid-tied solar PV system on my roof turned on almost two weeks ago, I have gotten...
2010-07-01
3,094 reads
How to Provide Great Feedback
As a DBA you will encounter processes, code and design decisions within your environment that require change for the better....
2010-07-01
608 reads
Indexes are best utilized in WHERE, not JOIN
A pervasive oversight in database indexing by newer database users is relying solely on indexes used for joining tables together...
2010-07-01
3,735 reads
July Question: Tell us your story of how you happened to become a DBA.
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
2010-07-01
455 reads
MVP Congratulations
It usually slips my mind that there are award dates for the Microsoft MVP program outside my own. I’m on...
2010-07-01
568 reads
My Ideal SQL Server Test Box is on the Way
Several weeks ago I wrote a blog post called “What is the Ideal SQL Server Test Box?” At that time...
2010-07-01
1,163 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