Huh... Seems like this might have expanded into a more general VM issue than a SQL Server issue. I hammered out the procedure that was running too long;...

RTaylor2208 (10/9/2013)

---

Personally I would start by looking at the waits on the system and trying to identify if there is any particular wait type that is causing the problem, this...

On the low-salary front, I worked as a DBA/programmer for a pretty well-off company as my first real programming job. My wage was a grand $12 an hour, but...

As far as I know of, without building your query as a string and passing it to EXEC or (preferably) sp_executesql, this isn't possible, to the best of my knowledge....

Not a problem. I had the same problem when I was working with BCP initially; drove me batty for a bit until I realized the double quotes need to...

Unless I'm mistaken, you just need to escape the double-quotes in your BCP string; it should change from this:

DECLARE @cmd varchar(1000)

SET @cmd = 'bcp "SELECT ''blah"blah''" queryout "C:\bcpout.txt" -w -T'

EXEC...

Rawr! I did it! Worked a full 8 hours on the stupid query that made me quite grumpy yesterday, converting it into a much better SQL statement and...

SQLRNNR (9/26/2013)

---

hisakimatama (9/26/2013)

---

Aaaaaaargh... And now, I need to fume :-P.

Working with the company's vendor software, and one of the reports is coming across super-slow, about 10 minutes to retrieve...

Aaaaaaargh... And now, I need to fume :-P.

Working with the company's vendor software, and one of the reports is coming across super-slow, about 10 minutes to retrieve about 150...

Lynn Pettis (9/26/2013)

---

I know most Threadizens know I am currently deployed in Afghanistan as a civilian contractor.

I was notified this evening that my position state side has been cut as...

Lynn Pettis (9/26/2013)

---

hisakimatama (9/26/2013)

---

SQLRNNR (9/26/2013)

---

hisakimatama (9/20/2013)

---

*Huff* *Wheeze* I... I did it! I managed to read the entirety of The Thread! That was... Interesting :-D. ...

SQLRNNR (9/26/2013)

---

hisakimatama (9/20/2013)

---

*Huff* *Wheeze* I... I did it! I managed to read the entirety of The Thread! That was... Interesting :-D. Been lurking around...

Jeff Moden (9/26/2013)

---

Is that the one where...

This article should be handy:

DelimitedSplit8K[/url]

Create the DelimitedSplit8K function as detailed in the article, and CROSS APPLY it to your comma-delimited data, like so:

SELECT * FROM YourTable

CROSS APPLY YourDatabase.YourSchema.DelimitedSplit8K(YourTable.Lastname,',')

Replace the "Your"...

Taking a crack at this... Try this article:

Tally Tables[/url]

With a tally table, you could whip up something like this; note that my naming is a bit sketchy, because this...