Jeff Moden (11/2/2011)

---

I just got done with some testing of my theory that having temporal based and persisted calculated columns in the detail would help this problem. Sure, I...

elham_azizi_62 (11/2/2011)

---

hello all.

I work with sql server 2008 and windows server 2008.I configure target in odbc properties to %SystemRoot%\SysWOW64\odbcad32.exe and add microsoft visual foxpro driver in UserDSN and select...

Stefan Krzywicki (11/1/2011)

---

...If I use GetDate in the Execute SQL, it should give me the time I...

You're welcome Stefan. I'd be interested to hear what you come up with.

Stefan Krzywicki (10/31/2011)

---

ChrisM@Work (10/27/2011)

---

Stefan Krzywicki (10/27/2011)

---

ChrisM@Work (10/27/2011)

---

Look at LoggingMode on the properties tab of the package.

Right-click on the white space of a package, select Logging, select what you want...

Ugly but it works:

DROP TABLE #Sample

CREATE TABLE #Sample ([Line#] int, Level1 int, Level2 int, Level3 int, Level4 int, Goal CHAR(1))

INSERT INTO #Sample ([Line#], Level1, Level2, Level3, Level4, Goal)

SELECT 1, 102111,NULL,NULL,NULL,...

Jeff Moden (10/30/2011)

---

ChrisM@home (10/30/2011)

---

Here's a few preliminary results from queries posted so far, and another which I'm guessing is Jeff's preaggregate. The preaggregate works fastest but not by a fat...

There are a couple of things I want to confirm using your data.

Firstly, IIRC aggregating the columns separately then adding up the aggregates is quicker than aggregating the sum...

Kiara (10/28/2011)

---

ChrisM@Work (10/28/2011)

---

No worries Ki. There's an aspect of this which is interesting to me and I'll continue to work with it - at home, they wouldn't allow these volumes...

No worries Ki. There's an aspect of this which is interesting to me and I'll continue to work with it - at home, they wouldn't allow these volumes at work...

bass8117 (10/27/2011)

---

below is part of code that includes many subselects, sums, etc. here's the problem I have,

in the CHRG0.CHRG_AMT column I have a reverse charge of -289.00 with a CHRG0.CHRG_BAL...

Vishal Sinha (10/27/2011)

---

What can be done in situations like these where a few million records will be inserted in the table? I only want 1 record to be inserted in...

Stefan Krzywicki (10/27/2011)

---

ChrisM@Work (10/27/2011)

---

Look at LoggingMode on the properties tab of the package.

Right-click on the white space of a package, select Logging, select what you want to log.

During dev,...

Look at LoggingMode on the properties tab of the package.

Right-click on the white space of a package, select Logging, select what you want to log.

During dev, log just about...

What does the following query return?

SELECT count(*)

FROM TABLE1 AS CC

INNER JOIN TABLE2 AS M ON CC.FORMATTED_PHONE_ADDRESS = M.EMAIL_ADDRESS