Josef -

Thanks for the short editorial 'On Being the Exceptional DBA'. I enjoyed it. And congrats on the well deserved recognition. I love the quote from your...

I don't know why statistics are disabled. I'm afraid it's not a temporary condition, though... unless I can convince them to rethink it! The one person that I...

Thanks everyone for the input. Here's what I found out:

First I should disclose that I am not a DBA at my work, I am a developer. After some prodding,...

@J-F Bergeron -

This is how I'm creating the table:

CREATE TABLE #Temp ( ID INT NOT NULL )

INSERT INTO #Temp

SELECT ID

FROM PermanentTable WITH (NOLOCK)

WHERE Date <= @Date

ALTER TABLE #Temp ADD...

Sorry, I don't mean to come off as secretive, but I'd probably get fired for posting code. That issue was raised by the very top of our management only a...

Thanks for these amazingly fast responses!

@GSquared -

What do you mean "Try the index?" I created the #Temp table, inserted the rows and then created the index. ...

Thanks for posting this info. I also have some situations where several sprocs access the same tables for different purposes. It'll be nice to get specific performance change details system...

I've been a donor for the past 4 years. What got me started was donating plasma for my son. He needed heart surgery when he was 10 months...

@Old Hand -

Thanks very much! That's a great solution.

@jeff -

I'd read that article once a long time ago. Thanks for reminding me about the problems with...