Viewing 15 posts - 1,831 through 1,845 (of 7,502 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,...
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...
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. ...
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...
July 22, 2011 at 2:11 am
rathod.balu (7/21/2011)
Could you please elaborate as for whr i am going worng...
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...
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...
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...
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. ...
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
...
July 21, 2011 at 6:42 am
zapouk (7/21/2011)
I could use...
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...
July 21, 2011 at 4:29 am
Welsh Corgi (7/20/2011)
airparkroad (7/20/2011)
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...
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.
July 21, 2011 at 2:23 am
Viewing 15 posts - 1,831 through 1,845 (of 7,502 total)