A covered index is one which contains all fields referenced by the query. In this case, the query gets ALL its data from the index, and never touches the table...

I look at execution plans with temp tables in them all the time. I do not know of any reason you should not be able to do the same. Or...

The bookmark lookup can be eliminated altogether by modifying your index to be a covered index and I noticed that no-one had mentioned that. There's no guarantee that it would...

Let me go about explaining this in a diffeent manner, as I think you are missing my point.

A primary key uniquely identifies a row in a table by definition. In...

Yep, once for each article.

The idea of metadata has been around for many many years. I just apply it to this the same as anything else, and I really can't...

Yes, but you have to itterate through the articles you want the subscriptions to.

Use:

sp_addsubscription @publication = 'publication'

, @article = 'article'

...

So long as it is truely a dedicated SQL Server, I have never had any problem with eliminating it altogether, or reducing it to absolute minimum. Start running IIS, or...

You were not rude, and I certianly didn't take it that way. I honestly wanted to know why it wouldn't work for you, as I felt I might learn somrthing....

Exactly....

LMAO....excellent points.....and I can't argue what IS in the world.

I guess I'm just too much a stickler on what should be, and best practice.

That's what I was talking about. And yes, this weekend I will write it up as a document and publish it here for everyone. I verified yesterday that nothing goes...

If you use the filter options I referred to and used push replication, the filter would be applied at the publisher. Also, a good approach if you do not intend...

Due to ANSI standards the order of records returned to you is not guaranteed by SQL Server. This is true. Using an order by clause is the proper way to...

Shoot me an e-mail with the detials, my address is in my profile. I am interested enough to look at it.

In the situations I've seen, the values were calculated from the previous days values, so If a value changed two weeks ago, every value from that point forward would have...