How to get row count of a table in SQL Server quickly? Easist way, of course, is “SELECT COUNT(*) FROM <Table Name>”, most of you would say. However, there is another way, even easier and faster, that is “sp_spaceused <Table Name>”. It is shorter, and more importantly, it returns instantaneously when you try to get information of a huge table (millions of lines).
Experiment on a table with 2.8 million rows shows that time spent with COUNT(*) method is 3 seconds. Actual time taken is dependent on your hardware environment.
A good article explaining how it works: http://www.sqlservercentral.com/articles/T-SQL/67624/
This might be good news to users of Microsoft Team Foundation System. The cloud based system is in preview stage. Everyone can sign up and try it out. The trend of cloud computing, or “utility computing”, name I like more, is unstoppable.
The physical and physiological limitations of human athleticism are of great interest for both scientific and sociological reasons. An efficient method to test such limitations is having human participants compete in sports such as those included in the Olympic Game. Recently American swimmer Michael Phelps showed extraordinary athleticism in the Olympic Game, winning over 20 medals among which 16 are gold. This greatness has never been achieved before and therefore is highly likely due to factors other than training, which all previous athletes have undergone. This seemingly impossible achievement is reminiscent of the robust growth of the recently discovered bacteria GFAJ-1 in arsenic-rich media. Since the existence of arsenic in the DNA of GFAJ-1 has not been conclusively disproved, it is reasonable to assume, or at least to suspect, that the DNA of GFAJ-1 contains arsenic. Similarly, we propose that part of the DNA of Michael Phelps consists of arsenic, and that this element strongly contributed to his success. Although our theory has no evidence, it can nevertheless be ruled out. Our finding illustrates an exciting opportunity to enhance the athleticism among humans, although safety and ethic issues should be fully addressed prior to its worldwide application.
I hereby show my finger to the disgusting Nature magazine and all other defaming western media.
A very good article describing improved hardware-accelerated graphics in Windows 8 is published on Microsoft “Building Windows 8″ blog today. It is a long, but definitely not tedious technical post. Have a read and you will be excited, for one more reason, about Windows 8.
C++ AMP is coming with Visual Studio 2011. Here are information and good articles introducing it:
PDF: “C++ AMP : Language and Programming Model” – the specification
A list of articles: