lsalih (7/18/2016)

---

Michael -

I could place it in single mode too, but I prefer to kill sessions than placing the database in single mode because I once had a hard tome...

What services are you trying to stop? is it your application? You probably do not need to do that.

Just prior to the restore command, use this command:

USE master;

ALTER DATABASE DatabaseName...

Ed Wagner (7/15/2016)

---

Grumpy DBA (7/15/2016)

---

Michael L John (7/15/2016)

---

Well, I decided that I should probably take a look at the generator in garage. We had some serious storms last night,...

Grumpy DBA (7/15/2016)

---

Michael L John (7/15/2016)

---

Well, I decided that I should probably take a look at the generator in garage. We had some serious storms last night, I wanted...

Well, I decided that I should probably take a look at the generator in garage. We had some serious storms last night, I wanted to be prepared.

I ...

My question is why? What are you looking for with maxdop?

In addition to looking at max degree of parallelism, you should also look at "cost threshold for...

Ed Wagner (7/11/2016)

---

Michael L John (7/11/2016)

---

Ed Wagner (7/11/2016)

---

Michael L John (7/11/2016)

---

djj (7/11/2016)

---

jasona.work (7/11/2016)

---

Michael L John (7/11/2016)

---

jasona.work (7/11/2016)

---

Ed Wagner (7/11/2016)

---

Yeah, we've looked at a whole-house generator, right...

Ed Wagner (7/11/2016)

---

Michael L John (7/11/2016)

---

djj (7/11/2016)

---

jasona.work (7/11/2016)

---

Michael L John (7/11/2016)

---

jasona.work (7/11/2016)

---

Ed Wagner (7/11/2016)

---

Yeah, we've looked at a whole-house generator, right now it's just not in...

djj (7/11/2016)

---

jasona.work (7/11/2016)

---

Michael L John (7/11/2016)

---

jasona.work (7/11/2016)

---

Ed Wagner (7/11/2016)

---

Yeah, we've looked at a whole-house generator, right now it's just not in the budget. Considering we'd...

jasona.work (7/11/2016)

---

Ed Wagner (7/11/2016)

---

jasona.work (7/11/2016)

---

Boy what a weekend...

Friday evening we had a storm blow through, my birdfeeders in the back yard were just about horizontal from the wind (they were...

I consider database design and tuning to be an art, not a science. As such, creating software to do these things would be rather difficult.

I wish it was...

jasona.work (7/6/2016)

---

/rant on

After yesterdays announcement by Dir. Comey of the FBI, I am so freakin' fed up with the political BS here in the States...

Yet I still torture myself by...

Absolutely nothing is wrong. The join is doing exactly what you are telling it to do.

Please take a look at the link in mine, and Drew's signature that describes...

You are not doing anything wrong, based upon the information you have provided.

If you can supply some sample data, table structures, and the desired output, we may be able...

Completely off topic, but what is the reasoning for not allowing an underscore in the name for DNS?