Viewing 12 posts - 1 through 12 (of 12 total)
Yelena,
Forgive my ignorance of Windows admin as I have just moved over from a Unix environment.
Where is the "Current activity" windows? Is this another name for one of the screens...
July 11, 2005 at 9:25 am
Thanks Steve.
What is CDP by the way?
Tom.
June 3, 2005 at 9:04 am
Both SQL 7.0 and 2000 on different physical servers.
I've just moved over from Sybase to SQL Server recently so my use of "dump" is related to that.
Tom.
May 23, 2005 at 5:12 am
Thanks for the advice. That is what we have more or less decided to do here. We have a full 24 hours of down time to do all the optimisations...
May 23, 2005 at 4:46 am
It was being use to log logins and access to various tables as a stopgap measure for SOX compliance until we get a proper tool. One is being investigated, but...
May 20, 2005 at 5:50 am
Thanks for the clarifications Chris.
Tom.
May 18, 2005 at 1:26 am
I've never used the "update statistics" command beyond just that.
How do I ensure that it samples all the rows in the table?
Tom.
May 17, 2005 at 2:05 pm
I had a sending failure, so if this appears twice please ignore the repeat.
I should have stated 3 more carefully. Yes, I am allowing for the recompile to happen the...
May 17, 2005 at 9:25 am
The sysindex.rowcnt field is of type binary.
How do I convert that to a human readable value?
Tom.
May 13, 2005 at 9:01 am
Thanks.
Tom.
May 13, 2005 at 6:32 am
How inaccurate are we talking about?
Off by +/- 10 to 20% of actual table rowcount?
Does it depend on how recently your indexes have been optimised?
Can you send me a...
May 13, 2005 at 5:37 am
Can the filters be set up directly as queries?
Is there a free form entry box for queries?
Tom.
May 10, 2005 at 2:03 am
Viewing 12 posts - 1 through 12 (of 12 total)