Forum Replies Created
Viewing 15 posts - 6,991 through 7,005 (of 7,498 total)
-
RE: Performance Monitoring of SQL 2000
http://www.sqlservercentral.com/columnists/sjones/performancemonitoringbasiccounters.asp
will put you on track.
- There are # of articles/forumthreads concerning performance monitoring.
this is also very usefull :
http://www.sql-server-performance.com/performance_monitor_tips.asp
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
-
RE: Adding sysdate and user name in the field
create tabel mytable(
mybunch_of_columns ....
, tsInserted datetime not null default getdate()
, UserInserted varchar(50) not null default suser_sname()
) ...
This makes you don't have to change your insert-script because if the columns are not mentioned...
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
-
RE: Moving SQL Logfiles
With Query Analyzer or EM : sp_detatch_db 'yourUserdb'
With explorer move the file to the correct location.
With Query Analyzer or EM : sp_attach_db 'yourUserdb', 'FileLocationAndName.MDF', 'FileLocationAndName.Ldf'
For system databases check http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b224071
Maybe even...
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
-
RE: Change Datatype from CHAR to VARCHAR
Antares686 sead it all
- Figure out the average actual datalength of you char columns.
SELECT avg(datalength(...
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
-
RE: Shrinking SQl 7 database
- how many rows get into a single datapage ?
- you could rebuild the clustering indexes.
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
-
RE: DTS and Agent issue
log on to the server using your sqlagent account and then try to run the package from EM\edit dts package.
You'll get more detailed errorinfo.
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
-
RE: HUGE Transaction Log size after Update Statistics is run
Great to know I'm not the only one that has those concerns
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
-
RE: HUGE Transaction Log size after Update Statistics is run
"...size of the log file and truncates & shrinks it ..."
I hope your DRP can cope with that
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
-
RE: Fixing the memory for SQL Server
We don't use fixed- or max-memory setting on most of our sql2k-servers. Only when experiencing sql-paging, it occurs we put a max-memory on it.
I believe the recomendation to leave 512Mb is...
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
-
RE: HUGE Transaction Log size after Update Statistics is run
that's what I assumed.
Normaly, just the statistics will not cause such log-load.
dbreindex rewrites it all. this log-overhead can be reduced by switching to bulk-logged recovery mode.
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
-
RE: HUGE Transaction Log size after Update Statistics is run
switch to bluk-logging before performing your maintenance !
full-logged it logs everything !
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
-
RE: Insert data ignoring Foreign Key Constrain
take a look at BOL : search for "NOCHECK CONSTRAINT"
alter table myschema.mytable NOCHECK CONSTRAINT myconstraint
don't forget to enable it again when you're done.
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
-
RE: Question of the Day for 01 Jun 2004
correct. Only using EM it will not allow you to do so.
I persume because backups should still be available when failed over
(we...
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
-
RE: Question of the Day for 01 Jun 2004
yep, this time I failed to give the wrong answer
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
-
RE: Question of the Day for 01 Jun 2004
same over here. same remark
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
Viewing 15 posts - 6,991 through 7,005 (of 7,498 total)