teareal_1 (11/25/2014)

---

Thanks for the responses! I tried setting it to not cache and made sure I was not using fast load, however, that did not change anything as far as...

Why not simply use EXECUTE WITH RESULT SETS?

Normally in query 1 the execution plan will do an index seek on the clustered index. Since it is unique, it will know to stop when it has found a...

Voted.

Nice and easy, thanks.

In that case they will most likely need to install BIDS/SSDT. Not 100% sure, it's possible SSIS has to...

Stewart "Arturius" Campbell (11/24/2014)

---

Thomas Abraham (11/24/2014)

---

Thanks for the question. Seemed easy enough, but was sufficiently challenging for a Monday.

Saw Koen's plug for his blog. Can we get him to rewrite...

psc032802 (11/24/2014)

---

What is the "machine in question"? The one the actual database is stored on?

If so, then SSIS needs to be installed on the database server and also on...

Sean Lange (11/24/2014)

---

It looks like you have a delimited string in a variable...

When you go to the execution results and...

OK.

Are all the rows sent to the error output?

TomThomson (11/24/2014)

---

It's one of those problems that we inevitablu have when writing specifications or requirements in natural languages, instead of using formal systems like Z or VDM; of course formal...

What happens when you try to load the data?

Steve Jones - SSC Editor (11/20/2014)

---

Good luck to Koen (I voted for you), but please don't game the system with multiple votes from something like InPrivate Browsing.

It's just a crappy...

Nice question. I have been bitten by the windowing functions defaults before, so this question was easy 😀

(I even wrote a blog post about it: Beware the defaults! (in windowing...