The documentation for STGeomFromText only lists strings as possible inputs. How about using STUFF and FOR XML to build that string? It's a bit clunky, but it probably beats...

• This reply was modified 6 years, 4 months ago by pdanes.
• This reply was modified 6 years, 4 months ago by pdanes.
• This reply was modified 6 years, 4 months ago by pdanes.
• This reply was modified 6 years, 4 months ago by pdanes.

How well does this perform? I admit it's interesting, and shows techniques I didn't even know existed, but is it more complex than necessary?

I have always used a simple self-join...

• This reply was modified 6 years, 4 months ago by pdanes.

Thank you. Losing all data is NOT going to happen – I've got multiple backups all over the place, on-site and off. Transaction log every 15 minutes, differential every hour...

Yes, I was trying to upgrade in place, over the existing installation, to avoid having to migrate everything. It's a fairly simple setup, but still, copying everything over manually is...

But I think you've answered my question. If the indexed view will only be considered in Enterprise, then the extra columns are pointless, and my indexed view would be better...

I'm still using 2008 R2 standard edition. But I'm looking at upgrading to 2014. Nothing newer will run on the OS this server has, and I don't know if I...

The requirements are to look up and filter by conditions in the data, almost always at least partly by the letter. I would not use this filtered view directly, I...

Yes, I can use the check constraint for the field. But I need the additional constraint of uniqueness for specific types of data, while not for others. I don't think...

Looks great. Many thanks to both you and Mike - I had no idea this feature even existed (SQL Server is kind of overwhelming sometimes). This takes care of my...

Thank you, Steve. I just looked at some intro tutorials. It doesn't seem as bad as I though at first. I enabled Filestream in the DB, according to instructions on...

Hm, okay - that's an interesting idea.

This was originally an Access database (actually, it was initially a series of Excel spreadsheets, before I got involved), so packing this much attachment...

1. This does the same thing as the PowerShell command, and runs at about the same speed.
2. I don't know what you mean here. I thought filestream was for reading...

Look at what the resulting values are that come out of the hash match - in the first query the number of rows is less than what you see...

Looking at the difference between plans:

The first plan utilizes an index scan using the index ix_TaxLok with no predicate.  This results in an estimated row count of 124720 and...

Nope - nothing changed. The plan looks the same, the estimates are the same, and it even...

• This reply was modified 6 years, 7 months ago by pdanes.