Tom has a good summary here. If someone would like to tackle a short, simple, intro piece, we'd appreciate it.

I'll also say that I think my kids spend too much time in front of screens and it makes me crazy. But my son runs cross country, my daughter plays...

My three kids are older (13+ now), and so we've given up...

Very true. Late to respond, but my experience with my two younger kids is that they were much...

Thanks. Glad that you enjoyed it and got something.

You can also query the backup files and look at the LSNs to do some matching to determine what's the latest. Ultimately that's the best. This script might help you:...

I'd lean towards what Gail mentioned. If you need inserts to happen without affecting reads, then isolation is probably the best way. However this changes where resources are needed on...

GUIDs are very unlikely to collide, but there have been reports of this. It's not something to worry about in practice, but be aware.

These certainly are important for things...

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...