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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(40)

You rated this post out of 5. Change rating

2014-12-18

10,022 reads

Next week I’m at VS Live in San Diego (register and join me) and...

Ten years ago today, I filmed a Pluralsight Play by Play on open source...

It’s time for T-SQL Tuesday again and this is a great prompt to start...

Comments posted to this topic are about the item Stored Procedures for Server-Level Object...

Comments posted to this topic are about the item Databricks Genie Spaces for SQL...

Comments posted to this topic are about the item The Costs of Multiple Platforms

I have this data in a table in a SQL Server 2025 database:

EmailAddressID EmailAddress
7              dylan0@ADVENTURE-WORKS.COM
8              Diane1@ADVENTURE-WORKS.COM

If I run this query, which row(s) are returned?

SELECT top 10
 *
 FROM person.EmailAddress
 WHERE REGEXP_LIKE(EmailAddress, '^d')
 AND BusinessEntityID IN (7,8)