Viewing 15 posts - 721 through 735 (of 6,041 total)
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 5, 2018 at 7:50 am
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 5, 2018 at 7:33 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 4, 2018 at 12:17 pm
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 4, 2018 at 9:16 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 4, 2018 at 8:49 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 4, 2018 at 7:15 am
While on the topic of ISV databases with incomprehensible data models, PeopleSoft comes to mind.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 3, 2018 at 12:02 pm
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 3, 2018 at 11:59 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 3, 2018 at 9:05 am
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 30, 2018 at 12:14 pm
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 30, 2018 at 8:30 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 30, 2018 at 7:33 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 30, 2018 at 7:27 am
If it was really that easy it's hard to believe that there are...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 29, 2018 at 8:29 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 29, 2018 at 7:45 am
Viewing 15 posts - 721 through 735 (of 6,041 total)