It isn't as simple as that Remi.  Let's say you split the data out into Year, Month, and Day columns, we already know that in some cases one or more...

I wouldn't count on the naming to be consistent using this method.  If you need the names to be consistent and predictable, you will need to come up with a...

The fundamental problem with ANY kind of NULL scheme is that a record in a table (at least a relational table) represents an assertion of fact.  It is impossible to...

Sounds like a security issue to me.  Are you using a Windows account or a SQL account to connect?  Make sure that the account has access.

What version of Windows are you running and are both machines in the same domain?

I would suggest still using a datetime column, but add another column that holds a code we call it DatePrecision.  The code tells us how much of the datetime data...

I wouldn't recommend it, but about the only way to do so is to shut SQL Server down (and it may require a hard shutdown at this point)  Once SQL is...

My preferred solution is to use an "archive table".  Your current table would, by definition not have a ThruDate.  When a row becomes inactive, DELETE it but use a DELETE...

There are really two issues here. 

Issue #1 - Natural vs. surrogate keys

Issue #2 - The proper way to generate surrogate keys.

As I have read Celko, he doesn't argue against...

I can't say that you don't have a problem, but the pageiolatch_ex just means that there is an exclusive latch placed on databaseID 13, fileID 1, and pageID 6938984.  And...

If I might borrow an idea from CJ Date...I'd add a 0th rule that would take precidence over the other 4 listed in the article.  Rule 0 states "Do not...

Peter could still use the view assuming his SELECT statment specified only those columns he has permission to access.

My comments weren't meant as a direct criticism of you or anyone else, except Microsoft.  I have been far too dependent on direct access to the system tables just like...

If your AD admins won't turn on delegation, then the only option you have is to use SQL accounts.  Now, you could map a Windows account to a SQL Server...

I never (k)new objectProperty even existed. BOL needs more "See Alos" links!

There is ServerProperty and DatabaseProperty as well.  I think the SQL Server community as a whole is far too...