Don't get too hung up on the "narrow" aspect of what makes a good index key. Instead of "narrow" think "as narrow as practical." Then, suddenly, your key structure is...

You're getting an RID lookup because the nonclustered index isn't covering and you don't have a clustered index. The BMK that you're referencing is the storage location within the heap...

And rereading, You just won't be able to treat the MDF file the way you treated Access files through the Jet engine. It's utterly different. SQL Server is a service...

You can't "Open" an MDF file. You absolutely need to do the ATTACH process. But, instead of fighting with the GUI, let's go to the file.

I'm assuming that the original...

Sounds likely.

Just so you know, the causality tracking adds an additional value to the events. If any set of events are linked, they'll all have the same value, so you...

Joy Smith San (5/5/2015)

Snapshot of the disks is being done by respective team I believe.

So are you saying, we don't need database backups from sql server instance if the...

When in doubt, refer back to this book by Denny Cherry. Here's an article talking about it too. Read #7. With an AD account, you can set the minimum possible...

You don't need this:

ALTER DATABASE MyDatabase

SET ALLOW_SNAPSHOT_ISOLATION ON

That's a different kind of snapshot isolation that is controlled by each connection and transaction. Read_Committed_Snapshot should be sufficient. You're probably best setting...

Not to my knowledge. But then, I haven't had to use it.

Nice attempt at your first blog post.

Unfortunately, there are a few questionable suggestions in there.

For example, what's the difference between these two queries:

SELECT * FROM Sales.SalesOrderHeader AS soh

LEFT JOIN Sales.SalesOrderDetail...

I'd set up an extended event session and include causality tracking. I'll bet this is part of some extended transaction and just evidencing the deadlock in a funny way.

The Repeatable Read isolation level is much more restrictive, holding locks until a transaction is committed so that others cannot modify data, so yeah, that's absolutely going to lead to...

That's weird. What's the isolation level on the connections do you know?

Sorry I don't have better info. This one looks really odd.

Nice job on the PR.

Yeah, those discrepancies can make you nuts. I usually don't even attempt to resolve them and just say "This one is different than that one" and keep going. Makes my...

Hey Jared!

I'm not sure. Are these statements part of a larger batch? Do you have triggers on the system? How about CDC or Audit? It seems like something other than...