Dear Drew, I'm sorry, it was not my intention 🙂

I know that's difficult to explain and i'm trying to do my best

Ok, here some data to seed the database

CREATE TABLE...

Thanks for your response Drew,

the output of my query is a print of multiple select of different tables, so an "union" can't work

You can test the query in all database,...

Yes i'm using offset, the problem is that i need to calculate the offset around multiple query in print output. For understand what i mean please have a look at...

No joy at all of late.

This is a view of the current running situation. 12.0.2000

I previously had 12 executing procedures, 10 active and 2 were pending memory grant.

3 procedures have...

... but to no apparent effect.

For laughs, I went to SQL2014 because, hey, I can 🙂

The agent is started with the governor turned off via the trace flag.

I started 5...

-T8040 seems to have removed the offending functionality completely.

I removed the installation and installed a full Enterprise edition.

No change.

Amongst the irritating things is that I do not have access to the star tup parameter settings in the configuration...

Cody K (3/31/2014)

---

I don't know. But if I was going to explore options:

1. I'd check there's no Processor Affinity masks set, and no maximum number of concurrent connections. I know...

See OP. It is a default installation, so they would be MAXDOP 0 and Threshold 5.

This makes the practical MAXDOP 12 (# of cores)

This is irrelevant because the queries I...

a) I thanked you politely for the reference.

b) I have not indexed the internet in my head and neither have you.

c) "it proves" that I didn't "google" well enough

c) Which...

Thanks for that info - that's news. I will investigate that possibility.

The poster comment about number of partitions can stand forever, it will still be wrong. I have simply not...

Jeff Moden (2/5/2014)

---

sqlcentral2 (2/5/2014)

---

Simple question.

The partitioning scheme with indices calls for about 1100 file groups per year (one file per file group), and there is 20 years of data...

markjholmes (2/5/2014)

---

That is an absolutely staggering amount of data to me. I work at about 1/100 that scale - 1B rows and about 80 partitions/filegroups for my largest project...

Oh dear.

Msg 7719, Level 16, State 1, Line 1

CREATE/ALTER partition function failed as only a maximum of 1000 partitions can be created.

I can see now that the SQL2012 docs have...

Well, pretty obviously it doesn't work or I wouldn't have posted.

This limitation does not appear to be documented, and a catastrophic failure with subsequent disconnect is hardly an appropriate output/result...