Viewing 15 posts - 1,831 through 1,845 (of 7,498 total)
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
IMO your code table should have the combination of the two _db_id columns as primary key (or a *_db_id of its own and an unique constraint on the combination of...
July 20, 2011 at 10:46 am
the object tree shows you the name as you registered it in your registered servers - if you connected using them.
Another reason could be you/someone declared a server alias at...
July 20, 2011 at 10:08 am
sqlapprentice (7/20/2011)
ALZDBA (7/20/2011)
S is a physical drive on the box and not a connected drive ?strange .... verry strange
By 'connected', you mean SAN?
Mount points are administered in my company by...
July 20, 2011 at 9:55 am
Viewing 15 posts - 1,831 through 1,845 (of 7,498 total)