Author: SSWUG Research

Community

Myths, GUID vs Autoincrement

(Brian Aker) I am a fan of using GUIDs as primary keys. They are database independent, object independent and I can either create them in my application or in the database (MySQL since 5.0 has had a UUID() function but since it does not replicate I don’t use it normally… this has been fixed in 5

Community

The Helper Table Workbench

(Robyn Page and Phil Factor) Sometimes, when writing TSQL code in functions or procedures, it is tempting to do iterations, or even worse, a cursor, when it isn’t really necessary. Cursors and iterations are both renowned for slowing down Transact SQL Code SQL Server just isn’t designed for it.