Viewing 15 posts - 5,026 through 5,040 (of 7,506 total)
first of all you'll need sql2000 enterprise edition !
This is the ref I always use : http://www.sql-server-performance.com/articles/per/awe_memory_sql2000_p1.aspx
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
March 28, 2008 at 2:07 pm
- Did you take a look at log-shipping ?
- or work with full backup once a week and the other days restore the db and apply (the smaller)...
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
March 28, 2008 at 2:03 pm
Can you find anything in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap
Take a look at the logfiles of your install processes (even if they seem cryptic).
And make sure you're connected to 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
March 28, 2008 at 1:57 pm
Actualy , today I had contact with MS, and it turned out to be a flaw in SP_Helpuser (since SQL2000 RTM)
SP_helpuser calls sp_helpgroup wich truncates this to 25 chars.
If you...
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
March 28, 2008 at 7:18 am
GilaMonster (3/27/2008)
Read committed is the default isolation level for SQL Server. There's no need to set it explicitly....
Well, you know how it goes with defaults , someone may have tampered...
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
March 28, 2008 at 12:52 am
Thank your for the corroboration. I was feeling very alone 😉
Indeed, you cannot do a thing about it, but open a case at MS (because it actualy IS a flaw)...
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
March 28, 2008 at 12:49 am
If volume is increasing, desing flaws may escalate !
is this select * executed from Query analyser or are they using a cursor to walk throug it ?? :ermm:
- You may...
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
March 27, 2008 at 9:03 am
how about this one
-- jobi dd 08/12/2003
-- verplaatsen backupdevices
use master
Declare @DevNameSuffix varchar(10)
Declare @OldPath varchar(500)
Declare @NewPath varchar(500)
select @DevNameSuffix = 'Log'
, @OldPath = 'T:\MSSQL\BACKUP\'
, @NewPath = 'T:\MSSQL\BACKUP\IncLogBackup\'
-- select ...
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
March 27, 2008 at 8:45 am
- how often do you rebuild indexes on your db ?
bad indexes result in IO overhead resulting in longer need for locks.
IO is the slowest part...
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
March 27, 2008 at 8:38 am
Balmukund Lakhani (3/27/2008)
This report picks...
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
March 27, 2008 at 8:33 am
I assume someone dropped the database using Management Studio.
It has a default do delete all backup info as well.
AFAIK, you still need to delete the backup files manualy.
So have a...
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
March 27, 2008 at 8:28 am
If your date columns are defined datetime you're OK with this proc.
create proc usp_thedeletes
as
begin
set nocount on
delete
from yourtable
where datediff(d, From_Date, To_Date) > 30
end
Else, don't come complaining that 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
March 27, 2008 at 1:54 am
You are performing a RESTORE operation, meaning you put back a copy of the database.
If that copy has been produced when the database was in autoclose mode, that's the reason...
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
March 27, 2008 at 1:13 am
george sibbald (3/21/2008)
ALZDBA (johan?)....
Yep, Johan is my name, ALZDBA the SSC username.
And IMO for me it is way to late to alter it to Johan because of the many "name"...
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
March 26, 2008 at 2:58 am
balbirsinghsodhi (3/25/2008)
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
March 26, 2008 at 2:43 am
Viewing 15 posts - 5,026 through 5,040 (of 7,506 total)