Forum Replies Created
Viewing 15 posts - 5,746 through 5,760 (of 7,506 total)
-
RE: EMAIL SQLServerAgent Mail but not SQLMail
- Are the service accounts the same for sqlagent and sqlserver ?
- we use smtp-mail so we don't depend on all the hassle with the outlook client. you can check it...
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: Foreign Key/Primary Key GRRR!
That's a big 10-4
During pre-aggregate phase, the fk-indexes will speed up the queries wherever possible. The relationships themselves indeed can be dropped.
Keep in...
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: Transaction log not clearing out
another nice ref regarding impact of shrink operations :
http://www.karaszi.com/SQLServer/info_dont_shrink.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: Shutting down SQL servers
there are serveral ways to shutdown sqlserver:
- service manager
- TSQL : Shutdown
- net stop sqlserver
- EM rightclick servername / stop
They all shutdown sqlserver.
If there are open transactions going on (They...
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: Foreign Key/Primary Key GRRR!
... Is it necessary to maintain the production relationships in the first place ...
- maybe not the actual FK's , but certainly keep the FK-indexes because They will speed up queries...
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: Server consolidation and instances (or not??)
- there are # articles at SSC and sql-server-performance.com
- Keep in mind you need to determine criteria for databases to be hosted in an instance.
e.g.
- how/when will you be...
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: Foreign Key/Primary Key GRRR!
maybe this script can help you a bit :
I used it to convert primary keys to be clustered.
So just exclude the drop/create primary key part and off you go...
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: Filegroup on the SAN...
maybe this can help a bit ...
http://www.sql-server-performance.com/ew_san.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: Transaction log not clearing out
... forgve me ...
No problem. The goal of this usergroup is to help each other
AFAIK they do behave the same for sql7 and...
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: Transaction log not clearing out
aha, the mystics of dbcc opentran
We learn every day ....
"Learn to play ..... play to learn"
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: Transaction log not clearing out
the sqlserver logfile is used with active chunks.
The log-file(s) can only be shrinked up to the point where the active chunk ends. It that is the beginning of the logfile,...
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: xp_sendmail
fortunatly it happened on servers that could be rebooted at least every weekend, so if the problem occured, we planned a reboot asap.
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: xp_sendmail
Is this on a clustered server ? (xp_sendmail is not supported on a cluster)
We've also had this kind of issues with xp_sendmail and are now using smtp-mail (check Gert Drapers...
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: Transaction log not clearing out
you may need to repeat the procedure until it shrinks.
http://www.support.microsoft.com/kb/256650
-- select db_name()
-- select * from sysfiles
USE Your_Database_Name -- This is the name of the database for which the log...
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: Update systemtables in 2005
upgrade ??
according to bol sys.sysfulltextcatalogs is for backward compatibility only.
Did you check sys.fulltext_catalogs ?
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 - 5,746 through 5,760 (of 7,506 total)