Based on this solution, i found a faster way : <br /><br />DECLARE @MIN int<br />DECLARE @MAX int<br /><br />-- find the id range of the page<br...
Of course requesting the 2nd page like this is fast. But execute this on a table with 500.000 records or more and select the last page : SELECT TOP...
>How about db maint. plan against this database?<br /><br />I'm not sure i understand this.<br /><br />>How often you schedule DBREINDEX?<br...
Hi, I have an SQL 2000 database containing geographic data. The data is imported from a big file, and is only updated with small changes each month....
Separate names with a comma.
