Serialization and Ordering: An Integral Example

Some people peeked (and poked) under the covers and have been surprised at how SQL Server is twiddling their UDT bits during serialization.  Let’s peek together. Consider the following fragment of a UDT: [Microsoft.SqlServer.Server.SqlUserDefinedType(Format.Native)]public struct Simple : INullable{  private bool isNull;  public int val;   public static Simple FromInt(SqlInt32 i)  {    if (i.IsNull)      return Null;   …

5

Tutorial on SqlClr Computed Columns and Indexability

  Restrictive world of SqlClr computed columns and indexability   With Yukon entering the world of managed code, the world of indexes has just become a tad bit complicated but hey we are talking about smart/passionate Sql Server customers here – I am sure if we show them the right direction outlining the restrictions and…

1