Interesting!

I thought that hierachal databases were making a come back for very large databases because of their performance advantages.

Are XML databases hierachal?

Do you know if there are there any OO...

When you create a temporary table its name is always unique.

You think you have created #Tbl_MyTable and to all intensive purposes you have, but the real name will be #Tbl_MyTable_____...._DE...

I know that temporary tables are stored in tempdb but where are tables stored in a "table" data type stored?

In the case of some of one of our CMS's there is always some database traffic but the initial traffic is to determine if the object in the database is...

We use a variety of content management systems and the approach that they take is to cache the results of a query in their own internal cache.

Another approach that we...

Statistics and military intelligence share a characteristic that they should be used as as a predictive tool or indicator to say what is likely to happen.

They shouldn't be used to...

Frank,

You know when you are trying to teach your kids to behave properly part of it is getting them to speak properly (and the rest is teaching them when to...

I think this also illustrates why DBA's need to included in development and why code must be vetted by someone competent to do so.

If you are going to use the...

I tend to put each user database into a separate maintenance plan.

On small to medium databases I tend to enable the "Reorganise data and index pages", where as on larger...

"Thous shalt know thy data"

Good up to a point, however some databases contains thousands of tables.

I think that a good general rule for all IT personnel (and in particular DBA's)...

I wish Microsoft would invent a license that caters for home use.  I know you can get learning editions of VB and VC and VC# but it would be great...

Sorry Frank, translation follows

FAST = Federation against Software Threat.

Microsoft licensing takes the complete opposite of your KISS approach.

Get your licensing wrong and you boss...

I think one thing that has come out of this thread is the need to prioritize your DR plan.

If your documentation is stored on an intranet then  a DR plan...

I didn't know that you could license SQL Server to a person.  I thought there were only two licensing options.

• CAL
• Per processor

In my case I deal exclusively with systems accessible via...

So basically DR is ensuring that your CV is up-to-date and backed up ready to mail at the drop of a hat