We use an app that creates a new db for a every new company, so I don't know how may databases exist.  Also, there are databases on the same server...

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

But the index is organised as a B-tree, so it needs to search the nodes to get to the min and max values. So depending on the depth of...

Here is the exec plan.  I just figured that since a page is 8K, a single integer would easily fit on one page and since the plan is a seek...

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

I haven't seen any solutions where CalendarCycleStart or CalendarCycleEnd is included in the CROSS APPLY select statement, so they wouldn't be usable in the where clause right?

Something else I've noticed.  The query that runs fast has does a seek on the p1 alias with 2 seek predicates ( parentID = null, pkg_id = {pkg_id in where...

I've come up with the following way to get the list of pkg master IDs with a recursive CTE.  My question now is, why does it take nearly 4 sec...

I thought about that, but both VMs use the same datastore, so if it was disk contention they should both be effected.  It seems to be related to the VM. ...

Also, the -t may not work without a separator arguement such as a comma. i.e. '-t,'