Excellent

If you pulled the data directly into a data reader and then processed that down on the client, is that faster?

ccd3000 (12/10/2015)

---

I think we're alchemists (most of us anyway) in terms of where we are in the profession's evolutionary development. Others in this thread have astutely pointed out that we...

cjb110 (12/10/2015)

---

Yes we are, and are we striving to reach the same standards as physical engineering, yes I think most of us are.

I think that article was a disservice to...

Manic Star (12/10/2015)

---

We're janitors.

We clean up the place, take out the trash and keep the mechanism humming along with regular maintenance that no one sees, appreciates or cares about...

If you aren't storing dates, be careful here. I would bet you get a bug at some point when a shift or a schedule goes over 24 hours. I've worked...

Make sure no proxy is set and ensure that the job itself has the account correctly chosen. There are various ways to change this, and configure different accounts for a...

SQLBits is going to be iffy for me. I need to be back here on Sun, May 8, so I may have to check if I can speak on Friday...

Ah, good one Luis. I realize I misread this as first. You want to parse out related rows.

I think Luis' solution will work, but only if your rules are for...

You are asking too much of Server Core.

If you're remote, and you need client tools in a GUI, then you should have a remote machine that you connect to, which...

I'm guessing the end set is what you want? Find the max date for each id

SELECT Id

, MAX(te.Date1) AS 'Resubmitted On'

FROM #TEmp AS te

GROUP BY id

Then you can put...

I agree with Sergiy. XML makes this easy.

As a hint, you can use the idea of joining a column to itself.

select '' + mycol

from mytable

If you have the tsqlt...

Tavis Reddick (12/9/2015)

---

Could there be a tendency, over time and in a successful devops team, for individuals to learn new skills from the 'other' side, to the detriment of learning...

Michael L John (12/3/2015)

---

DevOps is what's implemented to break down the communication barriers and silos that were created when Agile was implemented.

To me, it's only a new name for...

IIRC, Amazon uses messaging between systems, so the high volumes of orders get queued and processed into a relational system. It's usually seconds, but the queue allows for delays.