Set MIN and MAX memory to the desired number

😎

EXEC sys.sp_configure N'show advanced options', N'1' RECONFIGURE WITH OVERRIDE

GO

EXEC sys.sp_configure N'min server memory (MB)', N'4096000'

GO

EXEC sys.sp_configure N'max server memory (MB)', N'4096000'

GO

RECONFIGURE...

If you open the package (dtsx) file in a text editor, does the XML look OK?

😎

I do have plans for implementation but still kind of struggling how to fit this into the architecture. There are certain benefits but the question is more how to fit...

I'll dig into it and let you know. Certain I have something and probably there are others that have similar, lets hope they share:-P

😎

SQLCurious (4/28/2014)

---

Thanks for all your inputs and suggestions. I will work towards implementing this in SSIS which seems to have better control. I appreciate everyone's time and effort in providing...

Take a look at Industry-specific Data Models from Database Answers[/url]

😎

When was the last restart? Have all procs executed since then?

😎

Please don't cross-post!

SSMS is neither the appropriate nor the intended interface for such restrictions.

😎

Jeff Moden (4/27/2014)

---

Eirikur Eiriksson (4/8/2014)

---

hisakimatama (4/8/2014)

---

Aha, so it doesn't :-). I've always declared CTEs with the column declarations, and by the wonderful problems of habit, it stuck as "the"...

Check out this post

😎

LutzM (4/27/2014)

---

There are several options to avoid the "reload":

The easiest is to transfer the file to a different folder once it is processed.

Another option would be to store the last...

Duplicate post, already answered here.

😎

The DATEDIFF function is your friend here

😎

SELECT

isLocked

,LastLockoutDate

,currentDte

,DATEDIFF(MINUTE,LastLockoutDate,currentDte) AS DIFF_MINUTE

FROM @tAccount

Result

isLocked LastLockoutDate ...

Ooops:ermm: sorry about that

and thanks Luis!

😎