Model

I don't use Powershell, so this was a complete guess for me.

Perfect

SQLRNNR (3/26/2015)

---

sipas (3/26/2015)

---

It usually makes them think 'if...

Nice job on the testing. Thanks. I half-expected a slew of other approaches to come from the OP. 😛

Anger

I know this is just test data, but take a look at the query plans for all of them.

LittleDuck (3/26/2015)

---

Right I'm pulling blank today.

Number | Letter

1 A

1 B

2 ...

Stewart "Arturius" Campbell (3/26/2015)

---

Ed Wagner (3/26/2015)

---

I find that people ask for things not really knowing what they want until they see that what they asked for isn't what they wanted....

You may very well have an external source that's configured to take database backups.

I had a situation once where the network operations team had Backup Exec running SQL Server backups....

Lowell (3/25/2015)

---

Glad it helped you Rick!

with 20K+ hits on this thread, it's clear that it's probably helped more than just the folks who were kind enough to post a thank...

I find that depth comes with the variations of a particular technique. I really enjoy doing a deep dive on a topic, but that specialization tends to keep the...

Star Wars

Xavon (3/26/2015)

---

Ed Wagner (3/26/2015)

---

Yeah, it's a poor question with a wrong answer. Granted, someone will always misinterpret the question, but doesn't this mimic real life? I get requests...

Yeah, it's a poor question with a wrong answer. Granted, someone will always misinterpret the question, but doesn't this mimic real life? I get requests all the time...