The script in Books on line defrags the indexes that ran good .i also need some help to rebuild the indexes based on fragmentation for sql server 2000.

I found...

I am sorry to bother you but my server is using the compatibility Sql server 2000(80) which will only run DBCC showcounting...

And also, if i want to rebuild the index...

but the query doesnot depend on fragmentation...

I have installed sql server 2005 standard edition.but the compatibility is sql server 2000(80).

I have only selected DB_ID and ran the query i got this:

Select DB_ID('oncx')

Result:

Nocolumnname

14

And i tried this :

SELECT...

Still getting the same tried many times .

Do i need to create the function before i select sys.dm_db_index_physical_stats....

Thanks fo your reply.

Thank you for the reply .

I have come across few articles which tells me when we should rebuild the index using fragmentation and DMV.

Using DMV i.e

SELECT *

FROM...

This is a business objects report created by dragging column and table names and the query is the backend no one has developed it........

I ran the query today ,first...

here you go ...i have attached query,indexes on queries and execution plan.

Yesterday,I have created indexes on all the columns that where clause is using and i ran the...

Will this be helpful................

I have seen the execution plan ,in that it is scanning rows .i heard that seek performs good than scan.

but i don't know how to create clustered index seek can...

Thanks i will try that....

Hi,

ISSUE:

- We started seeing SQL query timeout errors in the server application event log starting 10/30/09. The number of errors...

I have just posted the code as an example i don't want to waste your time by analyzing the code .and can you tell me weather i should create indexes...

Thanks for every one it worked.

How should i go into Management studio and verify file stream is enabled on the server.