I would never have them run their own BACKUP command.

You need to have them call a stored proc so that you can add/override all options necessary to the BACKUP; for...

For a very small number of immediate changes, it's ok. But close the window immediately after the changes. If you let it hang open, you might cause issues...

Not much to go on, but probably something like this:

SELECT ...

FROM (

SELECT

...,

...

OK, so:

datetime_column < DATEADD(YEAR, -2, DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), 0))

Just capture value of the RecordID that you just modified in the calling code, and pass it into the code to be dynamically executed:

@query = 'DECLARE @RecordID AS Varchar(12)

SET @RecordID...

In general, as below. But, if the column is not datetime, CAST the date calc to the exact datetime of the column. For example, if the column is...

dspink (7/15/2013)

---

Also any thoughts on this approach?

Select * INTO T1_Obfuscated FROM T1. (obfuscating only columns needed.) then dropping T1 and renaming T1_Obfuscated to T1. Not really too worried about space...

Sean Lange (7/15/2013)

---

Many of the things you listed as possibilities are likely to help but probably the biggest performance woe is calling the same scalar function 11 times for 250...

SELECT IP.IPCode, MAX(AllSubtables.UpdateDate) AS LastUpdateDate

FROM SAMPLE.IP IP

INNER JOIN (

SELECT IPCode, MAX(UpdateDate) AS UpdateDate FROM SAMPLE.IP IP2 GROUP BY IP2.IPCode

UNION ALL

SELECT IPCode, MAX(UpdateDate) AS UpdateDate FROM SAMPLE.AddressProfile AP GROUP BY AP.IPCode

UNION...

SELECT CASE WHEN Total_Rows = Active_Rows THEN 'Valid' ELSE 'Invalid' END AS Status

FROM (

SELECT

SUM(1) AS Total_Rows,

...

Welsh Corgi (6/24/2013)

---

Thanks for the help guys.

I'm using the Data calculation in the WHERE Clause.

WHERE Effective_Date < CONVERT(DATE, DateAdd(yy, - 5, GetDate()));

Does it matter which method I use as far...

Sean Pearce (7/11/2013)

---

ScottPletcher (7/11/2013)

---

Sean Pearce (7/11/2013)

---

Pot --> kettle --> black.

Excuse me for being defensive, but Microsoft products have been putting food on...

No problem. That's the most common fix,...

Sean Pearce (7/11/2013)

---

Pot --> kettle --> black.

Excuse me for being defensive, but Microsoft products have been putting food on my table since...

You could also just add a "GO" after the ALTER TABLE; that will put the SELECTs in a separate batch, by which table SQL should "know" they already exist, having...