Archives for: "August 2011"
SQL Server Storage Engine under the hood: How SQL Server performs I/O
Aug 11th
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
Aug 5th
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 »