Until SQL2008 is officially released I wouldn't let it near any existing boxes.

My approach with the CTPs is to completely wipe the box in between CTP releases.

Even after the launch...

My first reaction on seeing the latest Microsoft SQL Intellisense was disappointment. It looked like a cut down version of SQL Prompt when SQL Prompt was a $20 app...

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