There is no one answer, it is horses for courses.

We deploy a solution at client sites and typically have 4 environments:

1) Virtual server with sampling of data. This environment...

One technique that can be used is to keep all the surrogate keys in a separate fact extension table with the fact id. Hence you are either updating a very...

When you use exec(@cmd), you are running a different session and the scope of the variable @var is the current session only. It will always return NULL.

What are you trying...

We use

• Perforce for version control
• PowerDesigner for table creation and maintenance. Both the PowerDesigner file and the generated SQL file (create statements) are checked in Perforce
• RedGate SQL Compare to detect the...