That's pretty neat--I didn't know that was there. Here's what it
recommended:
USE Emerald
CREATE NONCLUSTERED INDEX [calls0]
ON [dbo].[calls]([calldate], [username], [nasport], [acctsessiontime])
CREATE NONCLUSTERED INDEX [subaccounts1]
ON [dbo].[subaccounts]([login], [accounttype], [loginlimit])
I haven't done anything with it though because I don't know what negative
effects it might have with RadiusNT, etc.
> I would guess you are running into a problem with RadiusNT inserting
> records into the table, while you are trying to read them.
That was my guess too. At least RadiusNT seems to have priority over
scripts run in ISQL / Query Analyzer.
> I'd have to see your table/index list to really make a guess at
> the problem, though.
Since the output of "sp_help calls" is 25k and very wide, I put it at the
address below. I also stuck in the results of "sp_spaceused calls" at the
top:
http://hillman.talstar.com/calls.txt
Let me know when you get it so that I can remove it.
Thanks,
Josh
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart