DateTime in C++

Submitted by Serguei_Tarassov on Sat, 04/12/2010 - 13:48

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:

Programming

Indexing columns of bit type

Submitted by Serguei_Tarassov on Wed, 24/11/2010 - 20:06

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.

Programming

SQL Server

Dynamic result ordering in SQL

Submitted by Serguei_Tarassov on Tue, 18/05/2010 - 17:19

There are several methods to implement the dynamic ordering of result returned by SQL query. The examples of stored procedures below use the Microsoft's demo database AdventureWorks.