On x64 you do not need AWE enabled.

I believe you do want to set the Max Memory. Here is a post from this thread that mentions this:

EdVassie

Posted 3/5/2008 9:21...

Ben Sullins (5/23/2008)

---

jsheldon (5/23/2008)

---

To all last question and then I will let you enjoy the weekend.

RowNumber() can this SQL 2005 function be used on a database with 80 compatibility? ...

Well, if I were your corporate IT I would say you don't want to do it.

As far as answering your question, it would depend on what you really intend to...

jsheldon (5/23/2008)

---

Hi Jack,

Ok I am getting this thanks..one more question my script if I gloss over it states 'journal_line_nbr is not a member of 'ScriptComponent_....'

To answer your question, why...

Based on the following test both queries are evaluated the same and return the same and desired data:

[font="Courier New"]

CREATE TABLE #vwMyView (fldTimestamp DATETIME, location_id INT, removed_id INT)

CREATE INDEX IX_Test ON...

If you had this data, what would you want returned? Assuming all 3 dates are greater than or equal to your date criteria?

fldTimestamp ...

There are a couple of things I would do before killing a process.

1. Run sp_lock [spid] for each spid to see what is object(s) are causing the deadlock and...

So change it to use getdate() and if you really just want the date which by default will have a time of midnight you can do:

Declare @delete_date datetime

Set @delete_date =...

Sure you could but I would use SSIS instead. If it is a one-time event just right-click on the database in SSMS -> select All-Tasks -> Import Data and...

jsheldon (5/23/2008)

---

1. Do I need to create a blank column in Derived column task for the journal number? I think the answer is yes otherwise the script transformation...

Can you post some code? Include any triggers or any other code in the batch/transaction.

Why are you using varchar for your date value? When I have had to do something like this I usually get the max date in the table something like...

John,

SQL Server used to have ANSI_PADDING set to off, so when inserting 'a', 'a ', 'a ', etc... into varchar/nvarchar the trailing spaces were trimmed so all that was...

I was just going to go where Matt took you. To explain what Matt is saying, you should replace your Derived Column with a script component. If I...

I think you will need to create a package variable that you increment in order to do this as SSIS processes row by row not by the set. This...