Even bog standard Visio Professional will reverse engineer. It is the enterprise architect edition that forward engineers.

You could look at Sparx Data Architect as a possible tool or Erwin.

In data warehousing solutions the recommendation (Ralph Kimball) is to have a single field surrogate key.

In OLTP solutions I think it depends on how static the data is.

In my case...

As a matter of interest why do you allow the tblUsers table to have NULL values.

Why not put a DEFAULT constraint with an empty string on them. It would...

The last books I bought were Klaus Aschenbrenner's Pro SQL Server 2005 Service Broker and the MCTIP training courses for SQL2008.

The problem is that books are relatively expensive door stops...

:connect $(Maindbserver) -U YourUserName -P YourPassword

Personally I would avoid SQL standard...

Back in the early 1990s I got made redundant on my birthday. Of course they waited until after lunch when I had bought the cakes that employees are supposed...

In addition to the above I would look at putting the tables on separate file groups and possibly separating out the indexes from the data.

Thanks Jonathan, much appreciated.

If you have a contact table and the contact is "The company secretary" then you are trying to contact a title rather than a person...

To be honest I am shocked to hear that people don't verify their backups.

I'm also surprised that it isn't the default action for a backup and requires a DBA to...

Some of the stored procs that my company uses to detect problems with application performance are actually the main cause of the performance problems.

The data management views are quite good...

ISO5218 has the following definitions for Gender

0 = Not Known

1 = Male

2 = Female

9 = Not applicable

If you have the freedom to choose the encoding then start with the ISO...

I work for a calculated risk taker who is VERY good at calcuating.

I think it depends on what the boss was before he was a boss.

I've found accountants uniformly awful...

Bert (2/13/2009)

---

David.Poole (2/12/2009)

---

I regard God as an external manifestation of the human desire to aspire to be better than we are.

As long as there is a worthwhile target that is...

As far as BI and global warning is concerned I would say that it tells us that there is a lot of money to be made out of climate change.

There...