Cheers. If it's an interesting solution, maybe you want to write about it? 😉

Send in a short piece on how this is helpful to you or how you use it?

Depends on the queries. Multiple things can be done

https://support.microsoft.com/en-us/kb/2876733

http://thomaslarock.com/2013/05/top-3-performance-killers-for-linked-server-queries/

http://stackoverflow.com/questions/10204498/optimizing-sql-query-with-a-linked-server

I'd do what Hugo suggests, using a Tally Table, which is a great way to do this.

chrisn-585491 (1/13/2016)

---

100 hours may give you an appreciation of an subject or language, but it usefulness depends totally on the circumstances. There's broad and deep knowledge that isn't easy for...

My only thought here is that if you know you have windows formatted files with a \r at the end, you can count these with a seperate, non SSIS process....

Sorry, I thought I read a link that showed connections falling back, or switching to TCP/IP. I think I had the wrong link there. My apologies.

I've been looking around and...

it's helpful if you use a fixed font, so the Code=other or code=plain format to the left, when you post.

How are rows 4 and 5 dupes? Unless you mean that...

I'm not sure where the problem is. There are always non-standard things each browser does, which means that you'll have different interpretations. There are also the requirements of "get this...

I think you'd need a separate process that counts rows, knowing what a "row" is in the file format as a

delimiter.

You can look for error rows in your flow,...

There are cases where applications will fall back to TCP/IP, which might be happening.

http://www.sqlservercentral.com/Forums/Topic988886-1550-1.aspx

Phil is right. If this is any column, you might have a lot of work.

In general, you can use a count() on a column, with that column as a group...

Script out replication, always, and keep it handy. There are times you'll need to reset it up.

Use that to move replication to a new, SQL 2014, instance.

This might be easier to consume. Wasn't aware of it myself until Argenis Fernandez mentioned it

DBCC DBTABLE

The TCO,...

lionfan91 (1/13/2016)

---

I was in a position where I had written a few small single purpose applications that a bunch of folks used. They were somewhat related, so we ended...