Archive for the ‘I/O’ Category

NEWSEQUENTIALID() – is it a panacea or not?

GUIDs and Clustered Indexes

Uniqueness is a key factor when synchronizing data within distributed environment, SQL Server/Azure and multiple endpoints like Slates and Smartphones, etc.  With data simultaneously created and updated on servers and clients, ensuring rows are unique to avoid key collisions is critical.  As you know, each row is uniquely identified by its Primary Key. Read more…

Categories: I/O, News Tags: , , ,

FIBRE CHANNEL vs. iSCSI for SQL databases

April 10, 2011 1 comment

During last several years we saw a lot of battles around Storage Area Network technologies. The largest question there was which technology is better. If you know the answer, send me an email right now because I think it is impossible to have only one right answer thus different business requirements demand different characteristics from SAN. Read more…

Categories: Articles, I/O, News Tags: , ,