Ignore it.

Error 208 is Object not found. It's not uncommon for profiler to show 'false' errors due to internal deferred name resolution.

http://blogs.sqlserver.org.au/blogs/greg_linwood/archive/2004/12/16/40.aspx

Update them. If you delete the statistics you're forcing SQL to recreate them when it thinks they're necessary. Doing so could adversely affect an important query.

Use UPDATE STATISTICS rather than...

Since this is SQL 2005, rather use sys.objects and sys.sql_modules

I know I've said that UPDATEUSAGE isn't required (in the discussion of the corruption article), but I don't recall ever saying that stats updates are never required.

If anyone knows...

ALZDBA (4/15/2009)

---

As I learned from Gail Shaw, the issue of outdated statistics with sql2000 caused by the way your data is added/deleted/updated shouldn't be an issue with sql2005 anymore. Its...

Any chance of seeing the estimated execution plan?

My trigger's not generic at all. It's got explicit references to the table and...

Try updating the statistics on that table. Fullscan may be necessary.

No apology was necessary there. Just because one person posts...

It might be in the default trace (set of .trc files in the SQL log directory). If not, then no, it won't be stored anywhere.

It's because SQL's allowed to use a different method of scanning the table (allocation order scan) when the isolation level is read uncommitted. The different method is slightly faster, can...

Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic698243-373-1.aspx

btb1977 (4/15/2009)

---

We did not update the statistics after the upgrade, I've already left for the night and will set up a job to do that...

One question that pops to mind. Did ANSI create ASCII?...

Are the filters always inequality, as you showed in the first post, or will some be equality?