Viewing 15 posts - 43,306 through 43,320 (of 49,571 total)
Post it on Connect. Make sure you've applied the latest service pack and CU before you do so, so that you know that it hasn't already been fixed.
November 6, 2008 at 11:45 am
Dinendra Nath Dolai (11/5/2008)
November 6, 2008 at 11:42 am
Check the scripts library here, there are lots and lots of variations floating around
November 6, 2008 at 11:40 am
Matt Miller (11/6/2008)
Is there not going to be a Dev edition for 2008?
It exists. I'm running 2 installations of it. Though I got mine from MSDN and I don't...
November 6, 2008 at 11:39 am
TRACEY (11/6/2008)
What report do you run to get the tables with the out of stats on them.Cheers.
There's no report that can tell you that the stats are sufficiently inaccurate to...
November 6, 2008 at 11:30 am
TRACEY (11/6/2008)
Do you have it set on all your Databases ..(auto sync)...and i take it you never have to run this UPDATE STATISTICS ever..
Yes and no. I've found some cases...
November 6, 2008 at 9:38 am
If you use nolock (or any locking hint for that matter) in a query it will apply only to that query and only to the table that the hint directly...
November 6, 2008 at 9:27 am
TRACEY (11/6/2008)
Do you mean why do you turn it off on the database....the option of the auto update statistics asynchronously
I mean why disable the auto updating of stats, either at...
November 6, 2008 at 9:23 am
Jayakumar Krishnan (11/5/2008)
"The file system structure on the disk is corrupt and unusable. Please run the chkdsk utility on the volume M$."
Yeah, that'll cause a few problems. :hehe:
Glad you're sorted.
November 6, 2008 at 9:12 am
All update usage does is fix any incorrect space measurements in the metadata. 2000 does sometimes get that wrong (leading to fun things like databases with -10% free), but I...
November 6, 2008 at 9:11 am
rlondon (11/5/2008)
Gail everything I needed to know about transaction logs I learned from reading your posts. 😀
😀 Thank you. i assume you saw the headline article here last...
November 6, 2008 at 9:09 am
I'll do a proper announcement as soon as I get home. Currently in DBN on business.
But just for you... 😀
Fri 28 Nov (I know fri night isn't good, but...
November 6, 2008 at 9:08 am
The_SQL_DBA (11/6/2008)
UPDATE STATISTICS DaveTable(anames)WITH FULLSCAN, NORECOMPUTE
GO
Why the norecompute? Turning off auto update on a stats set is a stupid thing to do unless you are regularly updating...
November 6, 2008 at 8:58 am
balbirsinghsodhi (11/5/2008)
Do you think, I should drop to maxdop to 6 or 1.
Try 4 and see how it goes.
November 6, 2008 at 8:56 am
Sure they can. Encryption is not designed to protect the mdf file (secure your server), not is it mean to protect against the DBA (If you don't trust your DBA,...
November 6, 2008 at 8:55 am
Viewing 15 posts - 43,306 through 43,320 (of 49,571 total)