Why don't you just directly perform the update ?

What's inside the function dbo.GetZoneBlockCount ?

Did you set the upper limit for SQLServer am to be used ?

sp_configure 'max server memory' --, 13500 show the current value

sp_configure 'max server memory', 13500

With a 16GB server I...

Keep in mind columns with the identity property are meant to generate their own value in a given sequence.

(check books online for seed and increment)

However - as replied by the...

I don't get the combination of your previous two replies :crazy:

As long as I have enough space, I don't care about it during any migration.

It may indeed consume your resources....

did you specify the proxy account for the job step ?

Did you play around with the Microsoft Migration Assistant for Oracle ( to sqlserver ) ?

Always nice to give it a try .... this is free MS software 🙂

Have a...

Here's an alternative using alerts ...

help to tighten use of cmdshell or sp_start_job[/url]

You could also set up a SSB solution for it.

You'll have to shink the current file(s) because, as you state, you didn't configure your luns big enough to host that size. ( Which is IMHO awkward )

Check you current...

Keep. In mind that only makes. Sense for tables having a clustering index and for non-clustering indexes.( reindex)

Did someone use two single quotes in stead of double quotes ?

It depends.

For tables that are designed to not being referred to by other tables, a PK may not make sence.

That is a design issue.

However, it is advised a table has...

Correct George.

This is the ref .. http://technet.microsoft.com/en-us/library/ms179301(SQL.90).aspx

It depends ....

http://blogs.technet.com/b/askperf/archive/2008/03/25/lock-pages-in-memory-do-you-really-need-it.aspx

Yes.

Order of processing is important with AWE.

First set your max server memory and only then enable AWE !

In your case (8GB total allocated VM ram) You would need /3GB /PAE...