Analyzing a SQL Database

Analyzing Table Issues

• Tables that are HEAPS (without Clustered Indexes)
• Tables without Primary Keys
  
• Tables where which have identity columns, yet NO Primary Keys defined!
• Tables without NonClustered Indexes
• Foreign Keys without indexes
  
• Tables with Triggers

Indexing

• DTA - Database Tuning Advisor (use with care)
• Missing Indexes

Misc

• Deprecated column types
• Implicit Data Conversions
• Table Row Sizes

Operational Issues

• Index Fragmentation Status
• Page Splits

Running XP in Virtualbox

To run Windows XP efficiently on Virtualbox...

• Use 1 core
• Disable PAE/NX

• Disable IO APIC
• Disable EFI

• Use SATA storage for the drives (you'll need to install drivers for this)

Disable VT-x/AMD-V
Enable Nested Paging
These appear dependent on support for them.

Ref : XP Speed Tips

ORACLE : Sqldeveloper - MSVCR71.DLL was not found

Attempting to start SQLDeveloper on my XP desktop today I was faced with this error. This application failed to start because MSVCR71.dll was not found

I had already installed the Java VM and hence some searching led me to Michel Belor's post on how to resolve the error. His solution is linked below and involves adding a couple of entries to the registry.

SQLDeveloper : MSVCR71.DLL not found error