I have an idea that with SQL Server 2005 you could accomplish something like this using a database snapshot.

Has anybody actually tried that?

Don't get me started...

It took a lot of trial and error to extract Korean, Chinese, Thai and other characters stored in an Oracle 9i database with UTF-8 language setting into...

Am I the only one who's a little scared that over 20% of the people coming to this site and answering this question did not know that SP4 was released...

Quite disappointing that such a gross blunder slipped through.

On the other hand, it does not happen often, and, if we're honest, it may even add to the pleasure of trying...

Steve & Mark are both absolutely right!

The answer is WRONG!

Jon,

I agree with you that there should be no problem with your table.

The only reason for using calculated date(part)s would be if you need to use relative date ranges ie...

Maybe I'm totally off here, but if you add another datetime column defaulting to getutcdate() (instead of getdate()) you could solve your DST problems by using the change in time...

Thanks

When I look at the Memory tab of Server Properties in SQL Enterprise Manager, it looks as though I can allocate up to the full amount of memory on the...