Kevin van der Merwe

SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes and Times)

SQL 2008 has some key improvements over SQL 2005. This article deals with backup compression and faster backups in SQL 2008

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.55 (75)

You rated this post out of 5. Change rating

2011-05-30 (first published: 2008-05-05)

22,503 reads

Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...

The more I work with the Data API Builder (DAB), the more I lean...

It’s time for the first T-SQL Tuesday blog of 2025, with an invite from...

Comments posted to this topic are about the item Vector DB implementation using FAISS

Comments posted to this topic are about the item The Types of Changes

Comments posted to this topic are about the item Escaping Like I

I have this data in a SQL Server 2022 table:

PlayerIDPlayerNamePlayerStatus
1The \%ChampActive
2The ChampActive
3The_ChampionActive
4The__ChampionActive
5The\_ChampActive

How many rows are returned by this code in SQL Server 2022?

select PlayerName from player
where playername like 'The\_C%' escape '\'