If you need to calculate age in days using SQL Server Transact-SQL, you have lots of options. When your age should be displayed in elapsed "days" for example, you might think that using the DAY attribute in DATEDIFF() would be the way to go. But you may want to use HOUR rather than DAY if your calculations must be accurate. Why? Because with DATEDIFF() using DAY, calculations are based on midnight boundaries. This means that your number of days will change if you are before or after the midnight boundary. For example, your actual time-span may have only been a couple of hours … [Read more...]
Macbook Pro 2013 Crashes-Restarts Nightly
My new Macbook Pro 2013 is great and most of the time it performs flawlessly. However, it recently began crashing nightly while in sleep mode. Each morning I see the report that it crashed overnight and restarted. I am working now isolate the cause. The only changes after this started occuring have been upgrading from a single Dell 24 inch monitor to dual Dell 27 inch monitors plus the addition of an Anker 9-port USB hub. I also have VMWare Fusion 6.0 running a Windows 7 VM (my development environment) but it has crashed with the VM suspended so its looking more like the hub or … [Read more...]