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.

Working with email addresses in SQL Server!

This article shows you how to design the storage for email addresses, how to validate email addresses, how to retrieve demographic information from email addresses efficiently, using computed columns and indexes. It also covers the security aspect of dealing with email addresses.

Blogs

Friend of Redgate 2020

By

Last week I was excited to receive an email from Redgate notifying me that...

Azure Database for PostgreSQL

By

Having worked with Azure SQL Database and its many flavours for couple of years...

Why I Support Code Automation Tools Like ORMs

By

I know I’m a weirdo. I’ve always been a weirdo. When I was a...

Read the latest Blogs

Forums

Index maintenance in availability groups

By garryha

I have a 4 node always on availability group setup across two datacentres with...

Extract part of string

By Mad-Dog

hi, How can I extract part of this string declare @string varchar(1024) set @string...

Data type conversion error

By as1981

All, This is my data flow: I'm getting the error: "Error: 0xC02020A1 at Data...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers