rodjkidd (8/27/2014)

---

One of the PM's near me is having a meting at his desk. Explaining something to another person. They are almost replying with umhum with metronomic precision. It's gone...

Please feel free

Indeed

David.Poole (8/18/2014)

---

K. Brian Kelley (8/15/2014)

---

I don't want my kids to go into IT.

While some work places are great, I see the following too often:

- Long hours are expected of IT...

crussell-931424 (8/25/2014)

---

What's the compelling reason to use a subset of data? If it is no big deal to copy a recent backup into a test area, why not just do...

We need a SQL Saturday in Boise! If you get...

Jeff Moden does a good job of showing performance comparisons

http://www.sqlservercentral.com/articles/T-SQL/63681/

The way you do this is to schedule full, then diffs, and then log backups. You take a full and restore it to the new instance. Once that is done,...

Jeff Moden (8/24/2014)

---

Steve Jones - SSC Editor (8/24/2014)

---

Please don't use all caps. It is equivalent to yelling. Also please don't cross post (removed the other one).

You don't want to do...

Side by side for me, but always make sure you take backups of all user databases, master, model, and msdb before you do either.

Added "functions" to the QotD, though I think you're being a bit pedantic, Tom.

You can't use a variable in the FROM clause.

However if this is for something like masking data on restores to dev/test, and isn't run often, you can use dynamic-SQL

declare @cmd...

Closing this thread.

Please post replies here: http://www.sqlservercentral.com/Forums/Topic1606742-3411-1.aspx

Please don't use all caps. It is equivalent to yelling. Also please don't cross post (removed the other one).

You don't want to do this in SQL Server. Use Windows at...

That's a...