Friday, July 11, 2008
Should I Use the sp_ Prefix for Procedure Names?
A little gem: SQL Server gives name-resolution preference to the master database for procedures that have the sp_ prefix. SQL Server looks for a compiled plan for the procedure associated with the master database and doesn't find it because, in this case, the sp_Select1 procedure exists in tempdb. SQL Server assumes the procedure isn't in cache (and thus must be recompiled) and acquires an exclusive compile lock on the stored procedure for a short time. However, the short time that the lock exists is enough to cause performance problems...
Using a prefix like usp_ should circumvent this quite nicely. Apart from that, having a naming convention (or nomenclature) in place is a great big ol' must have!
Tuesday, July 08, 2008
Antratek is selling .NET Micro Framework products
It's good to see that Antratek, a Dutch company, is now also selling a hardware platform with support for the .NET Micro Framework, the Embedded Master modules. The web site is in Dutch, translation is here. They're the first in the Benelux!
One of the nice key features (pdf) of the platform is a FAT file system using USB memory devices such as hard drives, as well as SD/MMC cards. Near unlimited data recording and storage, anyone?
It comes complete with Ethernet with full TCP/IP stack, 2 USB ports and the obligatory features like analog in/outputs, Serial Interfaces, Pulse Width Modulation (PWM) and so on. Prices start at EUR 199,96 for the Development Platform and EUR 63,96 for the Master Module.
I've bought stuff from Antratek before and it was a pleasure doing business with them.
Personal note: I am not affiliated with Antratek in any way.
Sunday, July 06, 2008
SharePoint Object Hierarchy: How it all fits together
Martin Kearn, a Microsoft Consultant from the UK, has drafted a picture of the overall Sharepoint hierarchy: How it all fits together. A very nice overview which certainly has its benefits.
Subscribe to Posts [Atom]