Re: Profiler execution warning not document

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Brandon Lilly (avarice_at_nospam_swbell.net)
Date: 02/26/04 

Date: Thu, 26 Feb 2004 10:47:14 -0600

"Erland Sommarskog" <sommar@algonet.se> wrote in message
news:Xns949B7A74E5A5FYazorman@127.0.0.1...
> The 3 means there is indexed view loaded, and the interger data means
> the number of loaded indexed views.

I don't understand what this has to do with a query that I am running. The
query selects from a single view (which is NOT indexed) and that view does
not reference any other views.

If the views have nothing to do with my query, then why is SQL Server
bothering me with an execution warning just to say "hey, thought you should
know that you have 7 indexed views in memory"

Is this warning a bad thing, indicating some possible problem?

Thanks,

Brandon

Relevant Pages

  • Re: sorting twice?!
    ... So I run a query to select the top 20 when ordered by datemodified ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Format a datetime columns output?
    ... Erland Sommarskog wrote: ... You can also do it in an SQL query, look up CASE and CONVERT in Books ... string that looks like a date. ... State what version of SQL Server you are using and specify the content ...
    (comp.databases.ms-sqlserver)
  • Re: Profiler execution warning not document
    ... > I don't understand what this has to do with a query that I am running. ... > bothering me with an execution warning just to say "hey, ... you told me to utilize the table itself ...
    (microsoft.public.sqlserver.programming)
  • Re: error: Cursor not returned from query
    ... Erland Sommarskog wrote: ... During my test I have created the following query. ... I would suspect that it's some data layer (such as ADO, ADO.NET, DAO, ... ADO.NET has ExecuteReader and ExecuteNonQuery methods on ...
    (comp.databases.ms-sqlserver)
  • Re: Profiler execution warning not document
    ... > I don't understand what this has to do with a query that I am running. ... > If the views have nothing to do with my query, then why is SQL Server ... > bothering me with an execution warning just to say "hey, ... Books Online for SQL Server SP3 at ...
    (microsoft.public.sqlserver.programming)