Viewing 15 posts - 3,526 through 3,540 (of 7,499 total)
- With x64 you should always set your max memory config for each instance or they may eat up all your memory !
- Are the 3 SQLServer instances the only...
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
August 24, 2009 at 2:20 am
Indeed ... some times we overlook the obvious. :hehe: ( been there .. done that 😀 )
Happy mirroring 😉
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
August 24, 2009 at 12:56 am
helpmhost (8/23/2009)
Thanks for all the replies.Yes we have set autogrowth by MB and by very large amounts.
Lower the autogrowth number of MB !
Seems to me your OS is having...
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
August 23, 2009 at 11:54 pm
good point, Steve.
Or more than one file in the filegroup. SQLServer is supposed to be able to balance the data over all files of a single filegroup, so in 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
August 23, 2009 at 9:40 am
- You can indeed switch your sqlserver instance to "audit login all", that will insert a row for every logon attempt in the sqlserver instance Errorlog file.
Off course you'll have...
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
August 23, 2009 at 8:21 am
To the OP: another not so recent SSC member, working on the Fora2009 rudiness program ? :sick:
btw, did you try it like the good old msaccess worked around your problem...
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
August 23, 2009 at 6:39 am
You have already received the eplication ...
I would always prefer the JOIN syntax, because that has the nicest separation of Join predicate(s) and Where caulse conditions.
So these JOIN syntaxed 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
August 23, 2009 at 6:28 am
Check the autogrowth of your database files !
If it is in percentages, it would be better to switch it to extend in MB !
(e.g. per 100 or 500 MB, depending...
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
August 23, 2009 at 6:23 am
- another alternative is to just copy that table into another database and create a full backup of that db.
I would not suggest to do it this way all 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
August 23, 2009 at 6:18 am
hmm .... problems doing a os level file move ?? .... scary !!:unsure:
here's an article regarding moving database files...
http://www.mssqltips.com/tip.asp?tip=1604
Be sure you know what you do or you may get into...
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
August 21, 2009 at 1:44 pm
Krasavita (8/21/2009)
Physically move the files and full-text catalogues of the database. Is this mean That I have to do ctrl X...
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
August 21, 2009 at 8:10 am
Krasavita (8/21/2009)
USE masterGO
ALTER DATABASE dbname
MODIFY FILE (NAME = logical_name, FILENAME = ‘new_path\os_file_name’)
GO
What is logical_name mean?
If you excute sp_helpfile in a database you get to see the logical filename and 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
August 21, 2009 at 8:02 am
I would go for the solution Perry Whittle provided.
Use the alter database methode because this will always have you db defined at your sqlinstance, it will also keep all security...
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
August 21, 2009 at 6:40 am
Very nice way to tackle the issue of hardware replacement !
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
August 18, 2009 at 3:44 am
Thank you for this valuable feedback !
Keep in mind trace flag 4621 is only available with SP3
and is only advised if the combination of trace flags 4618 and 4610...
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
August 18, 2009 at 12:58 am
Viewing 15 posts - 3,526 through 3,540 (of 7,499 total)