I'm glad to confirm that occasionally bought HP webcam HD 2300 is compatible with Linux Ubuntu 10.04 and 12.04. The webcam design is perfect IMHO, the price in Europe (France) is moderate (about 25 euros on retailers like Darty). Good news to linux users.

For testing webcam install and run cheese program
sudo apt-get install cheese

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.

How to delete the rows having the duplicated values of one or more columns and considered as duplicates? The example in Transact SQL is below.

Many years ago we had a need to manipulate the data of types "date" and "time" (DateTime in C# and Delphi/C++Builder). I had developed the corresponding class for these purposes.

Here is the interface with comments:

Clearly, an index build on only one column of the bit type is useless because the selectivity is poor (50% of a table in average). However, when a table has several columns of the bit type, the composite index may be efficient.

For the test example, we'll create a table and fill it with random data.