Full Text Search

Hi

This is Yogesh Jangam
I m using SQL Server 7.0 and ASP for an intranet application
I am using Full Text Search feature os SQl 7.0.

The problem is i am not sure where to populate my Catalog which i am using for searching Articles. Basically, Various writers will be submiting, approving Articles which can then be searched by other users to be read or referenced

i was thinking to populate full or incremental, once an Article is approved, but i think it is time and resource consuming

any way

suggest me!!Reasonable would be a full-index at night, when traffic is low on your website and incremental during the day.|||Originally posted by beyond cool
Reasonable would be a full-index at night, when traffic is low on your website and incremental during the day.

hey thnks

I also wanted to ask abt Index Server

I want to search thru articles and files uploaded with it.

It will have a search window with search string and an "Include Files" checkbox.

Shud i implement FTS and Index Server Search separately or is there any way to integrate those

bye|||Originally posted by yoja7
hey thnks

I also wanted to ask abt Index Server

I want to search thru articles and files uploaded with it.

It will have a search window with search string and an "Include Files" checkbox.

Shud i implement FTS and Index Server Search separately or is there any way to integrate those

bye

I'm not sure. All the implementations I've seen however have had separate implementations that were somehow combined, eg, return the FTS results first and then append the ISS results.|||Yes

My colleagues also give me same suggestions like

do FTS first and Index later

or display one FTS result and one Index search result

lets see how it turns out.

I was also trying to do Incremental Scan for FTS when a Article is approved [but i am worried about performance of my application]

Full text search

Hi
I am testing the usage of FULL TEXT feature and somehow it is not working
for me.
I have 2 rows in a table zz with values
this is a sta test
test
Now when I run the following query I do not get any rows back
but the full text index is used.
select zz from zz where contains ( *,'sta')
|--Hash Match(Left Semi Join, HASH[zz].[zz])=([FULLTEXT:zz].[KEY]),
RESIDUAL[zz].[zz]=[FULLTEXT:zz].[KEY])) 40 3 1
Hash Match Left Semi Join
HASH[zz].[zz])=([FULLTEXT:zz].[KEY]),
RESIDUAL[zz].[zz]=[FULLTEXT:zz].[KEY]) NULL 1.0
0.0 2.4346894E-2 36 0.42534244
[zz].[zz] NULL PLAN_ROW 0
1.0
|--Clustered Index Scan(OBJECT[base].[dbo].[zz].[PK_zz]))
40 4 3
Clustered Index Scan Clustered Index Scan
OBJECT[base].[dbo].[zz].[PK_zz])
[zz].[zz] 2.0 3.7578501E-2
8.0700003E-5 76 3.7659202E-2 [zz].[zz]
NULL PLAN_ROW 0 1.0
|--Remote Scan(OBJECTCONTAINS))
Can you post the results of the following queries?
select FulltextCatalogProperty('CatalogName', 'ItemCount')
replacing CatalogName with the name of your catalog. If the value is 1 or
the number of tables you are full text indexing you will have to run a
population. If you have already run a population, check the application log
using event viewer to see if there are error messages from MSSCI or
MSSearch.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
message news:3E800AE8-603F-4ADF-BCE8-1C3B27174547@.microsoft.com...
> Hi
> I am testing the usage of FULL TEXT feature and somehow it is not working
> for me.
> I have 2 rows in a table zz with values
> this is a sta test
> test
> Now when I run the following query I do not get any rows back
> but the full text index is used.
> select zz from zz where contains ( *,'sta')
> |--Hash Match(Left Semi Join, HASH[zz].[zz])=([FULLTEXT:zz].[KEY]),
> RESIDUAL[zz].[zz]=[FULLTEXT:zz].[KEY])) 40 3 1
> Hash Match Left Semi Join
> HASH[zz].[zz])=([FULLTEXT:zz].[KEY]),
> RESIDUAL[zz].[zz]=[FULLTEXT:zz].[KEY]) NULL 1.0
> 0.0 2.4346894E-2 36
0.42534244
> [zz].[zz] NULL PLAN_ROW 0
> 1.0
> |--Clustered Index Scan(OBJECT[base].[dbo].[zz].[PK_zz]))
> 40 4 3
> Clustered Index Scan Clustered Index Scan
> OBJECT[base].[dbo].[zz].[PK_zz])
> [zz].[zz] 2.0 3.7578501E-2
> 8.0700003E-5 76 3.7659202E-2 [zz].[zz]
> NULL PLAN_ROW 0 1.0
> |--Remote Scan(OBJECTCONTAINS))
|||Thanks. I did check in event viewer and came across this warning when I tried
to do the full load
The crawl seed <MSSQL75://SQLServer/182c9b23> in project <SQLServer
SQL0000500005> cannot be accessed. Error: 80040e09 - Permission denied. .
also
select FulltextCatalogProperty('zz', 'ItemCount')
0
mangesh
"Hilary Cotter" wrote:

> Can you post the results of the following queries?
> select FulltextCatalogProperty('CatalogName', 'ItemCount')
> replacing CatalogName with the name of your catalog. If the value is 1 or
> the number of tables you are full text indexing you will have to run a
> population. If you have already run a population, check the application log
> using event viewer to see if there are error messages from MSSCI or
> MSSearch.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
> message news:3E800AE8-603F-4ADF-BCE8-1C3B27174547@.microsoft.com...
> 0.42534244
>
>
|||The below kb addresses the most frequent cause of this problem.
http://support.microsoft.com/default...b;en-us;317746
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
message news:530DC499-0431-4030-A02A-5658AC5E3EE5@.microsoft.com...
> Thanks. I did check in event viewer and came across this warning when I
tried[vbcol=seagreen]
> to do the full load
> The crawl seed <MSSQL75://SQLServer/182c9b23> in project <SQLServer
> SQL0000500005> cannot be accessed. Error: 80040e09 - Permission denied. .
> also
> select FulltextCatalogProperty('zz', 'ItemCount')
> 0
> mangesh
> "Hilary Cotter" wrote:
or[vbcol=seagreen]
log[vbcol=seagreen]
in[vbcol=seagreen]
working[vbcol=seagreen]
HASH[zz].[zz])=([FULLTEXT:zz].[KEY]),[vbcol=seagreen]
0[vbcol=seagreen]
[zz].[zz][vbcol=seagreen]

Full text search

Hi
I am testing the usage of FULL TEXT feature and somehow it is not working
for me.
I have 2 rows in a table zz with values
this is a sta test
test
Now when I run the following query I do not get any rows back
but the full text index is used.
select zz from zz where contains ( *,'sta')
|--Hash Match(Left Semi Join, HASH[zz].[zz])=([FULLTEXT:zz].&#
91;KEY]),
RESIDUAL[zz].[zz]=[FULLTEXT:zz].[KEY])) 40 3
1
Hash Match Left Semi Join
HASH[zz].[zz])=([FULLTEXT:zz].[KEY]),
RESIDUAL[zz].[zz]=[FULLTEXT:zz].[KEY]) NULL 1.0
0.0 2.4346894E-2 36 0.42534244
[zz].[zz] NULL PLAN_ROW 0
1.0
|--Clustered Index Scan(OBJECT[base].[dbo].[zz].[PK_zz]))
40 4 3
Clustered Index Scan Clustered Index Scan
OBJECT[base].[dbo].[zz].[PK_zz])
[zz].[zz] 2.0 3.7578501E-2
8.0700003E-5 76 3.7659202E-2 [zz].[
zz]
NULL PLAN_ROW 0 1.0
|--Remote Scan(OBJECTCONTAINS))Can you post the results of the following queries?
select FulltextCatalogProperty('CatalogName', 'ItemCount')
replacing CatalogName with the name of your catalog. If the value is 1 or
the number of tables you are full text indexing you will have to run a
population. If you have already run a population, check the application log
using event viewer to see if there are error messages from MSSCI or
MSSearch.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
message news:3E800AE8-603F-4ADF-BCE8-1C3B27174547@.microsoft.com...
> Hi
> I am testing the usage of FULL TEXT feature and somehow it is not working
> for me.
> I have 2 rows in a table zz with values
> this is a sta test
> test
> Now when I run the following query I do not get any rows back
> but the full text index is used.
> select zz from zz where contains ( *,'sta')
> |--Hash Match(Left Semi Join, HASH[zz].[zz])=([FULLTEXT:zz
].[KEY]),
> RESIDUAL[zz].[zz]=[FULLTEXT:zz].[KEY])) 40 3
1
> Hash Match Left Semi Join
> HASH[zz].[zz])=([FULLTEXT:zz].[KEY]),
> RESIDUAL[zz].[zz]=[FULLTEXT:zz].[KEY]) NULL 1.
0
> 0.0 2.4346894E-2 36
0.42534244
> [zz].[zz] NULL PLAN_ROW
0
> 1.0
> |--Clustered Index Scan(OBJECT[base].[dbo].[zz].[
PK_zz]))
> 40 4 3
> Clustered Index Scan Clustered Index Scan
> OBJECT[base].[dbo].[zz].[PK_zz])
> [zz].[zz] 2.0 3.7578501E-2
> 8.0700003E-5 76 3.7659202E-2 [zz].
1;zz]
> NULL PLAN_ROW 0 1.0
> |--Remote Scan(OBJECTCONTAINS))|||Thanks. I did check in event viewer and came across this warning when I trie
d
to do the full load
The crawl seed <MSSQL75://SQLServer/182c9b23> in project <SQLServer
SQL0000500005> cannot be accessed. Error: 80040e09 - Permission denied. .
also
select FulltextCatalogProperty('zz', 'ItemCount')
0
mangesh
"Hilary Cotter" wrote:

> Can you post the results of the following queries?
> select FulltextCatalogProperty('CatalogName', 'ItemCount')
> replacing CatalogName with the name of your catalog. If the value is 1 or
> the number of tables you are full text indexing you will have to run a
> population. If you have already run a population, check the application lo
g
> using event viewer to see if there are error messages from MSSCI or
> MSSearch.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
> message news:3E800AE8-603F-4ADF-BCE8-1C3B27174547@.microsoft.com...
> 0.42534244
>
>|||The below kb addresses the most frequent cause of this problem.
http://support.microsoft.com/defaul...kb;en-us;317746
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
message news:530DC499-0431-4030-A02A-5658AC5E3EE5@.microsoft.com...
> Thanks. I did check in event viewer and came across this warning when I
tried[vbcol=seagreen]
> to do the full load
> The crawl seed <MSSQL75://SQLServer/182c9b23> in project <SQLServer
> SQL0000500005> cannot be accessed. Error: 80040e09 - Permission denied. .
> also
> select FulltextCatalogProperty('zz', 'ItemCount')
> 0
> mangesh
> "Hilary Cotter" wrote:
>
or[vbcol=seagreen]
log[vbcol=seagreen]
in[vbcol=seagreen]
working[vbcol=seagreen]
HASH[zz].[zz])=([FULLTEXT:zz].[KEY]),[vbcol=seagreen]
0[vbcol=seagreen]
[zz].[zz][vbcol=seagreen]

Full text search

Hi
I am testing the usage of FULL TEXT feature and somehow it is not working
for me.
I have 2 rows in a table zz with values
this is a sta test
test
Now when I run the following query I do not get any rows back
but the full text index is used.
select zz from zz where contains ( *,'sta')
|--Hash Match(Left Semi Join, HASH:([zz].[zz])=([FULLTEXT:zz].[KEY]),
RESIDUAL:([zz].[zz]=[FULLTEXT:zz].[KEY])) 40 3 1
Hash Match Left Semi Join
HASH:([zz].[zz])=([FULLTEXT:zz].[KEY]),
RESIDUAL:([zz].[zz]=[FULLTEXT:zz].[KEY]) NULL 1.0
0.0 2.4346894E-2 36 0.42534244
[zz].[zz] NULL PLAN_ROW 0
1.0
|--Clustered Index Scan(OBJECT:([base].[dbo].[zz].[PK_zz]))
40 4 3
Clustered Index Scan Clustered Index Scan
OBJECT:([base].[dbo].[zz].[PK_zz])
[zz].[zz] 2.0 3.7578501E-2
8.0700003E-5 76 3.7659202E-2 [zz].[zz]
NULL PLAN_ROW 0 1.0
|--Remote Scan(OBJECT:(CONTAINS))Can you post the results of the following queries?
select FulltextCatalogProperty('CatalogName', 'ItemCount')
replacing CatalogName with the name of your catalog. If the value is 1 or
the number of tables you are full text indexing you will have to run a
population. If you have already run a population, check the application log
using event viewer to see if there are error messages from MSSCI or
MSSearch.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
message news:3E800AE8-603F-4ADF-BCE8-1C3B27174547@.microsoft.com...
> Hi
> I am testing the usage of FULL TEXT feature and somehow it is not working
> for me.
> I have 2 rows in a table zz with values
> this is a sta test
> test
> Now when I run the following query I do not get any rows back
> but the full text index is used.
> select zz from zz where contains ( *,'sta')
> |--Hash Match(Left Semi Join, HASH:([zz].[zz])=([FULLTEXT:zz].[KEY]),
> RESIDUAL:([zz].[zz]=[FULLTEXT:zz].[KEY])) 40 3 1
> Hash Match Left Semi Join
> HASH:([zz].[zz])=([FULLTEXT:zz].[KEY]),
> RESIDUAL:([zz].[zz]=[FULLTEXT:zz].[KEY]) NULL 1.0
> 0.0 2.4346894E-2 36
0.42534244
> [zz].[zz] NULL PLAN_ROW 0
> 1.0
> |--Clustered Index Scan(OBJECT:([base].[dbo].[zz].[PK_zz]))
> 40 4 3
> Clustered Index Scan Clustered Index Scan
> OBJECT:([base].[dbo].[zz].[PK_zz])
> [zz].[zz] 2.0 3.7578501E-2
> 8.0700003E-5 76 3.7659202E-2 [zz].[zz]
> NULL PLAN_ROW 0 1.0
> |--Remote Scan(OBJECT:(CONTAINS))|||Thanks. I did check in event viewer and came across this warning when I tried
to do the full load
The crawl seed <MSSQL75://SQLServer/182c9b23> in project <SQLServer
SQL0000500005> cannot be accessed. Error: 80040e09 - Permission denied. .
also
select FulltextCatalogProperty('zz', 'ItemCount')
0
mangesh
"Hilary Cotter" wrote:
> Can you post the results of the following queries?
> select FulltextCatalogProperty('CatalogName', 'ItemCount')
> replacing CatalogName with the name of your catalog. If the value is 1 or
> the number of tables you are full text indexing you will have to run a
> population. If you have already run a population, check the application log
> using event viewer to see if there are error messages from MSSCI or
> MSSearch.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
> message news:3E800AE8-603F-4ADF-BCE8-1C3B27174547@.microsoft.com...
> > Hi
> >
> > I am testing the usage of FULL TEXT feature and somehow it is not working
> > for me.
> > I have 2 rows in a table zz with values
> > this is a sta test
> > test
> >
> > Now when I run the following query I do not get any rows back
> > but the full text index is used.
> >
> > select zz from zz where contains ( *,'sta')
> > |--Hash Match(Left Semi Join, HASH:([zz].[zz])=([FULLTEXT:zz].[KEY]),
> > RESIDUAL:([zz].[zz]=[FULLTEXT:zz].[KEY])) 40 3 1
> > Hash Match Left Semi Join
> > HASH:([zz].[zz])=([FULLTEXT:zz].[KEY]),
> > RESIDUAL:([zz].[zz]=[FULLTEXT:zz].[KEY]) NULL 1.0
> > 0.0 2.4346894E-2 36
> 0.42534244
> > [zz].[zz] NULL PLAN_ROW 0
> > 1.0
> > |--Clustered Index Scan(OBJECT:([base].[dbo].[zz].[PK_zz]))
> > 40 4 3
> > Clustered Index Scan Clustered Index Scan
> > OBJECT:([base].[dbo].[zz].[PK_zz])
> > [zz].[zz] 2.0 3.7578501E-2
> > 8.0700003E-5 76 3.7659202E-2 [zz].[zz]
> > NULL PLAN_ROW 0 1.0
> > |--Remote Scan(OBJECT:(CONTAINS))
>
>|||The below kb addresses the most frequent cause of this problem.
http://support.microsoft.com/default.aspx?scid=kb;en-us;317746
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
message news:530DC499-0431-4030-A02A-5658AC5E3EE5@.microsoft.com...
> Thanks. I did check in event viewer and came across this warning when I
tried
> to do the full load
> The crawl seed <MSSQL75://SQLServer/182c9b23> in project <SQLServer
> SQL0000500005> cannot be accessed. Error: 80040e09 - Permission denied. .
> also
> select FulltextCatalogProperty('zz', 'ItemCount')
> 0
> mangesh
> "Hilary Cotter" wrote:
> > Can you post the results of the following queries?
> >
> > select FulltextCatalogProperty('CatalogName', 'ItemCount')
> >
> > replacing CatalogName with the name of your catalog. If the value is 1
or
> > the number of tables you are full text indexing you will have to run a
> > population. If you have already run a population, check the application
log
> > using event viewer to see if there are error messages from MSSCI or
> > MSSearch.
> >
> > --
> > Hilary Cotter
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602.html
> >
> > Looking for a FAQ on Indexing Services/SQL FTS
> > http://www.indexserverfaq.com
> > "Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote
in
> > message news:3E800AE8-603F-4ADF-BCE8-1C3B27174547@.microsoft.com...
> > > Hi
> > >
> > > I am testing the usage of FULL TEXT feature and somehow it is not
working
> > > for me.
> > > I have 2 rows in a table zz with values
> > > this is a sta test
> > > test
> > >
> > > Now when I run the following query I do not get any rows back
> > > but the full text index is used.
> > >
> > > select zz from zz where contains ( *,'sta')
> > > |--Hash Match(Left Semi Join,
HASH:([zz].[zz])=([FULLTEXT:zz].[KEY]),
> > > RESIDUAL:([zz].[zz]=[FULLTEXT:zz].[KEY])) 40 3 1
> > > Hash Match Left Semi Join
> > > HASH:([zz].[zz])=([FULLTEXT:zz].[KEY]),
> > > RESIDUAL:([zz].[zz]=[FULLTEXT:zz].[KEY]) NULL 1.0
> > > 0.0 2.4346894E-2 36
> > 0.42534244
> > > [zz].[zz] NULL PLAN_ROW
0
> > > 1.0
> > > |--Clustered Index Scan(OBJECT:([base].[dbo].[zz].[PK_zz]))
> > > 40 4 3
> > > Clustered Index Scan Clustered Index Scan
> > > OBJECT:([base].[dbo].[zz].[PK_zz])
> > > [zz].[zz] 2.0 3.7578501E-2
> > > 8.0700003E-5 76 3.7659202E-2
[zz].[zz]
> > > NULL PLAN_ROW 0 1.0
> > > |--Remote Scan(OBJECT:(CONTAINS))
> >
> >
> >

full text indexing feature of SQL Server .

I am using the full text indexing feature of SQL Server .

I have indexed two text fields in the Content table and two other text fields in the ContentDetail table

The select queries are shown below for the two seperate calls.

I want to be able to show the results based on the rank ( The column that has the best match for the searched key ).

Since I am getting two different RANK arrays from the two calls, can i resort them in the code to get the new rank order to show the results in the screen

SELECT KEY_TBL.RANK,FT_TBL.Description, FT_TBL.Title
FROM Content AS FT_TBL
INNER JOIN
CONTAINSTABLE( Content, * ,
'ISABOUT (Cancer weight(1),Survivor weight(1), Shared weight(1), Story weight(1))' ) AS KEY_TBL
ON FT_TBL.ContentID = KEY_TBL.[KEY]
ORDER BY KEY_TBL.RANK DESC

SELECT KEY_TBL.RANK,FT_TBL.Description, FT_TBL.SubTitle
FROM ContentDetail AS FT_TBL
INNER JOIN
CONTAINSTABLE( ContentDetail, * ,
'ISABOUT (Cancer weight(1),Survivor weight(1), Shared weight(1), Story weight(1))' ) AS KEY_TBL
ON FT_TBL.ContentDetailID = KEY_TBL.[KEY]
ORDER BY KEY_TBL.RANK DESCThat would make a good pole...

How many dba's use this feature...

Never have...from what I understand it's a pig...|||I tried to get Full Text Search to work for a little while, until I realized you can not get "historical" to show up for searches with a search predicate of "history". I also had to make the queries in dynamic SQL, since you have so many dang quotes in the query. Pain in the neck, really.

Full Text Indexing

Hello,
I wanna learn Full Text Indexing feature in MS SQL, Please let me know where could i have a good resource about it. I tried google but i didnt find what i need.

regardsStart with SQL Server's Books Online. Then move on to the resultsthat you get from this Google search: "Sql Server" "Full text indexing"
|||Try the link below for a two part article on Full Text indexing in SQL Server. Full Text is an add on to SQL Server dependent on Microsoft search service and the Catalog must be populated to get expected results for search with Microsoft Proprietry implementation of ANSI SQL CONTAINS, CONTAINSTABLE, FREETEXT and FREETEXTTABLE. Hope this helps.
http://www.databasejournal.com/features/mssql/article.php/3454281|||

I have the same problem did u find some good resources?

I am looking foward to find away to scale(ditrubute), the full text engine in my machines.

Please let me know what u have got.

|||

erdsah88:

I have the same problem did u find some good resources?

I am looking foward to find away to scale(ditrubute), the full text engine in my machines.

Please let me know what u have got.

The first thing you have to do is run searches that will not return a whole table because SELECT * returns a whole table so sometimes your predicates are ignored. What I mean is you are telling SQL Server I want the whole table and you then add a predicate which SQL Server consider a trick it gets your query very slow. So spend time with Management Studio and the Profiler to reduce the cost of your query, make sure you run all queries through your application so you know how it affects your performance. Jeff Prosise published a check list for Asp.net application data was one of the most important, I have told you to get a data person you ignored it, you need someone who knows SET Algebra so your tables will be cleaned and all your SELECT * DML(data manipulation language) will be dropped. Microsoft built a new physical architecture for SQL Server 2005 see if you can use the new INDEX COLUMN include and pay attention to the IAM(index allocation mapping) pages. All of the above will take a long time but will clean most of your existing problems. One more thing test drive the new Database Developer VS use it to clean your DML. Hope this helps.

http://msdn.microsoft.com/msdnmag/issues/06/07/WebAppFollies/

http://blogs.msdn.com/sqlserverstorageengine/archive/tags/Index+Fragmentation+Series/default.aspx

http://msdn2.microsoft.com/en-us/library/ms190806.aspx

Full feature demo for SSRS Web Service Rendering (with Interactive Sort)?

Is there any example I can find a full feature demo of SSRS Web Service Rendering with Interactive Sort and other features enabled?

For MS: Indeed I think ReportViewer Control should be an open source component as we as developer needs the flexibility to customize the report viewer interface as well as can learn directly from the control source so to understand how can we integrate better with SSRS.

The RSExplorer sample distributed with the SQL Server 2005 Samples (installed by default in C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Application Samples\RSExplorer Sample) will probably help. Interactive sort uses the ReportExecutionService.Sort API. However, I don't think you will get too far trying to implement interactive sorting on your own since the Sort API takes the id of the item to be sorted but you have no way to know it in advance.

I agree with you that some RS areas are good candidates for open source, including the Report Viewer controls, Report Manager, and SharePoint web parts and I hope that a future release will help in this area. Meanwhile, you can use the .NET Reflector to understand how the Report Viewer control works.

|||The reflector is quite a useful guidance, I am very new on the reflector thing though, will try to see how it works. RSExplorer seems not the right project, there is no sign of using ReportExecutionService at all, it just does the report publishing using ReportService and use URL based browsing to run the report.

We could just hope MS to release these sources for us, but most people are quite negative in this expectation- including myself.