Reporting Services is not cluster aware - and it is not recommended that you set it up that way. If you want it to be accessible from all nodes...

We also need to see the expected results - but, you can start with this and see if I am close.

SELECT *

FROM @MyExample r1

LEFT JOIN...

dba_neo (2/1/2010)

---

HI,

i got the message for all indexes as follows

Executed: ALTER INDEX [IX_ActGUID] ON [dbo].[Primt] REBUILD [SQLSTATE 01000]

Msg 1934, Sev 16, State 1, Line 1 : ALTER INDEX failed because...

Why did you change the memory per query option? That generally does not need to be changed and should be left at the default value.

On x86 systems, task manager...

Mani-584606 (1/31/2010)

---

thanks you,

how to find if the statistics are out of date? As our indexes are not getting fragmented, so I'm planning to run update statistics to keep the statistics...

The classic answer applies here - it...

Okay - you do not need to rebuild every index, just those indexes that are fragmented. Using any one of the scripts available to identify and rebuild or reorganize...

Are you really concerned about having a 15GB log file? How large is this database and how large do you expect it to get?

Having a large transaction log file...

tjp8 (1/22/2010)

---

I have found that sometimes a log file in simple mode will shrink without a backup and sometimes it will not. It usually works for me to do...

Drop the min memory value - leave the max where it is.

This will generally happen when the client tools have not been upgraded to at least the same version as the server you are connecting to.

Validate your clients tools have been...

Steve Jones - Editor (1/29/2010)

---

I would follow Lowell's advice. You need a unique constraint to ensure your data is intact, but there's no need to copy all that data over...

You should not set the min memory equal to the max memory. This prevents SQL Server from managing memory correctly and can cause some problems (as you are seeing).

Drop...

Well Roy - you might want to slap yourself a bit...

I have found that the easiest way to do this is to use a comparison tool like Redgate SQL Compare. To use the tool you do the following:

1) Create...