This is Howard Van Dam's Typepad Profile.
Join Typepad and start following Howard Van Dam's activity
Join Now!
Already a member? Sign In
Howard Van Dam
Recent Activity
Nice column! I had never heard of the term "Sargability" and had to look it up. As a young developer at IBM, we were told using LIKE, and other non SARGable operations was not only bad form, but pointed to an error in the data architecture. At that time we had people dedicated to properly analyzing the data and designing the database. I believe that today we are sorely lacking in the skills these data architects possessed. My last job used a mySQL database that was the most pathetic mess I had ever seen. The database was "developed", and I use that term very loosely, by the originator of the product. Very poor design, and used exactly what you recommend against, the use of a GUID value as both a primary key and a column in a clustered index. It had horrible performance, was impossible to maintain and extend as the product evolved.
Howard Van Dam is now following The Typepad Team
Nov 15, 2018