John Mitchell-245523 (9/12/2016)

---

No, backups don't take any locks on tables. There'll be a small IO penalty, but I'd be surprised if you even notice that. The frequency of...

IF the logs are getting bigger you have more, or longer running, transactions. Log backups can only remove from the log those transactions that are complete. If you have a...

It was a good event. I especially enjoyed how Mark took advantage of the space and created little mini-cons for people in small rooms that wouldn't otherwise get used. I...

Today is SQLSaturday Cambridge. Gianluca is here if anyone wants to say hello. Not sure which other Threadizens. Assuming we all don't get eaten by a Grue.

GilaMonster (9/9/2016)

---

Grant Fritchey (9/9/2016)

---

BrainDonor (9/9/2016)

---

I've been following that thread since it started - fascinating. I'll give him full marks for determination ("Tis but a scratch" type of determination), but I'm...

BrainDonor (9/9/2016)

---

I've been following that thread since it started - fascinating. I'll give him full marks for determination ("Tis but a scratch" type of determination), but I'm so glad I'm...

SQLRNNR (9/8/2016)

---

Grant Fritchey (9/8/2016)

---

djj (9/8/2016)

---

rodjkidd (9/8/2016)

---

SQLRNNR (9/7/2016)

---

It...

Yeah, actually, you can add a WHERE clause to the filter so that you add that value for the comparison. The version I checked this on is 11.6.

I don't know a free tool that does this.

Redgate SQL Data Compare[/url] will do exactly what you need.

If this is SQL Server 2012 or better (that's the forum you're posting in), why are you using sys.processes and DBCC INPUT BUFFER instead of the Dynamic Management Views (DMV)...

GilaMonster (9/8/2016)

---

djj (9/8/2016)

---

rodjkidd (9/8/2016)

---

SQLRNNR (9/7/2016)

---

It really is...

djj (9/8/2016)

---

rodjkidd (9/8/2016)

---

SQLRNNR (9/7/2016)

---

It really is a...

To get the best help, making it so we don't have to guess at stuff sure would help. And no, since there are multiple matching columns between the tables, the...

Celko or not, just adding an identity column to a table doesn't address the business logic. Do you have multiple rows with the same employee? There must be a logically...

Probably a difference in the login identifiers between the databases caused the login and the database user to become disconnected. Take a look at this article for how to resolve...