If you are sure that you're properly refreshing the cache, then you may be hitting a bug. All the tests I've run show it working just fine, so I'm not...

I've been primarily lurking, but I've decided to put in two points.

First, I'm not crazy about a lot of the suggested directions for a middle-level certification that have been put...

The mug? Sorry, 20k was for the badge. To get a mug...

Only memorable ones I have are WAY back in the early nineties at Merrill Lynch one of our Unix admins was a star gazer. We had Betelguese & Rigel that...

Lynn Pettis (3/26/2010)

Love the parody.

Perhaps we need more discussions like this, between close friends and...

Jack Corbett (3/26/2010)

Grant Fritchey (3/26/2010)

Lynn Pettis (3/26/2010)

Neck and head hurt, don't care. 😛

Sometimes the truth hurts. I really need to start...

Lynn Pettis (3/26/2010)

Neck and head hurt, don't care. 😛

Sometimes the truth hurts. I really need to start posting on my Geek...

No, no. My ego...

The problem is you're explaining the table and it's size and that you have a problem, but you're not describing what the problem is. Are you having trouble on inserts?...

Those things you're looking at are considered the best practices.

Bhuvnesh (3/26/2010)

Frankly tell you this would be a intermediate/ working table ( prefebly a...

I don't think any index is going to help the query, but, I'd strongly suggest you identify the primary key on the table and make that a clustered index. This...

I'm assuming you're using a lot of automatic settings, so your databases are probably on auto-grow. Nothing wrong with that, but now you need to monitor disk free space very...

I think it looks OK. Test it on a different machine first to verify you get what you need.

Heck better Database Administrator than Database Developer. There's an average $20k difference in their salaries in the US. What I really do is develop databases, but I put down DBA...