Nice alternative Eugene, I like it!

I'm certain there's better ways to do this but I'd recommend creating a function that can be called as needed - this may help:CREATE FUNCTION [dbo].[fx_SplitColumnText](

@String varchar(50),

@Delimiter varchar(5),

@Side int

) RETURNS...

Some links:

http://www.sqlservercentral.com/Forums/Topic1220236-1550-1.aspx

http://thefirstsql.com/2012/05/29/updated-create-point-in-time-restore-script-automatically/

http://technet.microsoft.com/en-us/library/ms179451.aspx

http://www.techrepublic.com/blog/the-enterprise-cloud/restore-your-sql-server-database-using-transaction-logs/

There could be a lot going on...If WRITELOG is your top metric here, I'd have to ask if all your log files from these busy DBs are all writing to...

I'd create a little scalar function, should work like a charm:

CREATE FUNCTION [dbo].[fx_RemoveCharsFromString] (

@String nvarchar(max),

@Match varchar(255)

)

/*

----------------------------------------------------------------------------------------------------------------

Purpose: Removes unwanted...

brianpaulflynn (2/11/2014)

---

Michael Valentine Jones,

Does SQL Diagnostic Manager allow you to continue browsing data collected from a server you no longer monitor?

Does anyone know if other DB monitoring products that...

Please post the TSQL for the jobs steps, as HanShi has mentioned, it could very well be related to an "external" process like xp_cmdshell, an executeable, etc.

Note: I threw that code together as a quick example only and most like will need tweaking so I don't advise running it "as-is" without verifying it beforehand

Based upon your answers to Jeff's (excellent) questions, your first option sounds sufficient: Rename the table and move 1 month of data into the production table. Once complete. ...

You could merge Lowell's and Luis' suggestions together: use the OPENROWSET to bring everything into a temporary "staging" table, then select out the column names you want (in the...

Of course, you make valid points - 😉 I originally suggested SSIS, but provided a TSQL alternative - not pretty, but there it is...

@SQLRNNR - I agree with you 100% - I didn't say it wouldn't - I was saying it would not force new execution plans to be created.

I was answering the...

To clarify, are the columns the same, just in a different order daily? ie. (Fname, DOB, City, State, ZIP) and then possible (State, Zip, Fname, City, DOB) the next? ...

Shrinking a database wouldn't cause the creation of any new execution plans.

Yes, this will cause your log file(s) to fill/grow (especially so with the index maintenance)

If space isn't...

Eugene, you are quite right and I completely forgot about that. In this case, the OP should just create a physical table and select the results from that (then...