Craig Farrell (2/15/2011)

---

I believe, if memory serves, there was an algorithm for using XML instead of the standard method for VARCHAR(MAX) that Jeff was going back and forth with someone...

Koen Verbeeck (2/15/2011)

---

Fal (2/15/2011)

---

WayneS (2/15/2011)

---

Can anyone point me to a delimited split function that works on a varchar(max)? I know that Jeff's DelimitedSplit8K works on up to a varchar(8000), and...

WayneS (2/15/2011)

---

Can anyone point me to a delimited split function that works on a varchar(max)? I know that Jeff's DelimitedSplit8K works on up to a varchar(8000), and I seem to...

Are you loading the CSV back into excel? Or are you viewing through notepad/wordpad? If you haven't put the CSV through, say, Notepad yet then do that and...

Sooo...let me see if I have this right: you have one table, that has a varchar column that stores "date" information. The values come from two inputs, one also...

Hi there,

Simple questions, but...are you sure it's not the first statement just taking 15 mins to execute? You are using a WHILE loop and iterative operations are notoriously slow....

Hi Sunil,

I'd suggest that Gail is otherwise busy right now, so give her some time to get back to you.

While you wait, you should start banging some heads together to...

Elliott W (5/12/2010)

---

So their reasoning is that internally they did a poor job implementing it and a poor job of source control. So we are blaming the technology.

An analogy...

CirquedeSQLeil (5/12/2010)

---

It is a knee jerk reaction and should be combatted with some examples of how SSIS is not crap.

Take some of the crap packages and rewrite them so they...

Thanks for your replies everyone.

The reasons are such: the company has, over time, accumulated a large set of poorly written DTSX packages that are causing no end of grief (ironically...

In case in the distant future archaeologists dig up this query and wonder as to the solution, this is what I found.

The @provstr also requires the UID and PWD elements....

As a guy who works at a company where mirroring is used, I'm...nervous...about what you are trying to achieve. There's a whole raft of issues to deal with, and...

This QotD raises a point I'm always having to remind developers about, and I guess SQL guys can also do with a reminder from time to time.

However, my 2 cents...

A thought provoking question, but I'm not too keen on the answer. Unless Paul would like to pay for my airfares???

S.

Gosh, I'm the FIRST person to answer this QotD!

Thanks for the questions Prakriti.

S.