Another approach:

Let's check for Friday, which is bit 7, I presume (I have no clue, check out in the Books online)

Bitmap is: 0000 0010

Integer value is: 2

AND the bitmap field...

RTFM.

Use test conditions described in article "Using bits to Store Data".

What??

Now THIS is good news, I'm building an ETL process here in which I'll process flags with the bitmap technique described in the...

Very cool! Extremely useful article about architecture to use bit operations!

In my case, I could use this to simulate bitmap indexes.

Regards,

Geert

Your update statement does not contain any WHERE condition.

Usually, users tend to think something is performant the moment they perceive they can do their job without waiting for the machine.

Intermediate improvements will only render them more polite towards...

Thanks!

As the Smalldatetime field is as large as an integer with YYYYMMDD format, we'll go for the smalldatetime as the natural key.

A surrogate key should be arbitrary, but we won't...

SQL server 2000 has the Business Intelligence Accelerator, it uses Analysis services.

For ad-hoc reporting, best to look for a report writer such as Businessobjects, Cognos, Corvu and others

The time dimension table contains a Datetime field, but it's a mere attribute.

I have no idea if an index is more performant on a 4 byte field than on an...

Yes, we do.

Our data is on daily basis, we do not need the time part in our queries.

A Datetimefield is 8 bytes, whereas an integer field containing YYYYMMDD format is...

Or Excel dumps

Using ISO dates is indeed the best solution, but for some reason I have never met such a standardization in real-life situations.

The SET LANGUAGE option is superb because many exports...

Adding Timestamp columns to your source database is even better.

A timestamp is a unique binary value over the whole database. It increments with 1 bit each time you insert or...

You can launch:

INSERT INTO table

(A, B)

SELECT Excel.A, Excel.B

FROM Excel

WHERE NOT EXISTS

(SELECT 1

FROM table

...

ORACLE gives unique rowID's to SQL result sets, the author is right to point out that this is really cool.

For this question, however, SQL server allows very elegant solutions.

To get...