Archive

Posts Tagged ‘I/O’

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: , , ,

Database Splitting into different File-Groups


During the process of database optimization database administrators quite often face with optimization of low-level I/O system. As a result, they try to split a database between different Disks, RAID-s, LUN-s, etc., in order to scale I/O workload out. This process is known also as “Database Splitting” between several logical I/O units. Read more…