This is a bit strange. I have NP disabled, but I see it started with this

select * from sys.endpoints

Can you run this:

alter endpoint [TSQL Named Pipes] state = STOPPED

Can...

There are certainly huge potentials for abuse with this technology, but there are also some interesting positive, proactive things we can do.

My point is that there are opportunities here for...

Eric M Russell (1/14/2016)

---

... The NFL is also starting to use sensors to track their players, but with different goals. They are monitoring workloads, trying to ensure the health and...

I prefer super foods like chips, guacamole, and margaritas.

I feel amazing after those.

Grumpy DBA (1/14/2016)

---

Another death, actor Alan Rickman (of Professor Snape and Die Hard fame) died at the age of 69 - oddly the same age as David Bowie. This...

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