make sure you make it a date-datatype instead of a string using cast or convert

Comparing dates with strings is usually a recipe for disaster

Nice that the DTA advisor mentioned a missing index, even learned a new keyword "includes" (any benificial scenario's for include?). A rewritten index made it even better.

I was looking for a random news fact dated 19th of november 2000. Milk Inc is mentioned at the bottom.

DBCC Timewarp: Active Directory returns to 19 november 2000. New singer Linda Merts for the popular belgium pop/dance group. Waar zijn die handjes?:-D

Save the environment and enable free compression in the standard editions.

The hard part is getting there, having the monitoring setup as you would like. Transforming from add-ons to smoothly integrated. Still playing with various nuts and bolts

You run those programs in "windows safe mode"?

I can't copy or link the oracle support doc as you need an active account.

Check the blog above, it contains the command below[/url]

netsh interface tcp set global autotuninglevel=disabled

Other possible culprits:...

Hello,

I hope it is stress. Having to manage too many troublesome instances or other work that has to be done too.

Also it is a lot harder to revert to a...

What version of oracle oledb did you install?

Latest can be found here

Apparently there is a networksetting "TCP window scaling" that might be the culprit:

See Oracle support document Oledb and Odbc...

Postponing defragmentation till really necessary as there are some many things involved: usage, fragmentation DB level, fragmentation os level, fragmentation storage level...

Thanks for sharing

Check out the Driver mania thread in this forum

I don't have the time to test it properly.

Same problem mentioned

Do you have the problem in a blank access 2010 database? As 2003/2007 is out of active support. Office life...

What type are the Access datafields? Memo?