Make error "Fatal: Command arguments too long"

Submitted by st on

This bug is reproduced on Delphi 7 and C++Builder 6 at least (probably in later versions too) when starting Borland make utility. Indeed, the message "Fatal: Command arguments too long" and the real problem are as like as chalk and cheese.

Check the length of your PATH variable. In my case the length was > 400 characters. Deleting some paths reduced the length down to 300-350 characters and solve the problem.

Ubuntu on BIOS RAID (fake RAID)

Submitted by st on

I seem that "fake RAID" term is not really corresponding to actual motherboard design. Indeed, I don't see the differences between Marvell RAID controller implanted into my motherboard and my old Silicon Image PCI SATA 4-port card.

However, Ubuntu 14.04 cannot be installed "by default" in both cases. Follow these step-by-step instructions.

Fast inserting a file into a table

Submitted by st on

How to insert fast a file (i.e. binary one) from disk to a SQL Server table?

Certainly the SQL Server account should have a corresponding permissions to access the file on the disk. For example I take the file C:\WINDOWS\system32\oembios.bin having the size about 12 MB. For really big files you'd better switch to the FILESTREAM approach.

SQL: generate date/time series

Submitted by st on

There are many examples of user defined table functions generating the series of dates(times) between two specified values. Usually, in OLAP you can see a table filled by the date/time series, too. Such table avoid to generate the values "on the fly".

However, in some cases you may be unable to use an UDF or a table. Fortunately, "pure SQL" method still works.

Suppose, the start and finish dates are specified as entry parameters. The transact SQL code below generates the series "moth by month".

Pages

Subscribe to Mechanics of software RSS