Hello,
i am making a Fulltextsearch on MS SQL Server 2005 (indexed, with "Contains").
Because of performance reasons i am only showing the first 200 rows mssql finds ("select top 200...:").
Is there any possibility to get the estimated totalnumber of all rows? i have heard something that is possible to get this in mssql-server. The server then estimates how many rows with that searchword could be in the whole database. google i.e. makes the same thing...
is that true? what do i have to do to get this?
greetings and thx
cpt.oneeye
You can use such statement to get the row number of a table:
sp_spaceused 'myTable'
No comments:
Post a Comment