Was this working an now suddenly not working? And on only some work stations?

I know there were issues with WinXP after some service packs that disabled the AxtiveX control in...

Jeffrey Williams-493691 (8/20/2011)

---

To the previous posters about SQL Server Standard only using 4 CPU's - I believe that is a licensing number and does not have any relationship to the...

Can you point me to a document on this? I'm not convinced that standard can only...

Except if you licence Per Processor, you only pay for 2 licences, not 8.

This took me for ever to get my head around.

Leo

If you look at how many processors SQL sees, you will see it says 8. If you want to set MAXDOP to try elliminate the CXPacket waits then 1 is...

Did you review the scripts before you ran them? Did they look correct?

Also after you ran the scripts where there any errors reported.

There are a few things that can go...

jprovines (8/15/2011)

---

Ahh, sorry guys, it was the mirror deleting the logs too soon. The principle was saying deleting old logs, but the mirror says deleting old logs and gives...

What time does the restore job run? At the same time as the backup job?

It would be interesting to change the time and see if this changes the deleted files...

Are both of these folders being cleared after 2 days? If not which one is being cleared?

Leo

You don't want to have both nodes active when installing the service pack. Usually you would go to Active/Pasive, then remove the pasive node from the cluster.

I would stick to...

Like a maintenance task set to delete old tran log backups older than 3 days 🙂

Leo

Ninja's_RGR'us (8/10/2011)

---

Leo.Miller (8/10/2011)

---

Another solution would be to set all the queries to use WITH (NOLOCK)

select * from Test1 with (nolock) where ID_Col = 10

But I would consider this a bit...

Another solution would be to set all the queries to use WITH (NOLOCK)

select * from Test1 with (nolock) where ID_Col = 10

But I would consider this a bit of a...

Yes.....

But I assume you want more than this..:-)

On one connection do the update - This was my test

begin tran

update Test1 set First_Name = 'Test1' where ID_Col...

10 named instances, one for each application database seems a bit over the top. That's a fair bit of admin you would be adding for each application. I'd recommend some...