I use Simple for dev/qa databases because there really is no need for point in time recovery.

Rule of thumb is if you do not need PIT recovery, and you are...

You're essentially doing the same thing. Whether or not you load it into memory first, SQL will still pull all data into the cache..I'd be willing to bet you'd have...

Try adding a case statement so it only filters it if there is a comma..here is lowell's code modified a bit.

With MySampleData as

(

SELECT 'Support Centres , Miscellaneous SC' As TheName...

Both DTC and Quorum should have the drive as a dependency, so I'm not sure how they're pointing to the same disk if they're in different groups. If the dependency...

I've done something similar in the past by just setting a flag on a table, and then putting the entire code into an If statement - if the flag is...

If you already have a cluster, I would create a reporting instance on the other node and set up either just transactional replication, or asynchronous mirroring and create a database...

Thanks Ed - that did it. I'm using SSMS 2005 (installed at the same time as RS) directly on the report server, so it's not just an SSMS 2008 issue...

Please don't cross post

Direct all replies to: http://www.sqlservercentral.com/Forums/Topic988513-146-1.aspx

The dbcc showcontig with tableresults output he posted earlier has...

The stored procedure gets compiled at run time (and then cached), the same as running individual statements. There should be no difference in performance between the two, or at least...

Here's something that will do the trick..but there's a few caveats.

Right now it only works on jobs that are scheduled either once per day, or at an X interval of...

Nope..not easily anyway. You could get the schedule interval and try to calculate from that..but honestly I think that's way, way more work than it's worth. Actually that would be...

Yes.

Shut down the passive node, upgrade, move SQL to it and test. If there are any adverse effects, or bad ram/etc, just fail it back and take the new ram...

Thanks for keeping us updated. That's really odd behavior that it continues to show all of that space being used while it has a clustered index, 0 rows, no forwarded...

I'm a little confused.

Do you mean you want your results to be:

agentcode agentname

1 Nolrick1

Or does...