Viewing 15 posts - 39,751 through 39,765 (of 49,571 total)
Grant Fritchey (4/15/2009)
GilaMonster (4/15/2009)
April 15, 2009 at 6:07 am
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...
April 15, 2009 at 2:29 am
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...
April 15, 2009 at 2:22 am
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.
April 15, 2009 at 2:21 am
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...
April 15, 2009 at 2:06 am
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...
April 15, 2009 at 1:06 am
Anyone feel up to this?
http://www.sqlservercentral.com/Forums/Topic696402-146-1.aspx
April 15, 2009 at 1:06 am
Bruce W Cassidy (4/14/2009)
[font="Verdana"]I took a lesson from St Lynn. Not sure it will help, but worth a shot.[/font]
I'm not even sure what the question is any longer.
April 14, 2009 at 3:14 pm
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...
April 14, 2009 at 2:33 pm
Lynn Pettis (4/14/2009)
GilaMonster (4/14/2009)
<Sigh>http://www.sqlservercentral.com/Forums/Topic696113-92-1.aspx
Three years experience, asking questions like this? More like 1 month of experience over 36 months.
Hmm, a complete change of tack, along with what looks like...
April 14, 2009 at 2:15 pm
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...
April 14, 2009 at 2:11 pm
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.
April 14, 2009 at 2:01 pm
What are you running and what do you expect to appear?
April 14, 2009 at 2:00 pm
yulichka (4/14/2009)
I copied the the hall message from Activity Monitor
Then check the SQL error log.
April 14, 2009 at 1:58 pm
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic696930-391-1.aspx
April 14, 2009 at 1:57 pm
Viewing 15 posts - 39,751 through 39,765 (of 49,571 total)