Inserts with guids have become faster... (in SQL2005 that is)

Ok,

I am not a real fan of the GUID datatyoe in SQL server cause some people will create clustered indexes on them and then start to insert thousands of records, Next they will start complaining SQL isn't fast at all.
(Wich is about the same as putting a Caravan behind a Formula 1 car and then complain it won't do 300MPH on the straight.......)

But there is something new now in SQL 2005.

Have a read and see that insert performance has increased. -> http://www.lazydba.com/sql/1__18914.html

Since he is using NewSequetialID insert performance will be ok if it's a clustered index.....

This post is related to the old discussion about --> GUID is not always good ( a true Read the &*%^&%^& Manual story)

Published 04-28-2006 4:00 PM by Patrick Wellink
Filed under:

Comments

# re: Inserts with guids have become faster... (in SQL2005 that is)

Monday, May 01, 2006 5:04 AM by Jan Schreuder
Haha. That F1 car will do 300 km/h easy. It's the caravan that will be torn apart by the force of that F1 car ;-)

# re: Inserts with guids have become faster... (in SQL2005 that is)

Monday, May 01, 2006 11:32 AM by Patrick Wellink
Whelllllll....

I guess it will corner quite bad with the basis of the caravan dangeling behind it....

I don't know which is heavier ... caravan basis / F1 car...

Well let's give Top Gear a call.....