October 7, 2008 at 1:11 pm
Lynn Pettis (10/7/2008)
Okay, off topic but I need to ask. Where did you purchase your copy of SQL Server 2008 Developer Edition, and how long did it take for you to get it?
MSDN. I had it downloaded 3 days after release. 😀 😎
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2008 at 1:19 pm
I'm poor and don't have an MSDN subscription, so I pay "retail" for the developer edition.
😎
October 7, 2008 at 1:28 pm
Grant Fritchey (10/7/2008)
It's on Connect. If you want to confirm it or track it, go here.
I would, but there seems to be a bug with connect. I can only see the page while logged out. When I log in it gives me a 'page not found or insufficient permission' error. Of course, I can only rate/confirm/track when logged in.
Will try tomorrow.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2008 at 1:31 pm
Lynn Pettis (10/7/2008)
I'm poor and don't have an MSDN subscription, so I pay "retail" for the developer edition.😎
Oh I didn't buy an MSDN subscription. No way I could afford that personally.
MVPs get a premium subscription free for 1 year.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 8, 2008 at 1:29 pm
I finally got one reply over in the Microsoft forum. Buck Woody, Microsofts SQL Server Program Manager, thinks it might be a bug. If anyone can replicate it, please go to Connect and validate the entry. If you can demonstrate a successful recommendation through the DTA in 2008, I'd love to hear about it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 17, 2008 at 11:44 am
Ok, I finally bit the bullet and removed the pre-release version and installed the RTM version of Developer and, I was able to get a recommendation. Again, not a good one, certainly not as good as SSMS came up with when looking at the execution plan. Without further ado....
CREATE NONCLUSTERED INDEX [_dta_index_SalesOrderHeader_6_722101613__K23_1] ON [Sales].[SalesOrderHeader]
(
[Freight] ASC
)
INCLUDE ( [SalesOrderID]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
I do not have CU1 installed, not sure if you do. Just the RTM version.
Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
One other note, the AdventureWorks database that I am using was upgraded from 2005. Can't believe that would make a difference but thought I would throw it out to muddy the waters anyway. 🙂
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 17, 2008 at 12:07 pm
Interesting.
What query or queries did you run against it to get a recommendation?
I can't imagine that the database would matter, but the one I'm using is the 2008 version of AdventureWorks (it includes filestream objects & other stuff).
Thanks for the follow-up.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 17, 2008 at 12:16 pm
Your query from the earlier post.
I am going to be putting the 2008 Adventure Works up shortly, couldn't do it with my previous version as the database was newer than the instance so I had upgraded the 2005 version. I'll let you know if it makes a difference.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 17, 2008 at 12:26 pm
It's the database. That is really annoying. I can't even begin to think why a change to the newer version of the sample database would make the difference in how DTA interprets the necessity of an index. Sad, scary and shocked....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 17, 2008 at 12:30 pm
Still, that's information. I'll set up a test database over the weekend and try a couple of things.
I have to wonder why on earth it would matter...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 10 posts - 16 through 24 (of 24 total)
You must be logged in to reply to this topic. Login to reply