Database Enums

So is it better to store enumerated types in a database as a string/varchar or integer? Well it depends, but in general as a string is your best bet. In this post I explore the pros and cons of each.

• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/11d9

Posted On Wednesday, September 20, 2017 11:38 PM | Comments (22)

Add Column Descriptions in SQL Server

In my previous post, I described how to use a query quickly search for columns in a database. The only thing missing from this table is a description for each of the columns.

• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/eSs

Posted On Thursday, February 27, 2014 10:12 PM | Comments (65)

Use System Queries to Browse Columns, Indexes, and FKs

The Object Explorer (F8) in SQL Server Management Studio is quite limiting when you need to search for a table or column. System queries to the rescue!

• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/eRM

Posted On Monday, February 17, 2014 1:29 PM | Comments (1)

Introduction To Rowversion

SQL Server has a built-in data type that automatically marks changes to rows. This data type can be used for 2 main purposes: optimistic record locking and data queue processing.

• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/eN9

Posted On Tuesday, January 14, 2014 11:53 PM | Comments (5)

Copyright © Timothy Klenke

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski