Forum Replies Created
Viewing 15 posts - 5,746 through 5,760 (of 7,502 total)
-
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
-
RE: (Very Urgent) SP Takes time & TSQL Statements Runs fast in Query Analyzer
just to add ...
if you're using parameters in your (dynamic) queries, make sure they match the datatype and length of the corresponding columns in the tables !
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: Upgrade sql server 2000 to 2005 on VMWare
- first of all run the SQL server 2005 upgrade advisor (the is an article on it at SQL Server 2005 Upgrade Advisor 
-...
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: table with few bln records is not being properly reflected in sysindex
I always use DBCC updateusage ('myDatabase') with count_rows
and I run sp_updatestats afterward.
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: Upgrade sql server 2000 to 2005 on VMWare
1) what kind of problems did you experience ? (did you sql-backup the old db and restore it at the new server ?
2) Users are restored if you restored masterdb....
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,502 total)