Viewing 15 posts - 5,221 through 5,235 (of 7,499 total)
maybe 😉
We schedule index rebuilds on most of our server on a weekly basis.
(during low usage hours)
On some servers it is scheduled every day because we are not allowed
to change...
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
February 12, 2008 at 1:00 pm
- can you provide some sqlserver version info ? (+ sp + cu )
- how much memory is available for sqlserver ?
- did you set a min or max memory...
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
February 12, 2008 at 12:53 pm
check out the nice art :http://www.sqlservercentral.com/columnists/chawkins/dedupingdatainsqlserver2005.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
February 12, 2008 at 12:48 pm
with sql2005 you nee to enable xp_cmdshell !
This is not advized !
You'd be better off by shifting this action to a sqlagent job,
and run that job with a proxy...
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
February 12, 2008 at 12:21 pm
how about using the dts.events.FireError in your script ?
Keep in mind you 'll also need to enable the "FailPackageOnFailure" property.
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
February 12, 2008 at 12:16 pm
you may want to set the deadlockpriority for your job to low:
SET DEADLOCKPRIORITY LOW
So if a job is canceled, it will be yours.
Best is to start a trace (sql...
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
February 12, 2008 at 11:00 am
You need the same space volume as the original MDF, ndf and LDF files !
If they were allocated e.g. mdf 50Gb and ldf 10G , even if you only 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
February 12, 2008 at 10:47 am
This is concerning SQL2005 right ?
You may want to check on these new join methodes:
EXCEPT and INTERSECT
http://msdn2.microsoft.com/en-us/library/ms188055.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
February 11, 2008 at 12:30 pm
Hi Andy,
Thank you for the script.
It's this kind of "simple" scripts that make this site such a great resource !
Can you post it in the contribution center ?
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
February 11, 2008 at 12:21 pm
If I'm correct there is a SSMS setting that is used 'show system objects'
For the moment I don't have SSMS available, but I guess BOL will have a ref for...
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
February 11, 2008 at 11:49 am
You can also find very valuable input in this thread
http://www.sqlservercentral.com/Forums/FindPost453679.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
February 11, 2008 at 7:46 am
I've just used it for testing purposes to get a feeling with as well CLR as
geocoding.
I didn't compare the various providers.
Maybe others did or are using it 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
February 11, 2008 at 7:41 am
Jeff Moden (2/10/2008)
..Some of the best drivers are also some of the best mechanics...
All race pilots must know the gobbledegook to direct their technicians to
figure out the solution to...
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
February 11, 2008 at 7:02 am
Thanks Jeff for adding this little - but oh so crucial remark :w00t:
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
February 11, 2008 at 6:35 am
Excuse me for the very late response :blush:
Kind of lost track of this thread.
This drive mapping should loke something like this
NET USE * \\TheOtherServer\TheSharename Password /USER:Thedomainname\TheOtherusername /PERSISTENT:NO
xcopy c:\myfile.txt \\TheOtherServer\TheSharename
NET...
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
February 11, 2008 at 5:29 am
Viewing 15 posts - 5,221 through 5,235 (of 7,499 total)