bopeavy,

The database exists on a shared resource (disk), however, only one node "has" the resource at a time, when the failover occurs the disk goes with the name and IP...

Parameter mapping does not work in cases with an even marginally complex query. In those cases you often have to resort to sprocs. And 12K is a fairly...

Jan Van der Eecken (5/26/2011)

---

GilaMonster (5/26/2011)

---

One very uncomfortable PM sent...

From the posts the person has made, they are totally out of their depth. 6TB DBs, major perf problems and barely...

Not sure, is the problem you didn't get a name for MEAL? You could do a 'MEAL' AS Meal

I didn't look over the query..

CEWII

Ok,

Can you tell me where you found information that said you could use NT SERVICE\Service Name to grant access to SQL, I haven't seen that before and my google...

What is the desired output?

CEWII

You are welcome.

CEWII

If its real then fine, but I don't "do homework". Let me think about it over lunch..

CEWII

My first thought was locking/blocking do you see anything in the Activity Monitor?

Having increased the DB sizes tends to take growth waits out of the equation.

CEWII

Is this homework, cus it feels that way..

CEWII

If you BCP it out you still have to spend the time to BCP it IN.. It would still be faster than what you are doing though. I...

I'm thinking that at their level, you aren't really dealing with HR anymore, you are writing books and contracting..

CEWII

Somehow I put Paul, Kalen, and such at well ABOVE Senior, level 4, 5, 10?

CEWII

SQL doesn't look at it that way.. It is 4 selects and 1 insert.

CEWII

I'm going to take a different direction. 50m for 2.7M records is terrible performance. You could likely do it in under 5m with SSIS. You could use...