The features that interest me are as follows

1. Spatial data types

2. Resource governor

3. Improvements to SSIS/Analysis Services/reporting Services

4. Backup compression

5. Looks good on my CV

Chiropracters sound dangerous!

I know a very good osteopath who has helped me no end. I had a nasty whiplash injury and he got me to the stage where I...

What browser are you using? In FireFox the code block gets...

Hi,

I'm Dave's wife, I can recommend an earlier article " users from hell", I am fairly computer illiterate but still managed to split my sides over that one myself!.

Another...

Ah the linguistic differences again. Took me a bit to remember that "pinching" is slang for "stealing". Like the fact that a nickname is the name they gave...

Glad you all enjoyed it.

I forgot to mention that the museum curator told me that he has to replace the "turd" at frequent intervals because kids keep pinching it.

For all...

There is always a problem creating the "must have" product when you have no idea what that product the consumer will consider to be "must have".

What I read into Joel's...

If I am altering the structure of a table then at the end of my script I put

exec sp_recompile ' '

UPDATE STATISTICS

If it is a smallish table then...

Forgive my ignorance on the subject but if you have a virtual server instance with the same spec (CPU, RAM etc) as a physical server am I to expect a...

In a tech shop I can see an argument for delegating the maintenance of PCs down to a responsible team lead. Someone who can be trusted to ensure that...

Is there a service broker manager so the queue size can be monitored?

I think what constitutes an exceptional DBA changes depending on the economic climate.

Obviously technical competence comes into it but at the moment the ability to wring the last possible clock...

rbarryyoung (3/9/2008)

---

First of all you have to determine & define what the Purpose of your Audit Trail is. Is it for:

1) simple diagnostics and troubleshooting of the application &...

Date/Time formatting is always a problem. Unless you know the starting format and the locale then you are going to run into problems.

Even if you start with a date...

In addition to the previous post I believe that CAL licensing has to be done in a minimum of a block of 5.

One CAL is used by the server itself...