17187 means that SQL Server cannot accept anymore client connections. There was a fix in SP2 as SQL Server was sometimes overzealous in issuing this command.

18456 is a "login...

Because of my auditing needs I have a structure that is something like the following

UserID

VersionNumber

UserName

... additional fields to identify who did what and when.

The primary key is across the first...

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...