What makes it a very hot table is when a user enters editing, the code inserts into this table a clone of the rows to fall back to if the...

Have you examined the execution plan(s) used by this stored procedure?
You mentioned that the table is "hot", which I assume you mean it's getting a large volume of...

If your goal is certification, then use the Microsoft test prep kit book, because you can be an expert at many aspects of SQL Server (ie: internals or administration) and...

By default, I add an identity column to a table and then a clustered index on top of that. I don't recall ever choosing to model a heap table. Having...

Depending on the data access pattern, other database platforms like Azure Document DB, Azure Table storage, or Azure Key Vault are better optimized for entity-attribute-value or JSON/XML document implementations. When...

While on the topic of ISV databases with incomprehensible data models, PeopleSoft comes to mind.

We can also question whether schema-less XML and JSON documents (or BLOBs, or images, or free text) belong in SQL Server in the first place. The user community has already...

Well, it's stupid to publish a dataset without knowing the meaning of what all columns or attributes are included. I'd expect better forethought from a healthcare organization knowing that the...

Documenting a legacy database is what I call "database cartography". Sometimes it's just built in a piecemeal fashion over time based on exploration and local folklore passed down from gray...

Database modeling tools can be expensive, complicated, and despite all their bells and whistles, are ultimately rigid. There have been situations where I have questioned why a database was designed...

So, it's one thing to talk about data privacy in terms of how it impacts the lives regular folks in "flyover country". Ask any politician and they'll acknowledge it's an...