SQL Server DTA: Finding Unused Indexes
This is another good feature of DTA. There are lot of different scripts available over internet to find unused indexes, however why not use the SQL Servers very own DTA to …
Read MoreSQL Server Education (by the geeks, for the geeks)
This is another good feature of DTA. There are lot of different scripts available over internet to find unused indexes, however why not use the SQL Servers very own DTA to …
Read MoreThis feature creates a copy of a database to be tuned on a specified test server and runs the tuning process on that test server. The recommendations suggested can then be …
Read More