Ah!, good point Barry... so how about your mother!!!!

😀

Tssss,tsss, you had to go ahead and wake up the tigger... and I was hoping for a quiet xmas!!!

I bet a small dollar that this will be the new longest...

Still ranting...

the simple fact of the matter is that if he had bothered to start the install he would have known right away if he could do a straight...

Move whatever the function is doing into a derived table. The millions of call to that function is what is killing the performance.. no amount of indexing an overcome...

Why do you need the nolock?? That data is persisted so the nolock shouldn't really matter, or does it?

NP, it's easy to ask for something and wait for someone to have it done ;).

Start a trace with only the grow (and shrink) events.

You can setup a job to run start a serverside trace to run for 24 hours, and run that job daily.

Nice article. Anyone care to spend 20 minutes doing copy/paste work to put all that code in a single file and test it so that this article can actually...

That's actually the way to go.

Log the db size regularly, then project the db size 1-2 years down the road and resize accordingly. Constant auto-grow has nasty effects on...

GilaMonster (12/18/2008)

Why not? I've seen...

2 things : 1 the optimizer must assume that the parameters will change. Maybe it tries to figure out the best plan for the normal or worst case scenarios......

Well then, what is your fully tested method of operation in those cases. Take a good guess, then go with 25 times more data then adjust as need be...

We've had 2 official languages in Québec for decades and it works great. It's been a life saver for me (literally).

I'm here to help, I don't care all that...

There's a question, it's just not obvious.

The guy abviously has troubles with the english written language. Nothing to be made fun of guys!!!!!!1

I think I can safely assume that I have no possible good answer to that post so I'll just shut up :w00t::hehe:.