If you put a null in then you're saying the end date is unknown. However you're handling it in your code as though the NULL is effectively an arbitrary date...

I find it very useful to use NULLs in temporary tables during ETL.
Say for example I have a key, value table but the values might come from different...

Happy Independence day to our friends in the USA from sunny England.
Hopefully we'll get our independence from the EU at some point in the near future!
WE WON...

The article doesn't seem to render very well (at least when I'm viewing it in chrome). Perhaps you have some rogue HTML in it? At the moment it's hard to...

Bored is boring, there's always something to do!
You just have to find the things to work on that are going to give you and your company the best...

Excellent, very interesting article. Thanks very much.

Totally agree with Jeff. A good set of test data is priceless. It's also expensive to set it up. I've set up realistic test data for demo websites to the point...

I assume that this is in fact a case of saving energy in terms of energy used in cooling. So it's not a case of heat being wasted, but energy being saved...

I think this is only applicable to SQL Server 2008 R2 and above.
sys.dm_db_stats_properties
is not on my SQL Server 2008 instances

I like comments that tell you who wrote the code. Then you can find them and take appropriate action!

-- Andy Robertson 2018/06/08 I apologise for...

I disagree about working to live. I live to work, whether that's working for money or working on my house. I like to work hard and then when I sit...

Hi Steve, nice article, thanks. The Paul S. Randal article you linked to was also very interesting. What sort of frequency would you run CHECKDB on...