Archives for: "August 2011"

SQL Server Storage Engine under the hood: How SQL Server performs I/O

Posted on Aug 11, 2011 by in Reliability, Availability, Scalability
I will present this session on September 6th 2011 in Dublin Ireland at 6:30pm (None Irish audience is welcome too, I promise to finnish in time for a pint of Guinnes :-) How does SQL Server really access the data and log files on the disk? What's don… more »

Found prove that SQL Server is the Devils Engine - ERROR 666

Posted on Aug 5, 2011 by in Useless for most people...
Msg 666, Level 16, State 2, Line 1 The maximum system-generated unique value for a duplicate group was exceeded for index with partition ID 1234567890. Dropping and re-creating the index may resolve this; otherwise, use another clustering key. It… more »
1 comment »