This is what I've found so far:

http://msdn.microsoft.com/en-us/library/ms151762%28v=sql.105%29.aspx

By default, transactional replication propagates changes according to transaction boundaries. If transactions are smaller, it is less likely that the Distribution Agent will have...

I would go as some said about the interviewer would like to hear about your ACID knowledge but in a case where he would absolutely like something:

Running some concurrent queries...

Something which is not always look at is:

your co-workers.

They can make your job either like heaven or like hell even within the organization rules.

Dune

To my eyes it's amongst the best sci-fi movies ever.

It might be a bit more than past years thought 😉

On step four, synchronize the data, I understand that you have, from whatever mean you want to, select missing rows from the published table and insert them into the subscribed...

Easy question, none (no hour per whatever period) are officially allowed.

You are granted to read something if it's directly related to the work being done right now (not tomorrow otherwise...

Ahahah

I know it won't but that's what dream are for right (and in color plz!) 😉

Ty for your time (and Gail) on this one.

Thanks Grant,

It works exactly as you described. It even works when using FORCESEEK (as it should as Microsoft stated)

It would be nice having an index hint that force index intersection....

Ty Grant for the example, I'll test it on my box tonight and check the generated execution plan.

I have different values for the 2012 version of the book coming out...

I understand the point which is "to be accountable for your mistakes" and I praise this way of life but for several reasons I would not work for such company.

Over...

Our client base (for our software solution) mainly uses XP so upgrading is not even "thinkable". We're a particular niche and we must conform to this situation.

Have you done a bug request on connect or to Microsoft directly?

Although that won't solve your issue right now, having them to understand what has crash SQL (what has generated...

At least I'm not the only one who notice the category name and title!

As most of you stated, using DMV will be safe on the production server but working what ever the reason on a production server is having a damocles sword up...

Thank you for your time Gail.

I now get only 4 reads and the memory is kept to a minimum.

I'll need to investigate why the initial run took more than 100...