Posted by Greg D. Moore \(Strider\) on 10/01/83 11:39
"Paul" <paulwragg2323@hotmail.com> wrote in message
news:1139501789.272455.6750@o13g2000cwo.googlegroups.com...
>
>
> It turns out that we have a table that is over 1GB in size. We only had
> the server configured to allow SQL Server to use 800MB.
>
This may hurt performance but should not break things.
We routinely use tables multiple gigabytes in size.
But we did hit a bug (I forget details) in a query we were doing on a SQL
2000 SP3 DB.
SP4 fixed it.
> Therefore, when we were querying using a query resulting in a full
> table scan there was not enough memory to perform the query. Instead of
> returning an error it basically just stopped (or maybe it was doing the
> query but it would take years!).
>
> Anyway, thanks to all those that posted!
>
> Paul
>
[Back to original message]
|