It is not completely a star vs. snowflake choice.

You could have a snowflake schema that is used to maintain the data correctly, but have a star schema based on rollups...

This shows what is happening:

select

BeforeNoon= cast(convert(datetime,'20100622 11:59:59.997') as numeric),

AfterNoon= cast(convert(datetime,'20100622 12:00:00.000') as numeric)

Results:

BeforeNoon AfterNoon ...

No one is perfect. The most impotent thing for anyone developing code is to test your code completely to make sure it does what you expect.

select

a.COLUMN_NAME_1,

b.COLUMN_NAME_2

from

TABLE_1 a

join

TABLE_2 b

on a.TABLE_1_ID = b.TABLE_1_ID

order by

a.COLUMN_NAME_1,

b.COLUMN_NAME_2

There, was that so hard?

Good developers produce easy to read, easy to follow code. Bad developers produce unreadable, hard to follow code. ...

Patrick Seegers (6/9/2010)

---

[font="Courier New"]Hello,

I have found storing the date as an integer to be useful as an integer surrogate key to a date dimension table with attributes you can not...

They will be populated with...

Use the DATETIME2 datatype in SQL Server 2008.

If SQL Server is conveting a string to DATETIME, there are only 2 unambiguous formats that SQL Server will always parse correctly:

'YYYYMMDD HH:MM:SS:mmm', example: '20100617 15:46:59.997'

'YYYY-MM-DDTHH:MM:SS:mmm', example: '2010-06-17T15:46:59.997'

Any other format...

When you negotiate, you have to make sure you're talking to someone who can actually say yes.

If they told you boss that he can't approve raises, then he doesn't have...

It doesn’t sound like you’re getting the run-around any more, just news you didn’t want to hear.

The first rule of negotiations is to continue working towards a deal. Even...

Transaction logs on a USB drive? That's got to be one of the worst ideas ever.

If you really have to use one, use it for your backups.

Wayne West (6/13/2010)

---

There's a reason why I like also having the old Query Analyzer from SS2000 still around, I just wonder how much longer it will work with future versions...

Just because you enjoy something doesn’t mean you should do it for a living. Work has a way of making things not fun.

For many years, photography was my hobby....

When you have critical servers down, the importance of a DBA becomes obvious.

We have around 500+ database servers and thousands of databases spread across many locations, so hoping for the...

PaulB-TheOneAndOnly (5/20/2010)

---

That's not true. There is a Microsoft published...