How so? You've set it to use max 100GB, and it's using 24GB. You need to find out what's using the other 100GB.

John

Edit - although you've changed your...

Have you checked which processes are using that memory?

John

Message boxes are fine when you're running the package interactively, but what if you forget to take them out and then wonder why the package fails when you schedule it?...

Do you have any other applications or SQL Server instances running on the same server? What is the value of max server memory?

John

Yes indeed - date, time, datetime, datetime2 (and possibly others). These are the "proper" data...

Thanks Steve. Glad you got it all sorted. I was actually responding to Ben's point. Sorry, I should have made that clear.

John

You're confusing dates with date formats. Since this is a SQL Server forum, let's talk about SQL Server, which stores dates internally as a number (two numbers, maybe -...

You want this to be false, I think, so that should be your expression:

[font="Courier New"]@Counter1 != @Counter2 && @Counter3 <= 3[/font]

John

Calculate the actual date something like this

SELECT DATEADD(day,[Date],'20040701') AS ActualDate

FROM MyTable

John

Yes, or if this is part of an ETL process, consider copying the rows you want to keep to a new table, dropping the old table, and renaming the new...

Insert into Track (RunDate,Dbname,file_Size_MB)

select

getdate() as RunDate,

DB_NAME() AS DbName,

sum(size)/128.0 AS File_Size_MB

from AdventureWorks.sys.database_files

John

First, is there any blocking going on? Second, have you looked at the execution plan to see what the pain points in the query are? If you have...

Goodness! If the IT department isn't fulfilling one of its most important roles by taking backups, then that needs escalating to the very top, doesn't it?

John

Yes, or just do the conversion after calculating the minimum:

CONVERT(varchar(17),MIN(a.orderdue),103)

This has the added advantage that it only has to do the conversion once (on the minimum date) instead of on...

What version of BIDS/SSDT are you using? Make sure you're at the top level of the package (ie not in a data flow) and then look in the menu....