SQL Performance – Using Query Hint OPTION (FAST N)
It is fun working with SQL/Application developer where you exchange a lot of technical thoughts to find the root of...
2018-03-21
7,310 reads
Blog Posts
SQL Server Data Management Life Cycle
This is the second article in the “Backup and Restore (or Recovery) in SQL Server” stairway series (see the full...
2018-03-21
311 reads
Troubleshooting SQL Server Error 15517
Last week I had the following error message repeating over and over again in the SQL Server log of one of...
2018-03-21 (first published: 2013-04-22)
59,824 reads
Webinar: Identify and Eliminate SQL Server Performance Issues
I’m giving a webinar tomorrow, March 22, 2018, at 3 PM Eastern.
Free Registration Link
Here’s what I’ll be covering:
Are you struggling...
2018-03-21
355 reads
Which One is Better? IN or BETWEEN?
I just had an interesting case of performance tuning: a query with multiple predicates on a very large table. Something...
2018-03-21 (first published: 2018-03-09)
4,127 reads
An Introduction to Enterprise Architecture
An Introduction to Enterprise Architecture
In this series I’m going to be looking at enterprise architecture. Over the last few years...
2018-03-20
392 reads
Experiment with SQL Server and DBFS on Linux
Given that Microsoft now considers Linux a ‘first-class citizen’, SQL Server 2017 offers native support for Linux. It is engineered...
2018-03-20
354 reads
How To Steal Data Using Second Order SQL Injection Attacks
Watch this week's video on YouTube
One misconception some people have about SQL injection is that it can only happen when concatenating a user input parameter directly into your dynamically...
2018-03-20
7 reads
How To Steal Data Using Second Order SQL Injection Attacks
Watch this week's video on YouTube
One misconception some people have about SQL injection is that it can only happen when concatenating a user input parameter directly into your dynamically...
2018-03-20
6 reads
Identify R Package Dependencies Using miniCRAN
Installing R packages in SQL Server 2017 is a breeze with the stored procedure sp_execute_external_script. But so far, it is limited...
2018-03-20
444 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