As a feedback and for completeness we ended up using:

DBCC DBINFO(DATABASENAME) WITH TABLERESULTS;

Thank you very much for pointing us in the right direction

FWIW: I do get those three records too.

We are trying to create a few ways to apply delayed transactions to some remote servers.

Database snapshots are "fast" to create and easy...

Jeff Moden (9/4/2013)

I appologize for not being able to help here. I've not had the need...

Well?

Does anybody have the inside on TDS that I am looking for?

I suspect that TDS has limitted size buffers and that the protocol itself imposes this speed limit.

600mb by today's standards is really not a lot of memory.

For reference I can...

I disagree. SSMS takes similar time using shared memory on the machine.

The fact that I get linear increase in throughput as I parallelize the access indicates that there is...

there is no RBAR here. The server shows ASYNC_NETWORK_IO in both cases (shared memory and network)

We get in our software similar speed to SSMS

First I would disagree with "this is a known issue"

In the vast majority of the cases you do not need to do this.

I had used transactional replication _a lot_ and...

The article was well explained and straight to the point.

The title on the other hand is *VERY* misleading (seconds?) Apparently you don't count the time you spent setting AND processing...

What is the problem with fulltext_index_columns ?

SELECT

t.name AS TableName,

c.name AS FTCatalogName ,

...

you can setup peer-to-peer nodes but do not get carried away with that. There is a limit in the number of peers that can be setup

The main problem is that...

Expecting any kind of useful answer with such description of the problem is futile.

Your trigger is not correctly written and it can definitely do what they shouldn't

Contrary to popular believe on this thread FKs CAN affect performance when the referencing table is very large and you perform a large number of writes!

Second, Replication normally marks foreign...

I used to build stuff this way loooooong time ago.

I would advice the author to look in to ORM products (that many are free) which contain MANY specifications and build...