Luis Cazares (7/20/2016)

---

Y.B. (7/20/2016)

---

I got a PM from an OP saying simply 'douche bag'. LOL

Granted, I'm having a really bad day and could have responded better...on the other hand...

Beatrix Kiddo (7/20/2016)

---

cad.delworth (7/20/2016)

As a UK citizen, I always advise anyone considering using cloud storage to first ask themselves whether they're happy about US police, FBI, etc. all being able...

Without at least some details to work with, anything we offer (beyond "use a SELECT") would be pure speculation.

Jeff Moden (7/20/2016)

---

sql-lover (7/20/2016)

---

We need to change the cluster index definition on a table with 1 billion rows. This will be performed on SQL2016 Enterprise edition.

Initially , I wanted to...

ThomasRushton (7/20/2016)

---

jasona.work (7/19/2016)

---

Lynn Pettis (7/19/2016)

---

jasona.work (7/19/2016)

---

So this is almost funny...

I'm happily working away, when I feel my cell phone buzz. Now, typically, during the work day, this is an...

Eric has the all steps defined.

If you need help with concatenating the email addresses into a single string, check out Wayne Sheffield's article at http://www.sqlservercentral.com/articles/comma+separated+list/71700/. Just use the semicolon...

Now that's a powerful command I hadn't heard of before. Thanks for the opportunity to learn something new (and also cool) this morning.

Not having Enterprise Edition, there's little chance of me being able to use in-memory tables, but it's always good to learn something new. Thanks.

I've used them and must admit I was somewhat excited to see the question. Alas, nothing has changed.

Luis Cazares (7/18/2016)

---

Ed Wagner (7/18/2016)

---

HappyGeek (7/18/2016)

---

Ed Wagner (7/18/2016)

---

Revenant (7/18/2016)

---

crookj (7/18/2016)

---

whereisSQL? (7/18/2016)

---

djj (7/18/2016)

---

Revenant (7/15/2016)

---

Luis Cazares (7/15/2016)

---

HappyGeek (7/15/2016)

---

Gone...

Decision

SQL Express doesn't include the SQL agent, so it isn't a database job that takes you backups.

The Symantec Backup Exec software may be taking the backups according to its schedule....

Lack

There are several approaches to the problem. Here's the one I would pick:

SELECT personid

FROM dbo.TranscriptCourse

EXCEPT

SELECT personid

FROM dbo.TranscriptCourse

WHERE EndYear = 2013;

Bureaucracy