I have several pet peeves about the Filter Settings dialog in SSMS.

Adding Filter Operators such as Starts With or ends with to the dropdown

In more detail, the navigation on...

Thank you for the update. My preliminary tests look good. The actual table change: ALTER TABLE myTable ALTER COLUMN theCol varchar(max) seems to affect metadata only and was...

Hi Hank, for the benefit of others facing the same challenge, did you end up with any "gotchas" with the conversion of your app?

Unfortunately, no. It's financial transactions that are basically a race to the database. They have timestamps, but really just the Identity field is the only way to uniquely...

Hi Wayne, I created found a good article on this and made a proof of concept that works well with simple data sets. However, one underlying assumption of the...

Awesome! Thank you!

I wasn't seeing any tables in my results. I think you need a left outer join to sys_columns because Object_Definition on Table

returns NULL

I just noticed something else with my "In" syntax. If you put the IN clause into a JOIN, you can use the LIKE against the original source table for...

This doesn't work for a LIKE condition, but for equalities in a small number of fields, you can use

WHERE '411-555-1212' IN (HomePhone, WorkPhone, CellPhone, AltPhone)

I've found it useful when...

Thanks for replying. I just finished an inelegant but workable solution. The problem was that I needed some blank placeholders added to my temp table. I added...