|
|
Browse by Tags
All Tags » Development » Best Practices (RSS)
-
A bit of terminology that gets beaten to death is that of the “physical” database. I would think most every DBA uses this term (I do), but…to mean what? I think there are two common utilizations: The layer of tables, constraints, indexes, etc used to store data The actual on-disk structures. Frankly, until 3 years ago, I ...
-
A setting that I noticed a while back when looking at sys.configurations was disallow results from triggers. Triggers are one of my favorite subjects, and you will find a lot of good uses of them in my book (triggers are also well named, as poor usage of them will allow you to shoot your foot off in a heartbeat as I discussed in my earlier ...
-
During all phases of development, particularly when building a completely new system, it is very common to have a need for data to test with. As important as this is for a UI system, the need is doubled is when you are working on a reporting system. While Everyone knows that the process of getting test data can be a fickle ...
|
|
|
|