Recent Articles by Websolete

T-SQL function to de-duplicate lists

Needed a function to de-duplicate string lists, so I modified a similar UDF from SQLAuthority. That original UDF didn’t preserve the position of list elements or handle case sensitive comparisons, and I wasn’t too keen on the variable naming. Anyway, my version is below and let’s you specify the list delimiter as well as control case sensitivity, in addition to preserving the original sequence of list items.
Read More…

CFBuilder 2 Performance Problems on Windows 7 64-bit Solved

For those of you that continue to experience hangs and massive slowdowns running CFB on Windows 7 64bit, the one thing I found that made all the difference in the world is to have Eclipse use the jvm.dll rather than javaw.exe (the default). I’m using the CFB plugin into Eclipse, but I suspect this may also apply to CFB standalone on Win7 64bit as well.

Read More…

DBX 10.1.12 Released

This update allows DBX to display included columns when enumerating indexes for tables. Based off the sp_helpindex2 stored procedure from http://www.sqlskills.com.

Download from dbx.riaforge.org.

Helpful Spelling Tip

Been a long time since I’ve posted, mostly since no one except spammers bother to come to the site, but I’ve finally had it and had to vent into the ether before my head explodes.

Read More…