Simple Talk is now part of the Redgate Community hub - find out why

Database Design: A Point in Time Architecture

In most relational database implementations. Update and Delete commands destroy the data that was there prior to their issue. However, some systems require that no information is ever physically deleted from or updated in the database. In this article, Arthur Fuller presents a solution to this requirement in the form of a Point-in-Time architecture: a database design which allows a user to recreate an image of the database as it existed at any previous point in time, without destroying the current image.… Read more

Dogs of War

0
0
In Canada, specifically the province of Ontario (where I live), and in the USA, specifically the state of Ohio, various dog-attacks have caused the respective legislatures of these places to enact laws specifically forbidding the ownership of Pit-Bulls. Clayton Ruby, Canada’s wanna-be equivalent of either Ralph Nader or William F. Kunstler, or perhaps both, is … Read more
0
0

Evaluation Software

0
0
Fuller’s Fifth Law: always bite the hand that feeds. In dutiful obeisance to my own laws, I have chosen  to vilify  the sponsor of  my blog,  Red Gate, whose evaluation software makes, in my opinion, a foolish mistake. Before I explain why, let me ask, How many hours did you work last week, and the … Read more
0
0

Intelligent Database Design Using Hash Keys

Your application may require an index based on a lengthy string, or even worse, a concatenation of two strings, or of a string and one or two integers. In a small table, you might not notice the impact. But suppose the table of interest contains 50 million rows? Then you will notice the impact both in terms of storage requirements and search performance.… Read more

How you log in to Simple Talk has changed

We now use Redgate ID (RGID). If you already have an RGID, we’ll try to match it to your account. If not, we’ll create one for you and connect it.

This won’t sign you up to anything or add you to any mailing lists. You can see our full privacy policy here.

Continue

Simple Talk now uses Redgate ID

If you already have a Redgate ID (RGID), sign in using your existing RGID credentials. If not, you can create one on the next screen.

This won’t sign you up to anything or add you to any mailing lists. You can see our full privacy policy here.

Continue