Chad Crawford (7/12/2010)

🙁 I don't want to wait. I had to build a...

I would agree with Gail. Once it starts, there's nothing you can do. Before it starts, there are some config possibilities (MAXDOP, Query limits), Resource Governer (SS2K8) that can help...

baseball

No more large, bouncy, kicky, back-and-forth ball with too many shutouts.

Thanks for your service.

I don't think those comments were inappropriate, and if they were hurtful, perhaps you should re-examine what you are asking. An update is a fairly trivial statement....

good point. I'd prefer less inter-league games, but I don't hate the situation.

I was thinking yesterday about soccer because it was on the radio. I'm not a fan, and have...

I posted a note on the Connect item as I'm with Gail. I'm not sure this helps with a balanced tree, and would like some more commentary and a better...

Look at the CASE statement.

SELECT CASE

WHEN MyCol = 1 THEN 'Alert'

WHEN MyCol = 0 THEN 'OK'

ELSE 'No idea'

END

from MyTable

where MyCol...

I think Ray has a great take. I came into the DBA world from both an admin (early) and developer (next) worlds. Those "secondary skills" were extremely important in a...

I think it does mean something for some of the people. There will always be, and probably always were, those that didn't think much of the game. They'd rather have...

An identity property and a unique index on this column will work. Trying to build the work for a random number is wasted effort. It's not needed.

I'd like to have you answer Jim's question. Typically a random number isn't used, and I suspect that you'll get yourself into trouble without understanding why. If this is a...

Yes, the two updates would be one transaction, and the log could not clear between them, simple mode or not.

You could also set a t-log backup in the middle of...

I added my thoughts to the thread. I think the guy/gal was humble enough, admitting he was in over his head there. I am hoping, with my best effort, that...

Here's a skeleton, though as Alvin mentioned, if you don't understand Books Online, you are in for a rough time. Please get someone to help you go over the structure...

In my example, I hadn't built a PK, but you can add one to ProductSection. Or a constraint to prevent duplicates. Not sure a PK matters.

In terms of taxes/registers. My...