The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
119 views

Database Tuning Advisor user permissions

I was asked to create an account to use Database Tuning Advisor. I red on technet but I don't understand which permission do I have to give. I tried to login with this new user, but trying to list ...
2
votes
1answer
72 views

Why would an index covering only half of primary key be useful?

We have a primitive junction table to store a many-to-many relation between two other tables, their primary keys being bigint: CREATE TABLE [dbo].[JunctionTable] ( [ID-1] [bigint] NOT NULL, ...
1
vote
1answer
114 views

Database Tuning Advisor Index Recommendations

How does DTA make an index recommendation? What is the technology behind that? If we can use same on our side then we can shorten the whole process of Tuning recommendation: creating trace file ...
3
votes
2answers
508 views

Can I trust the Database Engine Tuning Advisor recommendations?

Our database has become large, and we are trying to optimize performance. Can we follow the recommendations provided by the Database Engine Tuning Advisor by supplying it a .trc file generated with ...
6
votes
3answers
898 views

Dropping Hypothetical Indexes

In the past I thought I'd deleted hypothetical indexes using either a DROP INDEX statement for clustered indexes and DROP STATISTICS statement for non-clustered indexes. I have a database that is ...