JD Carlston (5/31/2011)

---

Have you found a resolution? We're running into the same problem.

SSIS runs properly, 100% complete. Stored procedure run through SSIS does not insert any...

I think the issue you have with Agile development is due to a lack of understanding of Agile practices, based on the statement "... allow and encourage the changing of...

Craig Farrell (3/31/2011)

---

Tom Bakerman (3/31/2011)

---

This seems like rehashing old news. I have vague memories from a database class I took in the 80s where we talked about an airlines...

This seems like rehashing old news. I have vague memories from a database class I took in the 80s where we talked about an airlines data center (AA or...

Clay Bowen (1/13/2011)

---

Is there a way to take these results and post them to a .csv without using powershell? We have been creating out comma delimited files using VB...

TheSQLGuru (1/12/2011)

---

1) don't put the clustered index on the table and the order by and then run the two versions. Virtually identical timing and resource usage on my mid-grade...

Got it. Thank you. For...

Wayne,

Can you provide more explanation on this part of the query:

TYPE).value('.','varchar(max)')

I have always used:

WITH CTE AS

(

SELECT DISTINCT

AccountNumber

FROM...

Nice article Jeff. You would think, that after all this time, some computer scientist somewhere would come up with a decent way to deal with strings. It seems...

I too find it rather odd calling these tools "low end". I think they are quite the opposite: High end tools that don't require you to know how to...

You bet. That's one of the reasons I moved to New Zealand.

What we do is generate a lot of sales metrics (sales, activity, and activity type, current count is around 650 when you consider the various timeframes, and there's dollars sold...

I would start by making sure all the proper indexes are present. (I ususally just run DTA on the select statement, and check the recommendations)

If all the indexes are there,...

It belongs to the VM.

I don't know if you looked at the activity monitor...

To answer your questions:

There didn't appear to be any blocking when I looked. The query in question selects from seven tables (combination of full and left joins), and inserts...