Viewing 4 posts - 31 through 34 (of 34 total)
Best place to look to learn more about SQL server 7.0. For e.g clustering, triggers etc is the SQL Server Books 7.0 Online at this point. You may be able...
July 30, 2003 at 6:44 am
Paul, I have tried to reproduce your scenario and the Optimizer should have chosen to use "Clustered Index Seek". I did the similar query with tables of 12.5 M and...
July 10, 2003 at 7:58 am
The optimizer is choosing the best plan in your case as your query has multiple column search (a.anumber and a.site_FK). From your writing, tblline a does not have any composite...
July 10, 2003 at 6:57 am
Great Article and very good insight into tackling the lock waits in a transactional system.
November 21, 2002 at 7:39 am
Viewing 4 posts - 31 through 34 (of 34 total)