SQL University: Advanced Indexing – Indexing Strategies
Right, I know it’s Friday and everyone’s tired and looking forward to the weekend, but I do need to finish...
2011-11-11
1,590 reads
SQL In The Wild
SQL University: Advanced Indexing – Filtered Indexes
Welcome back to day 2 of Advanced Indexing. Today we’re going to look at a feature that was added in...
2011-11-09
1,937 reads
SQL University: Advanced indexing – Sorting and Grouping
Good day everyone and welcome to another week of SQL University. I know we’re getting close to the end of...
2011-11-07
2,687 reads
24 Hours of PASS Questions
I finally found the time to work through the questions from the 24 Hours of PASS session that I did....
2011-09-27
749 reads
Compiles and recompiles
I want to spend some time over the next few months looking at query compilation and the plan cache, and...
2011-08-16
3,651 reads
All about Execution Plans
Coming to the PASS Summit in October this year? Excellent!
I say excellent, because Grant (blog|twitter) and I are presenting a...
2011-08-09
769 reads
SQLSkills Immersion training in London
Just short of the winter solstice, I bailed out of a freezing cold Johannesburg for warmer climates; well, actually for...
2011-07-22
1,252 reads
Converting OR to Union
When I looked at indexing for queries containing predicates combined with OR, it became clear that the are some restrictive...
2011-07-05
1,626 reads
Are all updates split into delete-insert?
This should be another quick one.
Earlier I saw a forum post where someone asserted that SQL always executes an update...
2011-06-21
4,801 reads
T-SQL Tuesday: Disasters don’t just come in huge
So we’re supposed to talk about disasters we’ve had or discuss disaster recovery technologies. I’m going to take a slightly...
2011-06-14
735 reads
Blogs
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
4 CPE Opportunity (Virtual) for Charity
By Brian Kelley
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...
Forums
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
UNISTR Basics
Comments posted to this topic are about the item UNISTR Basics
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers