December 2004 - Posts

Indexing Bit Columns

Published 20 December 4 8:0 PM | GregLow

In previous versions of SQL Server (prior to 2000), you were unable to index a column with a bit datatype ie: a true/false, yes/no, boolean value. In Books Online for SQL Server 2000, under the description of the bit data type, it still said: Remarks...

Static/Shared Methods

Published 11 December 4 12:29 PM | GregLow

I had been disappointed that when you use a CLR-based UDT, you didn't have access to shared/static methods, only instance methods. In the zVarchar example, I thought it would be good to be able to use the following: DECLARE @TextVar zVarchar SELECT @TextVar...

zVarchar example

Published 9 December 4 6:36 PM | GregLow

As mentioned in a previous entry, I decided to try to build a compressed text data type as an example of a UDT. So here it is. I built a datatype called zVarchar. To keep things as a reasonable demo, I didn't incorporate complex compression, just a simple...

Which OS Are You?

Published 9 December 4 6:26 PM | GregLow

Which OS are You? I presume I'm happy with XP....

Yukon Ascend

Published 7 December 4 8:35 PM | GregLow

In Sydney this week for the Yukon (SQL Server 2005) Ascend training. Covering a lot of the scalability and high-availability aspects of the product. I continue to be impressed by it. In the material on partitioning tables, it says you can't use more than...