Viewing 15 posts - 4,021 through 4,035 (of 7,503 total)
did you read the full MS doc on it ?
http://support.microsoft.com/kb/231619
and the docs it refers to ?
February 13, 2009 at 12:27 pm
IMO your connection between primary and mirror isn't stable.
Hence the restoring state from time to time.
If it can form a quorum it will pull over the log entries of the...
February 13, 2009 at 12:20 pm
do you make LOG backups ?
That's the only way to clear the log file entries.
Gail has posted a nice article on this matter.
February 13, 2009 at 12:14 pm
best is to revoke you bosses ddl-admin privileges :hehe:
Many of our devs use that view-GUI because they find it easy, but then again,they don't get to clean up the mess...
February 13, 2009 at 10:52 am
If this is a single shot operation , just to get a little insight, maybe a log-analyser tool can help out. (at least if you have full recovery model).
February 13, 2009 at 6:11 am
My guess is , if you want to know exact figures, you'll have to implement a trigger for insert, update, delete and have a counter per PK value in your...
February 13, 2009 at 4:59 am
keep in mind partitioning is realy an advanced topic !
Books online has very good info and is a must read and try out !
And off course, Kimberlys very good WP:
Microsoft...
February 13, 2009 at 3:57 am
while you are at it ...
I always run the check for data purity after a restore from a lower version of sqlserver.
/*
* To be executed after a db-restore from...
February 13, 2009 at 3:52 am
Actually, I query sys.traces to import the trace file to figure out file extends, ...
There is nomore info for trace id 1 !
No info at all because we are not...
February 13, 2009 at 2:28 am
hopping in very late ....
but maybe this query gets you on the rails ...
Select *
from sys.trace_subclass_values TSV
inner join sys.trace_columns TC
on TC.name = 'objecttype'
...
February 13, 2009 at 1:51 am
My default trace crashed because .... disk is full
2009-02-12 15:44:20.880spid116Trace ID '1' was stopped because of an error. Cause: 0x80070070(There is not enough space on the disk.). Restart the...
February 13, 2009 at 1:37 am
Jack Kennedy (2/12/2009)
..
I managed to copy / past the wrong hyperlink :blush:
Combine your query with this one :
SELECT object_name(i.id)table_name
, i.rows
, i.rowmodctr
, i.name as ixname
, STATS_DATE(i.id, i.indid) as ix_Statistics_Date
...
February 13, 2009 at 12:13 am
IMO it has to do with the original date range you specified.
SQLServer must have decided that set of data might be better served doing it in anoher way than generated...
February 12, 2009 at 11:59 pm
I certainly advise to read Steve's article series 😎
Off course, with sql2005 you can also use ddl-triggers to capture structural changes of tables, view, indexes, sprocs,...
Check out
Monitoring Changes...
February 12, 2009 at 1:39 pm
Oh yes... I should have highlighted "during planned downtime"
February 12, 2009 at 6:58 am
Viewing 15 posts - 4,021 through 4,035 (of 7,503 total)