I implement the advise Kimberly provided in her blog:

Free proc cache if to much single used plans

ref: http://www.sqlskills.com/BLOGS/KIMBERLY/post/Plan-cache-adhoc-workloads-and-clearing-the-single-use-plan-cache-bloat.aspx

Can you elaborate on the "We seem to have solved a major IO problem last weekend so we'll see how long it runs this weekend." ?

Are there typical slowdowns /...

wise decision !

Keep in mind MS has a free downloadable migration assistant for MSAccess to SQLServer 2005/2008 .

Maybe it can even help you in your current situation to see what...

Brandie Tarvin (3/10/2011)

---

I...

I don't think you'll get the column name,

but the ordinal can be retrieved using a udf

Don't shoot me if this doesn't perform well, chances are a clr fn can...

You'll need to post both execution plans to be able to give you a hint on your Q.

since for now we are at instance level, I would expect exposure of sys.configurations but I seem not to be able to find it using the product.

Interesting project tough:

1)...

ebook SQL Server Statistics by Holger Schmeling (free download at red gate http://www.red-gate.com/our-company/about/book-store/ )

stated about 100 rows. ( page 24 )

Of course, as always ... test it, test it, test...

First of all I would install the SP3 version (which is the latest now)

If you have a look at the screenshots of this post, you'll see Figure E where...

just my 2 ct to get an idea on how many GB you'd need:

Save your execution plan and open it with sqlcentry (free) plan explorer .

It will give you a...

Another vitamin boost by SQLkiwi 🙂

Gianluca Sartori (3/3/2011)

---

Thank you Johan, I must have missed your last post. :blush:

We're still working on the issue with MS support.

Now they're trying to reproduce the problem on their own,...

yep. You'll have to re-install.

Have a look at http://msdn.microsoft.com/en-us/library/ms189852%28v=SQL.90%29.aspx

it states:

Keep in mind to apply the latest service pack !

just a side note:

You will possibly have seen 100% cpu because you still have your instance max degree of parallelism to its default value of 0 (full controlled by...

Should be used as WITH (NOLOCK) (if you need to use it in the first place ?)

I think the ( ) is supposed to be mandatory in versions >...