Martin Bell UK SQL Server MVP : NEWSEQUENTIALID()

Guids and compression

MartinBell — Tue, 14 Jul 2009 08:00:00 GMT

Previously I looked at how GUIDs affected fragmentation, in this investigation I look at how they may affect fragmentions....(read more)

Returning GUID values to ADO.NET clients

MartinBell — Tue, 09 Jun 2009 07:44:00 GMT

My previous post showed how to return a database generated GUID as a stored procedure parameter, but if more than one GUID is generated what do you do?...(read more)

Wot no SCOPE_GUID() function??

MartinBell — Mon, 08 Jun 2009 14:23:00 GMT

When you have a database generated GUID value how do you find out what it is?...(read more)

GUID Fragmentation in SQL Server

MartinBell — Mon, 25 May 2009 11:47:00 GMT

With the advent of NEWSEQUENTIALID() fragmentation was reduced in clustered indexes, but what if you want to generate guids on the client? I look at the implications on fragmentation for different methods of guid generation...(read more)

GUID Ordering in SQL Server

MartinBell — Mon, 25 May 2009 10:13:00 GMT

When creating client-side guids to be stored in SQL Server things are not as simple as you expect......(read more)