Advanced

PART 8: ESTIMATION

  • Article

Data modeling is no doubt one of the most important and challenging aspects of developing, maintaining, augmenting and integrating typical enterprise systems. More than 90% of functionality of enterprise systems is centered round creating, manipulating and querying data. It therefore stands to reason that individuals managing enterprise projects should leverage on data modeling to execute their projects successfully and deliver not only capable and cost effective but also maintainable and extendable systems

2006-01-09

2,421 reads

Accurate Numeric Identifiers: Using Verhoeff's Method for Check Digits

  • Article

Check digits–not to be confused with checksums–are often added to numeric identifiers such as customer and product numbers to reduce the chance of incorrect entries. Sequences of numbers are notoriously easy to mistype, and constraints alone generally won't do the job. In this excellent article, Lynn Fields shows you how to implement the "Cadillac" of check digit methods–the Verhoeff Dihedral Group.

2005-10-26

2,735 reads

VIEWS: The Key to Database Agility

  • Article

There is an important technique for creating truly agile databases that I haven’t seen in his writings; one which is well-known to DBAs, but little understood in the application development community – the use of database views to create a layer of abstraction between the normalized relational tables and the applications that use the data.

2005-10-21

3,736 reads

Understanding Object Ownership

  • Article

In SQL Server 2005, object ownership will have a different meaning, but since most of us work with SQL Server 2000, Kathi Kellenberger has written a good introduction to understanding how object ownership works and why you might want to follow certain practices.

5 (8)

2007-01-05 (first published: )

52,460 reads

A New Way of Thinking

  • Article

Every organization both maintains and uses reference data sets within its enterprise. And in many of these organizations, there are standards about the definition and use of that reference data, although sometimes those standards are at best silently understood instead of specifically documented. Yet even in the best governed environment, that reference data is bound to eventually be abused, either through value set perturbation or extended usage expectations.

2005-07-15

2,478 reads

MODELS, MODELS EVERYWHERE, NOR ANY TIME TO THINK

  • Article

Even a cursory inspection of data management practice reveals that the majority of practitioners-–be they novices, or experienced, users or vendors--operate in a “cookbook”, product-specific mode, without really knowing and understanding the fundamental concepts and principles underlying their field, e.g. what data means, what data model, database, DBMS, data independence really are, and so on.

2005-06-17

2,510 reads

Using ANSI SQL as a Conceptual Hierarchical Data Modeling

  • Article

This paper will explain and show how standard ANSI SQL processors can naturally model and automatically process complex multi-leg hierarchical data structures at a full conceptual hierarchical level. This also means the query user does not need to have structure knowledge of the hierarchical structures involved. The data modeling capability includes dynamically combining logical hierarchical relational and physical XML data structures at a full hierarchical level. This also includes the ability to link below the root of the lower level structure intuitively forming a valid unified hierarchical structure. As will be shown, ANSI SQL’s high level hierarchical data processing allows the flexible conceptual control of hierarchical node promotion, fragment processing, structure transformation, and variable structure creation.

2005-06-03

2,567 reads

Blogs

Database Fundamentals #27: Creating a Primary Key in the Table Designer

By

Defining primary keys is the hardest part of the operation. You will need to...

SQL Server principals – Server Roles

By

[MSSQLFUN & Decode ITeS becomes a family of 1700 individuals across the globe. Please...

Daily Coping 14 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

SPMail Not Working For All Users

By EsquireDeveloper

Hello~ I'm sure there's a very simple solution, but it seems to be eluding...

How to analyze massive OLTP databases

By Mysterio

I've just started a job and I'm responsible for administrating (will define later) a...

MDS multiple domain based attributes for one member

By DinoRS

Hi SSC, I wonder if I can select multiple domain based attributes for one...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The C in ACID

See possible answers