Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yaman
Posting Yak Master
213 Posts |
 Posted - 2012-02-10 : 06:14:25
|
| Hello Sir , I am trying to search data from web application from sql erver 2005 table . Search found no record from web app. but same query execute from sql server then it return records .I am run query to check table space then it give below records -------------------------------------------------------------name - tbl_Consultant --- ( FTS is already applied on it ) rows - 112717 KB reserved - 7466752 KB data - 7464136 KB index_size - 9776 KB unused - 0 KBPlease let me know Sir what can I do . Yaman |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-10 : 09:10:32
|
| does webapp has additional business logic written into it?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
yaman
Posting Yak Master
213 Posts |
Posted - 2012-02-10 : 11:02:49
|
| No sir , he just call stored procedure display return datasetYaman |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-10 : 11:11:57
|
| are you using any wild card characters for search?probably you can explain a search scenario so as to give us clear idea------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
yaman
Posting Yak Master
213 Posts |
Posted - 2012-02-10 : 11:15:40
|
| No Sir .We applied ( full text search ) on table thats why we used contains keyword to search words .Now my table size is 8 gb . Yaman |
|
|
|
|
|
|
Table Search Slow