Reorg is specifically for indexes that are only lightly fragmented as a way to give them an augmented performance metric at very low cost. You're looking 90% fragmentation. you need...

GilaMonster (3/15/2011)

---

Awesome. Great fun. Timing went perfectly too (for once)

Trying to figure if I managed...

I'd say Nivek summed it up fairly well there.

Even on a reporting server you might want to consider changing the defaul threshold for parallelism to a higher number. I wouldn't go as high as on an OLTP system,...

In the glance through, nothing leaped to my eye except the cursors as well. But I'm in agreement with Steve.

First thing that jumped out at me: dbo.AncestorsAndDescendantsOfSubAccount(@subacct) Family

Is that a multi-statement user defined function? If so, that's where I'd start. Eliminate that.

Without an execution plan, it's hard to know...

Sorry, just trying to understand. I saw remote and local and inferred. Remember, I'm not there. I'm just going off what I'm told.

When you say remote, do you mean remote...

that makes sense. I've heard of getting dupes in identity, but i think it was a one-off bug or something. Certainly nothing standard.

Sounds like a simple security setting. Go to the SQl Server Configuration Manager and ensure that the SQL Agent service is running with an appropriate login. I'd suggest using an...

Without going to a third party product, your options are extremely limited to already having configured the system to restore a filegroup as outlined above, or doing a full restore...

Are you doing anything at all to the identity column as part of your insert processes? I only ask because, while I've seen issues around identity, not generating a unique...

Yeah, I agree. Start at the exec plans and see if there are differences there. But, the biggest difference to me is that one database is local and the other...

Kit G (3/15/2011)

---

Grant Fritchey (3/15/2011)

---

Jeff Moden (3/14/2011)

---

It'll be my pleasure to take a gander and maybe run some code, Craig. Lemme know. Actually, you could do the same...

You're confusing two sets of functionality. The variables in Visual Studio are just part of the build and deployment, not a part of coding. All they really are is SQLCMD...

EasyBoy (3/14/2011)

---

Grant Fritchey (3/14/2011)

---

If the goal is to identify which servers or databases have a failed backup, instead of running reports, I'd suggest taking a look at setting up Policy...