Hi everybody.
Hopefully one of you can provide some insight to this one. I recently met
someone who said they were having trouble with MSSQL crapping-out (that's a
technical term) when querying a 65 million record db. Their SQL statement
which they were apparently trying to run from Query Analyser, was something
like....
select
acolumn,
bcolumn,
ccolumn
from
tablename
where
(acolumn = 'boo' AND bcolumn = 'yikes') OR
(bcolumn = 'haha' AND ccolumn = 'clown')
I'll try to get the exact query they were trying to execute. However any
thoughts at this point? Is 65 million records more than MSSQL can handle?
Any suggested workarounds?.... perhaps search in chunks of records as
opposed to all of them?
Thanks,
Karl
-
You are subscribed to the CFUGToronto CFTALK ListSRV.
This message has been posted by: "A. Karl Zarudny" <[EMAIL PROTECTED]>
To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/
Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/
This System has been donated by Infopreneur, Inc.
(http://www.infopreneur.net)
