dbTalk Databases Forums  

How to regret tuning?

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss How to regret tuning? in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #31  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: How to regret tuning? - 09-26-2008 , 01:25 PM






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.



Reply With Quote
  #32  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: How to regret tuning? - 09-26-2008 , 01:25 PM






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.



Reply With Quote
  #33  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: How to regret tuning? - 09-26-2008 , 01:25 PM



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.



Reply With Quote
  #34  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: How to regret tuning? - 09-26-2008 , 01:25 PM



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.



Reply With Quote
  #35  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: How to regret tuning? - 09-26-2008 , 01:25 PM



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.



Reply With Quote
  #36  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: How to regret tuning? - 09-26-2008 , 01:25 PM



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.



Reply With Quote
  #37  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: How to regret tuning? - 09-26-2008 , 01:25 PM



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.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.