It might help to create VIEWs on old tables, with the column names for the new tables. Then you can

INSERT INTO NewTable

SELECT NewColumn1, NewColumn2, ...

FROM NewViewOnOldTable

If the mapping is...

Don't think DATEFROMPARTS() was available in SQL 2008? but for later versions I would use

DECLARE @StartDate DATE = '01/01/15';

SELECT DATEFROMPARTS(YEAR(@StartDate)-1, 11, 6);

which avoids all the ambiguity of "nn/nn/nn" style string...

I've mentioned before, but my view is that more modern forum software is required - not just for SPAM but many things that would bring benefit to regular posters and...

Ah, OK. So for example a Month End routine is done in the APP and the backup needs to be at that exact moment in time.

This is a bit of...

Interesting point, and I can see how reducing data volume would improve performance.

For us, we concentrate on only transferring rows that have changed. Network transmission time is our slowest component...

Why do you need to prevent changes during the backup? The backup will be transactionally complete, regardless of whether there are changes made during the backup, or not.

If you...

Jayanth_Kurup (10/25/2015)

---

not sure if the flexibility afforded by bringing in columns that one day might be useful offsets the storage and performance overhead of all the rows and columns that...

Jayanth_Kurup (10/25/2015)

---

In our case we only transfer new-since-last-time data. This...

I CUT my reply, press BACK, press QUOTE and then PASTE my reply into that box.

I press the [+] at the right end of the "Last 10 Posts In Descending...

We do have Source Control, but each SProc / Trigger / View is in a separate file, so perhaps similar to your "Attached to tickets or on a fileshare"

We have...

I found this article interesting, it shows some stats for how data breaches were much larger than originally estimated / reported

http://qz.com/517649/never-trust-the-first-number-announced-in-a-data-breach/[/url]

I would only re-create a clustered index if there isn't one already - any existing clustered index...

update hourly

set date_time= try_parse(date_time_txt as datetime2)

-- WHERE NullIf(date_time_txt, '') IS...

Pah!

We have Archive tables on almost every table in...

Lynn Pettis (10/19/2015)

---

If deleting 90% of a table, SELECT * INTO to create a temporary table of data to retain, build the appropriate indexes on the temporary table, truncate the...