Steve Jones

Sort of Unique

Recently Steve Jones noticed that someone wanted to use a UDF to enforce uniqueness. No big deal, right? Well this person wanted to enforce uniqueness based on some other column value. A bit of a challenge, but this article presents a couple ways to handle this.

5 (1)

2002-08-12

4,254 reads

Blogs

Daily Coping 18 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Optimize for Unknown for Inline Table-Valued Functions

By

I had a curious performance issue today. An inline table-valued function (iTVF) was performing...

Daily Coping 17 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

How Many Rows Remain?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Many Rows Remain?

Compatibility Level Confidence

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Compatibility Level Confidence

The backup set holds a backup of a database other than the existing 'MyDB'

By JBentrum

I'm trying to restore a database from our production server to my local machine...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers