dont think it was slow. getting a load of errors saying principal db canot contact mirror db on mirror server. more like an outage than sluggish network. il go through...

Im really liking this thread. I used to suffer from anxiety, and once you are prone to this, its always in the back of your mind.

The thought of doing...

CirquedeSQLeil (1/15/2010)

---

Winston,

Try doing it as Jeff has just explained. Create multiple procs, from one of which you will call the other. I think that will probably satisfy the...

i thought though, that as im calling the sproc from my session, the table created in the sproc is created in my local session, and so i should be able...

A time lag is a good idea, but it increases the potential amount of data loss, am i correct in this assumption?

Thanks for the reply. Clarifying that mirroring is at...

No, there is no index similar to the one you created. I couldnt create this index straight away, regardless of how much it boosts performance as there are strict rules...

lmu92 (1/4/2010)

---

You're very welcome!

Would you mind sharing the results for both versions when applied to your "real data" for both solutions? (including total number of rows in table and indexes...

awesome! Thank you for the help on this. I like to see alternative ways of writing queries as I have a problem that once i come up with a solution,...

hi.

Thanks...

thats an interesting theory, and il give a look on the source db tomorrow, however, one thing it doesnt explain is that, when the resotre was run in via a...

Thanks for the responses guys. Yes, you are correct Gail. Its for position within Microsoft.

As you say, Il give it a go, and let them decide if I am fit...

Thanks for the reply.

im trying to compare initialization by snapshot vs initialization via backup of publisher restored to Subscriber.

In the case of initialization by backup, should i monitor the distribution...

ive really enjoyed this thread. I have not had this issue, but i do want to investigate what processes are using the most space in my tempdb.

Anyone give me...

In case it helps anyone in a similar situation, to resolve the issue of lack of sp_makewebtask in sql 2008, we used SSIS. We output the data to an...

Oh Crap! This will be a long week!! Thanks for the quick response.