GUID

In this article we take a look at using GUID columns in your SQL Server database tables and the impact GUID columns may have on indexing.

2020-11-11

GUIDs GUIDs everywhere, but how is my data unique?

After having seen many systems that use GUIDs as the primary key for every table, it is time to say enough is enough.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

3.83 (40)

You rated this post out of 5. Change rating

2014-12-18

9,860 reads

Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest...

Microsoft announced on November 2024 a preview for SQL Server 2025 another major release...

How to apologize: quickly, specifically, sincerely. Don’t ruin an apology with an excuse –...

Hello! SQL Clustered resource used to come online during manual or automatic failover in...

Code that can be used in order to create dashboard or SSRS report on...

So, I have an interesting situation that I need a double-check on. One of...

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 '\'