There's always a benefit to maintaining indexe...

2011-04-27T12:15:51.731-04:00

There's always a benefit to maintaining indexes. I generally schedule index rebuilds weekly for all databases...including Central Objects.

Very interesting... The new code works great! Is t...

2011-04-26T16:16:17.166-04:00

Very interesting... The new code works great! Is there any value gained from rebuilding the tables in the central objects that aren't package specific?

Fixed it. The problem was the portion of the code...

2011-04-26T14:30:03.985-04:00

Fixed it. The problem was the portion of the code that returned the Object Librarian name of the table by joining the table name in sys.objects with the table name in Object Librarian. Turns out there is no table in OL named F98711PD900FA or somesuch. Who knew?

Grab the new code in

Jeremy, Yup, you're right. Let me look into...

2011-04-26T13:32:17.949-04:00

Jeremy,

Yup, you're right. Let me look into it.

Jeff, I tried this out today along with an older ...

2011-04-26T13:18:03.497-04:00

Jeff,

I tried this out today along with an older post you had titled, "Determine Index Fragmentation in a SQL Server Database". After I rebuilt the package tables I ran the code from the older post to analyze the fragmentation of the central objects database. I expected to see a list of indexes for the package tables with a 0% fragmentation. The results only showed the

Jeff, This is very cool stuff. I am going to give...

2009-09-03T14:03:03.880-04:00