Grant Fritchey (4/15/2009)

---

GilaMonster (4/15/2009)

---

Well, SQL does support the ASCII standard for storing character data (char and varchar) and it supports some of the ANSI SQL standards (of multiple different years),...

Plus index rebuilds update statistics, so if you have regular complete index rebuilds that may take care of the stats.

Honestly, on systems that I've maintained, I've only seen two tables...

It may not be just view vs procedure. It may be that the second query the data was in cache and hence didn't have to be fetched from disk. To...

SQL does update statistics automatically. It's when that it switched off, or doesn't happen often enough that you have to manually update the stats.

Well, SQL does support the ASCII standard for storing character data (char and varchar) and it supports some of the ANSI SQL standards (of multiple different years), so you could...

Let me guess, you're posting XML? Any angle brackets get eaten by the forum software. You need to replace < with &_lt_; (remove the _) and > with &_gt_;

No need...

Anyone feel up to this?

http://www.sqlservercentral.com/Forums/Topic696402-146-1.aspx

I'm not even sure what the question is any longer.

There are lots and lots of 'involuntary' DBAs who started out knowing nothing and managed. I'd much rather help him learn how to manage the server (if he's interested) than...

Hmm, a complete change of tack, along with what looks like...

If you'd said that in the first post it would have saved a lot of wasted time.

Now, knowing that we're helping you prove to someone that he can't do the...

http://www.sqlservercentral.com/Forums/Topic447796-4-1.aspx

Rank is purely due to the number of points. Points are gained by posting or by answering the Question of the Day correctly.

What are you running and what do you expect to appear?

Then check the SQL error log.

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