twin.devil (7/21/2014)

---

If you are loading large data in that particular table where you have created the index, then you can use disable and restore approach which can increase your performance....

Jeff Moden (7/16/2014)

---

murnilim9 (7/16/2014)

---

Thanks a lot on your response !

Btw I performed rebuild indexes on certain databases ..maybe around 22 indexes need to be rebuilt and it failed and showed...

Thanks a lot on your response !

Btw I performed rebuild indexes on certain databases ..maybe around 22 indexes need to be rebuilt and it failed and showed an error :

/*********************************************..."...

Hi All,

I performed rebuild indexes on certain databases ..maybe around 22 indexes need to be rebuilt and it failed and showed an error :

/*********************************************..." failed with the following error: "Transaction...

Shaun Finnegan (7/15/2014)

---

I'd first try to update the stats on the database that has the performance issues to see if that helps. Looks like you have alot of free...

sorry ... I hv just realized there is something that I haven't answered yet..

I perform the default rebuild indexes which has the feature ( Sort_temp = off ) and when...

Thanks for your response ...

I am doing the maintenance plan due to the performance issues...

hmm at the moment we changes the t-log backup into every 2 hours and let...

oh thanks so much for your links..very useful information !

i am performing offline index since the edition of my SQL is Standard which will not support online index.

I noticed the...

hmm I have dropped the index anyway (moreover, I noticed the statistic of the unused index is quite convincing )...

btw how do we find out which stored proc that use...

Dear Roger and Gail Shaw

Thanks for your response..much appreciate it .. actually we perform the log backup every 3 hours but we do it using third party which is Symantec..

I...

Btw I have another issue after running the rebuild/reorganize index script ( once in 2 days ) ...the log files grows very fast ..we just added new harddisk a few...

OK Cool .. I will just drop it 🙂

Thanks so much !!

In addition ...comparing with other tables ...this table is quite small ..other tables are hundred thousands of records ...

so it means this index is useless ? cause SQL prefer to...

hi too ... hmm the table has 12.135 rows and the number of page on that index is 51 ...

What do you think ?

Thanks 🙂

hi ..Thanks for your response ! much appreciate it ...

previously i used 90 as fillfactor but the page split is too fast so i lower it down become 80 ...

i...