When you say you use lots of temp tables, are you querying/filtering on the columns that need AE? If I had

create table CUstomer
(CustomerName varchar.

I don't. been a long time since I've used the DTS system at any scale, and haven't tracked the rows here. I'll try to set up a test and see...

This article (http://www.sqlservercentral.com/articles/Agent+jobs/101563/) might be of interest.

You can get some information from here: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-fts-index-population-transact-sql
However, I'm not sure this will do more than give you an idea of how many more items need to...

Yes, lots of articles on different parts of basics stats.

Amber ale here, so feel free to sort one for me if you see me.

Or tequila and something. OJ, CJ, GJ, water, ice, whatever

Good catch. I have Ajayi and since I'm in the UK, missed the announcement about the cancellation.
Thanks

Lots of cutting and bagging grass for me, and an emergency sprinkler repair when I may have hit a head with a mower. Or kicked it, or something.

I think we're good. I'll close this for now.

I had a reminder, but I was at Home Depot at the start, getting parts, and then fixing a broken sprinkler head before heading to the airport.

Apparently Yahoo...

A filetable isn't a folder like d:\data\currentdatefolder. It's a share on the system that is managed by SQL Server. The idea with Filetable/Filestream is that you can access the data...