I would honestly recommend passing this back to your manager. They are best positioned to identify or at least assist with setting your SMART goals. They should have the awareness...

Also be sure that the share is in the logshipping group in the cluster and that it has a dependency on the disks of the group so that it...

There's always value, I just felt that maybe I should look forward. Just felt bad about throwing away the old MCTS :laugh:

I am increasingly finding that the complexity of the environment requires the need for a DBA with experience and knowledge.

A simple onesie twosie instance could be potentially handled by...

That's how I wound up missing Kevin Klines seminar on Friday 😀

Why not walk around with a big stick and lay the smack down on people who do that? :w00t:

Are you trying to have the Citrix users run the report builder off of the Citrix boxes?

If that's the case you should work with your Citrix admin to get the...

Seconded that DAS is not a viable solution for what you are trying to accomplish. Performance would be horrendous, and I would hate to think of the number of drives...

Jason Shadonix (9/26/2008)

---

I really am not interested in improving the speed of the query...it can take 20 min. to run for all I care. I'm just trying to figure...

How current does the data need to be?

Could you create a denomarlized table containing the resultset that you would need for the query?

Would you be able to post an xml...

Have you monitored the locks and lock escalations while the query is running?

Have you performed a reindex recently and are the stats up to date?

How does the execution plan look?

Sorry,...

Could you create a stored proc on the local server, and have the remote servers execute the proc and bring the results locally?

By the looks of things each server runs...

You aren't kidding that it's a doosey :w00t:

Are the remote servers pulling the data from the local server using that query?

I'm trying to figure exactly what you are doing here. You'll have to excuse me, sometimes the ADD kicks in and I miss things.

Just to try and clarify what you...

Are you actually backing up to disk? Or is it to tape? You have a whole bunch of things in there which seem to conflict.

Have you tried to break it...