I've still been working with Microsoft off and on to try and get this permanently fixed. Their current stance is still that if you are having this issue set...

Well I ran it on our production table with 1.2 million rows and it runs in 260 ms so I think that will work just fine 🙂

Thanks Stephanie this looks perfect. I'm going to test it with our full dataset and see how it does. I'm sure you are right and it could be...

Interesting. After a quick search for correlated sub queries I understand why this is expected. Thanks for the help and another tool in my belt.

Nothing like a little necromancy. Here is the current status of this for anyone else searching on this problem. Using sp_setapprole and sp_unsetapprole will cause the userstore_tokenperm to...

I followed the directions in this article http://support.microsoft.com/default.aspx?scid=kb;EN-US;959823

Trace flags 4618, 4610, and 4621 seem to have no effect on the caches ability to grow. It continues to...

1) The build is 11.0.3128

2) I'm getting the memory sizes from sys.dm_os_memory_clerks

3) I clear it out using DBCC FREESYSTEMCACHE (‘TokenAndPermUserStore’)

4) Windows Server 2008 R2 64 bit. Sql server is...

Does anyone have any idea where I can go from here?

Thanks for the help. It has been so long since I've worked with such a large number of floating point numbers and calculations.

I really appreciate you taking...

I've come up with a bunch of different ways to get SQL to spit out a two decimal point answer. What I was really curious and hoping to understand...

The datatypes are float. The reason I am rounding beforehand is because we will be cutting checks and I have to prove that the amount of the checks will...

Floating point rounding and adding behavior is a well studied field. If you want me to put together an example to run on your system just say so.

Another scenario you might get the dreaded cannot login as user 'null' is when you are trying to use windows authentication across trusted domains.

If the trust between the domains breaks...

The server memory is only at 20% utilization so I don't believe so. The only other thing on that server is SharePoint and it doesn't seem to be taking...

The only ones that aren't the service accounts are the reporting services and the integration services. Does the agent somehow run through integration services?