Tag Archives: Indexes

Oracle: Error ORA-00955 name is already used by an existing object

Sometimes things just won’t work as expected. You know, programming has its quirks and the like. Normally this error alone would mean you are creating some object with a name that is already in use. But what if you just … Continue reading

Posted in Oracle | Tagged , , , , , | Leave a comment

SQL: Difference between Collations

Collations define the order that string data will be stored and how they will be compared on join/where conditions. If you try to compare two columns with different collations you may received the below error message. This may happen when … Continue reading

Posted in SQLServer | Tagged , , | Leave a comment

Unused Indexes Size

Today I had to quickly find which indexes are not used on a database and the size of each one. Because of the hurry, I just googled a little and found two scripts with parts of the solution. I simply … Continue reading

Posted in SQLServer | Tagged , , , | Leave a comment

Sharing knowledge: Index Defrag Script

This is one of the things I love about being a DBA: we¬†like to share what we know. I always try to teach people who work with me some things about how a database works, and a lot of other … Continue reading

Posted in SQLServer | Tagged , , , , , , | 1 Comment