Viewing 15 posts - 4,021 through 4,035 (of 7,503 total)
I don't think the view designer shows up in the connection info of the spid.
So I guess you cannot restrict its usage.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 13, 2009 at 12:52 pm
did you read the full MS doc on it ?
http://support.microsoft.com/kb/231619
and the docs it refers to ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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.
http://www.sqlservercentral.com/articles/64582/
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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).
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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'
...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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
...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 12, 2009 at 1:39 pm
Viewing 15 posts - 4,021 through 4,035 (of 7,503 total)