Deadlocks typically occur when you have two processes accessing data in different orders. It could be UPDATEs, but SELECTs could cause issues at times.

However if you have different users accessing...

What's the specific message or problem? Ken might be on the right track here.

That's what a user asked for.

I think that there shouldn't be any difference between a PK and unique index, whether CI or NCI, but perhaps there's some misunderstanding out there....

Miles Neale (2/20/2015)

---

You gather information, get advice from those you see as wise, evaluate your skills, talents, and interests and set sail for the "island of your dreams". ...

I'd use SQLCMD and run a .SQL file against multiple databases/instances.

I like out of SQL Server processes for this, because I want to deploy easily, or push out, without being...

We're gonna be crossing....

I think the pace needs work. I understand it can cause issues, but I tell you from a player's standpoint, I hate slow pitches, and from a fan's standpoint, it...

The DBA Team

Alvin Ramard (2/19/2015)

---

This editorial came on an interesting day.

A few hours ago I decided I need to get my hand on a cheaper option to Erwin or DB Artisan. ...

Linked at the bottom in the challenge.

I'll make it more prominent.

Jeff Moden (2/19/2015)

---

Case in point is the number of DBAs that I've interviewed in the last 3 years that didn't know how to do a native backup/restore or how to...

chris 31337 (2/19/2015)

---

I've recently come around to this way of thinking myself and bought Sublime Text & Sublimerge, which I use as a general swiss army knife for general scripting...

Gary Varga (2/19/2015)

---

Given that I have learnt to avoid using third party tools wherever possible and stick to what the majority of my clients use. This means that I don't...

Clive Strong (2/19/2015)

---

I've only ever used this once. We had a client who wanted to move from our hosted platform to their own infrastructure. Rather than wait on...

iposner (2/19/2015)

---

For IO constrained environments, striped backups come into their own when the backups are compressed: Since the compression process is inevitably single-threaded, increasing the number of striped backup files...