Sorry, query the table in an SSIS task. Based on the value, then you would execute the proper code.

set @currentmirror = select status from dbmirroring table

if @currentmirror is null

...

Your Target server memory is what SQL wants, and it matches your total. So I don't think you have memory pressure here.

The high I/Os might just be the sign of...

You also still haven't explained what doesn't work or the join. What is the point there? I assume that you are trying to get child records, but is there a...

Being sa on SQL Server, either on Win2K3 or Win2K8 doesn't give you rights to stop any service. That depends on your rights in the underlying Windows host.

In 2008,...

Please don't post your email in forums. Responses will come here.

It's not quite clear what you are asking. Please spend time to clearly explain what you do not understand. To...

It's lazy developers. They think their time is too valuable to optimize this instead of fixing it right so that network and database resources are not wasted. A simple checksum...

How long do you need to keep this? And how is the data used? It can be handy to keep this information in each record, and it can reduce contention...

Would this help?

http://msdn.microsoft.com/en-us/library/ms178655.aspx

You could scan this for the status of a mirrored pair.

So what is not working? You haven't provided a reason why this doesn't work, or what you want to do. If you want to return all items from the table,...

I'm sure Jeff will like this: http://www.pcworld.com/article/215741/microsofts_hotmail_fail_a_bad_sign.html

It's most likely a people/process failure more than SQL Server, but it does give ammunition to the idea that individual cloud customers might not...

I might check on a few things here.

1. Check the buffer cache hit ratio, and see if it is high. Below 90%, I'd definitely be thinking memory.

2. Check page...

george sibbald (1/7/2011)

---

Steve Jones - SSC Editor (1/7/2011)

---

Mrs. Tripp recommends 512MB segments, so growth around 8GB at a time.

I would guess that depending on your volume, you might get better/worse...

Mrs. Tripp recommends 512MB segments, so growth around 8GB at a time.

I would guess that depending on your volume, you might get better/worse performance with that size. You'd have to...

Math is fun. Was working with my son on negative exponents the other day. Why do we flip it to the denominator? It's what we do, it's the pattern of...

Tom.Thomson (1/7/2011)

---

Nice question, but: why would anyone create a 50GB log file in one fell swoop, rather than say making a logfile of 7142 MB and then extending it by...