October 28, 2008 at 1:00 pm
We have used SQL Profiler with the Tuning template to create a number of files we've used as input to the DTA tool. We see recommendations to create some new Statistics & Indexes. In both of these there is a 'field' named ESTAdjustment.
For Example:
CREATE STATISTICS [_dta_stat_900914281_2_10] ON [dbo].[ClientTbl]([Name], [ESTAdjustment])
What is ESTAdjustment? It isn't a field in the table.
October 28, 2008 at 1:12 pm
BigSam (10/28/2008)
We have used SQL Profiler with the Tuning template to create a number of files we've used as input to the DTA tool. We see recommendations to create some new Statistics & Indexes. In both of these there is a 'field' named ESTAdjustment.For Example:
CREATE STATISTICS [_dta_stat_900914281_2_10] ON [dbo].[ClientTbl]([Name], [ESTAdjustment])
What is ESTAdjustment? It isn't a field in the table.
You might want to recheck. I have used DTA and I have never had it make up a column name. If I interpret the dta generated name properly, Name is the 2nd column in the table, and ESTAdjustment is the 10th.
October 28, 2008 at 1:18 pm
My bad.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply