Viewing 15 posts - 1,831 through 1,845 (of 7,499 total)
one option could be to switch to Ola Hallengrens more intelligent rebuild solution script at http://ola.hallengren.com/ in stead of a classic maintenance plan. (there are also alike scripts at SSC,...
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
July 23, 2011 at 1:57 pm
opc.three (7/22/2011)
ALZDBA (7/22/2011)
You know I'm on my powershell learning curve, so that's what came out of my sleeves :hehe:
Granted, the OP could get the job done with CmdShell using COPY...
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
July 22, 2011 at 7:33 am
Jeff Moden (7/22/2011)
ALZDBA (7/22/2011)[hrOf course there is nothing wrong with yea good old DOS ..... in a sqlagent job please.
Not in the in-transaction-code !
I have to disagree there. ...
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
July 22, 2011 at 7:11 am
I suggest to follow Grants advise.
If you are building an OLTP database, one should analyse the data to get at least to 3NF and only then consider applying less...
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
July 22, 2011 at 2:11 am
rathod.balu (7/21/2011)
Could you please elaborate as for whr i am going worng...
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
July 22, 2011 at 12:22 am
Jeff Moden (7/21/2011)
ALZDBA (7/19/2011)
Welsh Corgi (7/18/2011)
There was a post on SSC of an example of the file copy using Powershell about a week ago.
# copy all jpg files from c:\temp...
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
July 22, 2011 at 12:08 am
Faye Fouladi (7/21/2011)
this problem was posted long time ago. I no longer work on this project, therefore, I cannot test it.
Oops, I didn't see the original date is somewhere 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
July 21, 2011 at 12:19 pm
opc.three (7/21/2011)
abdielmomo (7/21/2011)
In fact, I want to copy files from one folder to another when a new row is inserted in a table.
If you are saying that you want 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
July 21, 2011 at 12:17 pm
Although I strongly support Grants reply, I must admit for some subsystems we actually use that kind of column naming conventions to supposed handle dynamic queries for SCADA systems. ...
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
July 21, 2011 at 7:04 am
There is an Inner join with a outer joined object, so the inner join on NULL may be your issue .
Inner Join dbo.tblContracts C
...
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
July 21, 2011 at 6:42 am
zapouk (7/21/2011)
I could use...
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
July 21, 2011 at 6:33 am
Bhuvnesh (7/21/2011)
ALZDBA (7/21/2011)
- are your cpu-cores dedicated or do all instances compete for all cores ?
we dont have dedicated CPUs
ALZDBA (7/21/2011)
- what kind of io system / layout is 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
July 21, 2011 at 4:29 am
Welsh Corgi (7/20/2011)
airparkroad (7/20/2011)
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
July 21, 2011 at 2:45 am
Maybe this can be a starting point:
- are your cpu-cores dedicated or do all instances compete for all cores ?
- what kind of io system / layout is in use...
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
July 21, 2011 at 2:38 am
Books online has it all : http://msdn.microsoft.com/en-us/library/ms186299.aspx
Your assumptions are correct.
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
July 21, 2011 at 2:23 am
Viewing 15 posts - 1,831 through 1,845 (of 7,499 total)