Issue an ALTER SEQUENCE statement with the change(s) you want to make.

If you're also looking into overall performance, don't neglect to specify both BUFFERCOUNT and MAXTRANSFERSIZE.

Most likely you've hit the "tipping point" for a table(s), where instead of using an index SQL reverts to a full table scan.

Rather than the full db size, we need...

I think it's worth a second here to go through why a SQL NOT IN with a NULL value in it causes no values to match.

SQL Rule 1) A WHERE...

Look at the history in msdb.  If it's lengthy, clean some of it out.  You would think SQL would use master to get the dbs in SSMS, but it also...

Let me know if this code looks good, and we can convert it into more dynamic code.  I didn't want to spend time doing that until I had the core...

Heh... guess I'm more ancient.  I've not found much that will actually beat BCP for performance...

Could you please post directly usable data, i.e. CREATE TABLE and INSERT statements for the example table data.

You also might have a NULL value for po_num in preqitem.  That would prevent the NOT IN from yielding any results, so add a NOT NULL check.  Or, perhaps even...

Are you exporting the data to load into a different SQL Server instance?  If so, then you should "native" format on the output.  That will save a lot of time...

What we ultimately ended up doing was creating a separate db to store user tables in.  A view and/or a synonym can be used in other dbs to allow the...

I would expect that behavior honestly.  I don't see how SQL could realistically maintain a potentially almost unlimited number of intermediate row counts for different snapshot points for every table...

Expect to have to do lots of tweaking to the code to handle all the things that come up, though.

NULL / NOT NULL for each column (which should...

Expect to have to do lots of tweaking to the code to handle all the things that come up, though.

NULL / NOT NULL for each column (which should always be...

A proc is possible, but most people don't code an actual CREATE TABLE statement, they use the gui.  They would have to pass in a block of SQL, which means...