It is often appropriate in DW loading processes to DISABLE autostats stuff before load, then manually do stats after the load. you really don't want them firing multiple times...

I actually meant to add E) Call Microsoft! It is definitely (past?) time! Best of luck with it. Please post back here if/when you get things figured...

Yeah - pretty out of whack there.

A) You sound like you know what you are doing, so have you tried some of the 2005/2008 stuff (such as here: http://blogs.msdn.com/b/psssql/archive/2008/06/16/query-performance-issues-associated-with-a-large-sized-security-cache.aspx)?

B)...

deep3.kaur 98681 (8/29/2013)

---

Our Server1 Db is running on SQL server 2008, and the server has 2 processors, 2.67 GHz , 60 GB memory, 64 bit operating System, Windows server 2008...

I suspect that if you had been playing around with SQL Server for over 40000...

nathan 7372 (8/29/2013)

---

I'm having problems with my USERSTORE_TOKENPERM cache becoming growing. When I came in this morning it was 2.4 gb and was actually larger than my buffer pool....

Here you go: ...

My advice is to set up a test and actually do it to verify (and learn in the process). Partitioning REALLY isn't something you want to learn about from...

I don't open excel spreadsheets from the web.

Sorry, I wasn't specific enough in my request. I (and others that might help you) need CREATE TABLE scripts (temporary tables please,...

I think -2 is an orphaned distributed transaction. Do some investigations along that line.

Also, I see that you are doing a parallel update (same spid multiple times) and using...

I have an example almost identical to this in my Common TSQL Mistakes session I have given about 75 times now. It represents the WORST king of data processing...

To my knowledge as long as you try to do something like this:

USE AdventureWorks2012

GO

DECLARE @totalrows int

SELECT *, @totalrows = TotalRows

FROM (

SELECT JobTitle,

...

Please provide sample tables, data, and expected output. We can't do much for you without that as a starting point. Also, I don't understand your question about query...

And while you are gen'ing up sample data for us search the web for Itzik Ben-Gan's various posts and articles (SQLMag has some iirc) on interval processing. There is...

http://www.datamanipulation.net/sqlquerystress/ --Adam Machanic's, quite solid and well used

http://www.sqlstress.com/

tpcc/h

http://hammerora.sourceforge.net/

dvdstore

http://www.sqlservercentral.com/blogs/technobabble-by-klee-from-kleegeek/2013/07/29/benchmark-your-sql-server-instance-with-dvdstore/