I would say I agree with 45%-50% of what is in this article.

For example, I wouldn't create scripts that use the fully qualified object name i.e. database.owner.object because that means...

I work with a variety of web CMSs and one of the things they share in common is a config file that allows me to switch their own internal logging...

I have got to ask what "Quand on parle du loup, on en voit la queue " means.

My French was limited to asking for bread and milk so I seem...

I seem to remember a configuration setting that sets the maximum query cost.

I'm at home at the moment so don't have access to BOL or a server to tell you...

I'm a self taught Visual C++ programmer.

I have never managed to get any of the example xp sources to compile and I believe it is down to the configuration of...

There is the job title on you contract of employment and the job title you use on your CV  I could argue that my...

I have a friend whose boss had three teenage daughters.

The stories the boss told about their antics traumatised my friend to the state that when the midwife said "it's a...

As Steve says, titles are just handy lables to hang on people however to my way of thinking there is a difference between a role that is described as analyst...

Do you get the programs that have 15 minutes of content but are 1 hour long?

I saw one on engineering disasters with a 125mph train crash in Germany and it...

Table variables are held in memory and therefore are very fast.  Implicit in this is that they are fairly small tables, otherwise the memory penalty would be detrimental to server...

Your paragraph table needs a revision number to keep track of the instances of the paragraph.

Revision zero is the original.

I would recommend that you have

• Creation date
• Last updated date
• Creating user
• Last updating...

sp_msforeachdb is an undocumented stored procedure.

By all means use it but there are no guarantees it will persist into future versions of SQL.

DBID 1 - 4 are explicitly system tables...

A PET!!!!

With the built in cassette means that it won't have a proper keyboard.  There was also a POKE command that allowed the processor clock to be adjusted.  The problem...

SELECT name FROM master.dbo.sysdatabases WHERE dbid>6 AND Name<>'distribution'

1 - 4 are the true system database

5 - 6 are pubs and northwind

distribution depends on when replication was set up on your...

Nice article.

In all the articles that mention planning storage space I have never yet seen one that mentions archiving and removing obsolete data to conserve space.

From my own experience I...