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

An old DELL 233 that I really must replace, but if it ain't broke...

An XBOX - must get it chipped soon.

Just given a friend my old Atari STFM1024.

My Yamaha CVP307...

Ah, Frank.  When you have three kids and your wife works nights the only chance you get to surf the internet is when the kids go to bed.  It is...

Is you production database a 24/7/365 item?

Are your production and test databases on separate boxes?

An approach I have taken in the past is to have a copy database with no...

I don't have BOL to hand as a write this but I am pretty sure that I read that table variables are not allowed in the latest version of BOL....

Contratulations Frank.

I've got three myself and it's amazing how three children from the same parents can be so different.

Hope you don't lose to...

The size limit is 2Gb.

You can store any binary document you like in it, PDF, MS Office, Graphics, you name it.

If you are going to use replication you may want...

It sounds like a user have been given the rights to grant other users access.

Unless there is an absolute imperative I have every single object owned by the dbo.

Are there...

Yes, the IMAGE data type should work. This is similar to the MySQL LONGBLOB type.

I use the ADO command object in a similar manner to that below

Set cmd...