Indexes, Indexes, Indexes

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Ron Johnson » Indexes, Indexes, Indexes

43 posts, Page 5 of 5

«««1 2 3 4 5

Indexes, Indexes, Indexes

Rate Topic

Display Mode

Topic Options

Author

Message

BW_Toro

Posted Friday, July 08, 2011 5:52 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, October 26, 2012 7:57 AM
Points: 12, Visits: 523

@ Brian O'Leary

Please go back and read what I posted earlier in this thread and run the query I provided. I think I already showed where you may be mistaken.

The data collection query in the article always returns table names from the current database due to how the OBJECT_NAME function is used, and it always returns index names from the current database, but it can associate them with index usage stats for different indexes on different tables in different databases. The association (JOIN) is on object_id and index_id. If object_id and index_id match across databases (I have several cases of this occurring on a lightly loaded SQL Server instance) then the query returns very misleading rows. The names of the tables and indexes in the other databases are irrelevant because the query does not see them.

You have minimized (again) the inaccuracy of the data collection query in the article. Your "observations" are stated authoritatively, but I believe they are wrong.

Post #1139291

Jeff Moden

Posted Thursday, July 05, 2012 6:16 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 33,112, Visits: 27,038

I know this is an old article but since it was recently republished I have to say that I hope and pray that folks read the discussion before they even think about using the code as is especially when it comes to the code that supposedly returns the correct name of the table and index. To be blunt, the code is incorrect for what it's advertised to do and you could end up deleting incorrect indexes if you use the code as is.

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1325807

Scott D. Jacobson

Posted Friday, July 06, 2012 12:08 PM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 4:28 PM
Points: 335, Visits: 844

Naked Ape (7/5/2011)

Interesting reading. Was that a deliberate reference to Alices Restaurant, Massacre (twenty-eight color graphs with circles and arrows and a paragraph on the bottom of each one)?

Thank you Naked Ape. It took until the 2nd page of posts but I'm glad I wasn't the only one who picked up on the Arlo Guthrie reference.

Post #1326262

« Prev Topic | Next Topic »

43 posts, Page 5 of 5

«««1 2 3 4 5

Permissions