Quote:
Hi, where do I find the ddl scripts? |
You didn't save them after going through the wizard? Well, if you opt not
to save them, DTA is not going to twist your arm. If you have saved your
database/object creation scripts (e.g. In source control), or have any
backups of the database, then a comparison should be pretty straightforward.
If you don't have either of these things, then maybe it is time you start
thinking about them. Luckily, it should be easy enough to find the ones
that it created, they usually have "DTA" in the name if I recall correctly.
Take a look at SELECT name FROM sys.indexes and see if there are any
patterns in there that seem obvious to you. As Tibor mentioned, if you
allowed DTA to drop existing indexes, then this is where good source control
and/or backups would help.