Our statistics keep getting our of wack, and I was wondering what we can do to have this stay up to date. Is there a setting in the database? Any thoughts?

I wasn't logged in by accident, so I am the annonymous coward!

MarcoP wrote:

I wasn't logged in by accident, so I am the annonymous coward!

No, the Anonymous Coward is another user The real anonymous user is called differently (And can't do a lot )

Hey, How about an answer 2 the question.

MarcoP wrote:

Hey, How about an answer 2 the question.

What if I don't know the answer?

Statistics in sqlserver are kept by the server itself and are solely used by the optimizer to find the proper optimization. Normally statistics work ok, they only are gone when tables are truncated/bulkimported.

Otis wrote:

MarcoP wrote:

Hey, How about an answer 2 the question.

What if I don't know the answer?

Statistics in sqlserver are kept by the server itself and are solely used by the optimizer to find the proper optimization. Normally statistics work ok, they only are gone when tables are truncated/bulkimported.

I was only joking, I've yet to find a question that you dont have an answer for.

Seriously, we are blown away here at my work regarding all the functionality and effort you put into the product. We have a little joke here, whenever we can't figure out how to do something with LLBL, we say, " Hey, why dont you "Google" Frans."

Hey, why dont you "Google" Frans.

Careful now, this is a family message board.

heh