Viewing 15 posts - 5,026 through 5,040 (of 7,499 total)
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
Good old BOL did it again, thanks for the rectification.
Here's a little test script I've found back from my test (sql7)
Just to demonstrate simple working of it.
/****** 🙂 best regards...
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 25, 2008 at 9:38 am
did you check this ad-clr forum thread ?
http://www.sqlservercentral.com/Forums/Topic452981-386-1.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 25, 2008 at 4:10 am
Did you check common table expressions (CTE) ?
This has recursive capacities.
There are some nice examples at SSC, as well as performance articles regarding CTE and the alternatives.
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 25, 2008 at 4:08 am
AFAIK: No.
Locking is also dependant on the type of connection isolation level or command isolation level you are using. Hence, no info regarding execution plan.
However, you can launch sql profiler...
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 25, 2008 at 4:05 am
did you check Jeff's concatenation article ?
http://www.sqlservercentral.com/articles/Test+Data/61572/
If not, you realy should 😉
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 24, 2008 at 4:58 pm
If these rows make up your entire table, use truncate and you log will not grow.
Truncate will not work if your table is parent table for others.
Otherwise you may want...
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 24, 2008 at 4:52 pm
- xp_cmdshell needs to be enabled if you want to use it.
SAC or sp_configure will show 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
March 24, 2008 at 5:41 am
Viewing 15 posts - 5,026 through 5,040 (of 7,499 total)