Stogie_Maru (4/8/2011)

---

What?!? :crazy: Couldn't disagree more... must be something with the setup at your organization.

I'm seeing great speed and great "compression" (for lack of...

UMG Developer (4/8/2011)

---

If your databases are in the FULL recovery mode, and you have done at least one full backup, your log files would grow and grow and grow until...

DNA_DBA (3/26/2011)

---

Schemas can't have a separate data file but object in the schema can be put on different filegroups which in turn can be put on different drives.

If you've checked...

OOOOOOPS!

Typing too fast and didn't realize the declared variables should be 'INT' not 'VARCHAR'. No wonder the data was all NULL. 🙂

Changed that and it still ran twice...

DECLARE @CompDtvarchar(2),

@CompDtm1varchar(2),

@CompDtm2varchar(2),

@CompDtm3varchar(2),

@CompDtm4varchar(2)

SET@CompDt = DATEPART(yy, GETDATE())

SET@CompDtm1 = DATEPART(yy, DATEADD(yy,-1,GETDATE()))

SET@CompDtm2 = DATEPART(yy, DATEADD(yy,-2,GETDATE()))

SET@CompDtm3 = DATEPART(yy, DATEADD(yy,-3,GETDATE()))

SET@CompDtm4 = DATEPART(yy, DATEADD(yy,-4,GETDATE()))

SELECT (SELECT CONVERT(varchar(10), MAX(ACCOUNTING_DATE), 101) AS Expr1

FROM DB1.dbo.Table2

WHERE ACCOUNTING_DATE <= GETDATE()) AS AsOfDate,

RTRIM(a.column2)...

I don't want...

@pam

I agree, that dropped the processing time in half. Thanks for the suggestion. 😀

Yeah, this was a takeover.

Yeah, the crazy thing is that it is both domain admin and is explicitly added to the share. 🙁

Not exactly familiar with usage on the Join() function. I know I would put it in the 'Parameter...

Ah, I see now. Thank you!

Thank you, I will give it a try. I still need to use SSIS because this is only one step in a pretty large process. But I appreciate...

I figured out that it was hanging at the validation phase because I had the entire package set as 'Required' and Serializable. I changed it to 'Supported' and only...

Oh I see. You can't use DATEPART...

Yes, the order of the scripts is the order of execution. I...