If, for any reason, the maintenance plan cannot delete a backup file that it should (file locked due to file system backup for instance) the file will not be deleted...

I like the back of my ;BEGININATOR t-shirt, it says KEEP CALM AND SQL ON.

Any way, I gave the OP something to chew on.

No promises on performance since you really haven't provided anything that is probably remotely close to your actual production environment.

create table #cs

(

[Year] float,

[Week] float,

[Month] float,

[C#] float,

[Dept] nvarchar(255),

[Issue] nvarchar(255),

[Type] nvarchar(255),

[Dept age]...

What does 2012 have to with...

IF your actual production table has data for the PAST 10 years, do you still want us to write a query that when run against this table will pull all...

Okay, so your actual table may have 10 years of data and you want us to use NOTHING for the WHERE criteria, correct??

You aren't doing anything to help us help you.

Again, with more feeling:

Lynn Pettis (6/19/2015)

---

Okay, I must not have spoken clear enough. Please reread my earlier post with the two...

Sorry, but I started screaming.

WITH WHAT FOR THE...

And also post the actual execution plan as a *.sqlplan file.

Still have NO IDEA how you are wanting us to query the data.

This isn't what you need but it is the only way I can seem to explain what we...

Okay, I must not have spoken clear enough. Please reread my earlier post with the two steps I said you should take to help us help you.

I will even...

Here is the problem, we can't see what you see. We don't have access to your systems, we don't know what the data looks like, and we don't fully...

Sean Lange (6/19/2015)

---

ChrisM@Work (6/19/2015)

---

I'm with Alvin on this one Sean - walk...

Sean Lange (6/19/2015)

---

Alvin Ramard (6/19/2015)

---

I think this is one of those threads...