Viewing 15 posts - 43,291 through 43,305 (of 49,552 total)
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 6, 2008 at 8:55 am
DBADave (11/5/2008)
BOL provides an example on how to reduce fragmentation on a Heap, but I need to determine how to determine heap fragmentation in 2005.
use index physical stats. For an...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 6, 2008 at 8:47 am
That's a good config you have there. You could probably bump the max to 14 if there's nothing running on the server.
I seldom bother setting the min in SQL...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 5, 2008 at 12:00 pm
Andrew Peterson (11/5/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 5, 2008 at 11:54 am
Check the compat mode of the DB you're running that in. My guess would be that it's in mode 80. Either change the compat mode or run the query from...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 5, 2008 at 11:49 am
Viewing 15 posts - 43,291 through 43,305 (of 49,552 total)