SQL Server Performance Forum – Threads Archive
Database Tunig AdvisorSituation 1: Open a trace file with profiler.
Find some query, copy.
Open Managment Studio. New Query, conect to server, paste query.
See execution plan. All ok.
Call Database Tuning Advisor, select database and run. All ok, suppose with new index to implementate. Situation 2: Call Database Tuning Advisor.
Select database, select trace file (same like before), run. Same query than before give the followin error: [Microsoft][SQL Native Client][SQL Server]Invalid object name ‘Cheques’ Cheques is a table belong to database. Futhermore in situation 1, reccomend a non cluster index on Cheques. I’ll try to configure SQL Native Client, no lucky.
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
All postings are provided â€œAS ISâ€ with no warranties for accuracy.