Noggin & Jacob,

Not sure if it is the best way, but I handle ascending and descending via parameter by throwing this order by on the outer query that references the...

I know it is just a matter of personal preference, but instead of parameters like @PageSize and @PageNumber I use @FirstItem and @NumItems. All of the array operations in c#...

Franco,

I was just looking at a similar trade-off. I found that for my needs, the answer depends (big surprise ).

It depends on what columns...

Hi Juan,

SQL Express only supports being a subscriber to replication topologies, not a publisher. What this means is it can retrieve data from some non-Express SKU (and non-free), but it...

By 'cluster' do you mean a "SQL Cluster", or are you just running sql servers in a NT cluster? If an NT cluster, do you split your client traffic 50/50...

Supaul,

Ok I'll grant that technet is a good reference for your suggestion that concurrent snapshots are the default.

But when technet and the product behavior differ as in this case, I'll...

Ryan,

Approach #3 is very interesting, but I can't imagine it outperforms the solution I posted on page 1 of this thread. If you end up testing that one out as...

What kind of replication? Do you need to be able to make edits to both servers, or can one of them be a read only version? How quickly do you...

Ian,

I think this is a good approach and it is actually what some coworkers and I ended up with awhile back (more them than me

I had a need for pseudo randomness (display a few "random" images from a gallery) that I addressed thusly:

-Assign a random value to each row as a column value and...

I'm not sure I understand the problem. Are you saying the subscription was added by IP address instead of by name?

Typically your subscriber would be like 'myserver02', and you would...

It is common to use log shipping for this kind of scenario where you want to keep a recent version of the DB off of the live server for reporting...

The same solution is talked about in this article which I found to be a good read:

http://www.microsoft.com/technet/technetmag/issues/2006/07/InsideMSFT/default.aspx

Where are you getting your information?

BOL for sql2k5 (http://msdn2.microsoft.com/en-us/library/ms188738.aspx) states for sync_method:

"Defaults to native for Microsoft SQL Server Publishers. For non-SQL Server Publishers, defaults to character when the...

I was wondering the same thing as Bell Wehnert.

My topology is using the default sync_method of native so this question is making me wonder if I'm using a less than...