On SQL 2005, you will be surprised that reindexing a temporary table can cause this error.

I have tested this on other versions like 2012 and it does not arise.

I guess...

Hello good people,

I tested my solution before I posted it here so I am speaking from experience which I am sharing.

I manage a large number of database servers which I...

Hey,

SQL Enterprise edition is different by design from SQL standard edition but in 10 steps, here's a straight forward way to avoid expensive work and the lengthy error fixing...

Hi SSC-Addicted,

This will still show the percentage free/used but not in a kind of chart view.

For the chart view, there's no other way other than choosing properties of that drive.

For...

Hi guys,

I took long to respond but I meant to say that you should not use PAE with the 3GB switches at the same time. Sorry about the mixup.

Yes, definitely physical address extensions is the best option for you.

It's also worth noting that you should use either AWE or PAE but not both.

Let us know how you progress.

Hi, this is clearly a memory issue and there are a number of things that can lead to performance degradation.

1. Check if your applications often run cursors. Check your programability. Cursors...