Recent Articles by Websolete

T-SQL function to de-duplicate lists

Needed a function to de-duplicate string lists, so I wrote the following UDF. The UDF preserves the position of list elements, and let’s you specify the list delimiter as well as control case sensitivity.  Based on a UDF by Pinal Dave at http://blog.sqlauthority.com/2009/01/15/sql-server-remove-duplicate-entry-from-comma-delimited-string-udf/, but I didn’t care for his variable naming much, and I added the sequence preservation and case sensitivity handling.
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…