November 2005 - Posts

• SQL Data Compare: Comparing Views

  Posted Tuesday, November 22, 2005 10:16 AM | 1 Comments
  
  

  In case you haven’t come across this before you can actually compare two views in SQL Data Compare. The only pre-requisite is that the view has an index defined on it. As an example lets create and compare an indexed view on pubs. First we must create Read More by James | 1 Comments | Comment on this post

• An interesting article about ASP.NET and SQL Server Performance

  Posted Tuesday, November 15, 2005 8:18 AM | 0 Comments
  
  

  While reading through the excellent http://blogs.msdn.com/ I noticed this post by Todd Carter talking abount ASP.NET and SQL Server Performance, in it he talks about compiler locks slowing down stored proceedure execution. Aparently Read More by James | 0 Comments | Comment on this post

• Breaking changes between Beta 2 and the RTM of .NET 2.0

  Posted Wednesday, November 09, 2005 10:21 AM | 0 Comments
  
  

  David C sent me an interesting link about the breaking changes between Beta 2 and the RTM, you can find the original summary at The Server Side.NET and Microsoft's in-depth document here [.doc] Read More by James | 0 Comments | Comment on this post

• Lock Free Datastructures

  Posted Wednesday, November 02, 2005 8:50 AM | 0 Comments
  
  

  Hidden away in the System.Threading namespace is the class Interlocked. This class provides atomic operations on variables. The method System.Threading.Interlocked.CompareExchange is the .NET equivalent to the Compare and Swap primitive. It basically Read More by James | 0 Comments | Comment on this post