Stefan Krzywicki (7/19/2013)

---

jasona.work (7/19/2013)

---

Stefan Krzywicki (7/19/2013)

---

Brandie Tarvin (7/19/2013)

---

Stefan Krzywicki (7/19/2013)

---

Grant Fritchey (7/19/2013)

---

Sean Lange (7/19/2013)

---

We have from time to time started heading in a bad direction. The good news is that...

Stefan Krzywicki (7/19/2013)

---

Brandie Tarvin (7/19/2013)

---

Stefan Krzywicki (7/19/2013)

---

Grant Fritchey (7/19/2013)

---

Sean Lange (7/19/2013)

---

We have from time to time started heading in a bad direction. The good news is that there always seems...

The general suggestion for autogrowth seems to be, don't. Ideally, either you set your DBs size large enough to encompass all reasonable possible data growth, or you monitor your...

OK, thanks!

I've been watching the Extended Events, but knowing they may not catch everything, I was hoping for a second method (without the trace flag)

Knowing XEs don't stay forever (seeing...

opc.three (7/12/2013)

---

All Database Users will at minimum be a member of the public Role. This affords them basic permissions like connecting to the database. Now, you can grant or deny...

After reading the "I hate software" posts just now, I have an urge to start a new topic...

Post the most twisted, warped, bizzarre, yet functional SQL code you can...

Whether it's...

Sean Lange (7/12/2013)

---

wolfkillj (7/12/2013)

---

Greg Edwards-268690 (7/12/2013)

---

Sean Lange (7/12/2013)

---

Steve Jones - SSC Editor (7/11/2013)

---

I renewed my passport last year. There still was expedited service, but I didn't choose it. Got mine...

Well, having found these two posts, and seeing as several of the events being traced are login events which are apparently not implemented in XEs, I guess I won't be...

Detroit Red Wings!

Toronto Maple...

Working with CommVault backups here, names like that seem to be "virtual devices" created just for the backup to go to. It's not a "file" or "folder" as such,...

OK, quick tested this on a QA copy of the DB in question, and if the role membership is NULL, you can connect to SQL (expected) but you can't query...

WHAT HAPPENED TO THE FORUMS?

I go away for a couple hours and everything gets moved around! I *LIKED* the furniture where it was, my chair was in just the...

A bigger issue to making a SQL Server a DC is the permissions that get set. I once (accidently) started to promote a SQL Server to be a DC...

That's what I thought. I figured setting it to offline for the restore would prevent connections, having seen several postings here from people trying to do maintenance in single-user...

You wouldn't...