Simon Sabin


Enums in SQL Server

SQL Server MVP Simon Sabin brings us a very interesting article on a possibilltyfor using enumerated values instead of integer or other coded foreign keys. It is an interesting idea that could go a long way towards making code easier to read.

3.5 (4)

2007-08-28

10,480 reads

Large Object Data

Dealing with text, image, and other large object data types can be confusing for many people, in all aspects of working with them. However one place that is important is performance. SQL Server MVP Simon Sabin brings us a few thoughts on improving performance with these columns and the Text in Row setting.

2006-10-04

5,953 reads

Blogs

Nerd Journey Podcast with Nick Korte

By

I’m thrilled to have recently recorded a podcast with Nick Korte from Nerd Journey....

Daily Coping 18 May 2021

By

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

Creating a configurable SSMS script

By

Several times over the last few weeks I’ve gotten a request to create a...

Read the latest Blogs

Forums

Hostage Data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Hostage Data

Multiplying Vectors in R

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiplying Vectors in R

Hidden Pitfalls with INNER JOIN and NOT IN Operators

By MMartin1

Comments posted to this topic are about the item Hidden Pitfalls with INNER JOIN...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers