Some Notes, Some Scripts
These are the noted taken for searching solutions and some scripts to identify the problem
Categories:
Let's assume that you have created separate datafile for non-clustered indexes but you want to check them weather you had created in the right datafile