RAID 1 (mirror) read speed as fast as RAID 0 (stripe)

To our big surprise, the new Intel Raid controller on the Motherboard Intel DX79TO (ver. AAG28805-401) with Intel X79 Express Chipset shows awesome read performance. The raid model is Intel Rapid Storage Technology enterprise 3.0 (Intel Rapid Storage enterprise – SATA Option ROM – 3.0.1.1370, 2003-2011), which in Microsoft Windows is reported as “Intel C600 …

Executing very large script on Microsoft SQL Server 2008 R2 fails

I was trying to execute very large .sql script in Microsoft SQL Server 2008 R2, that runs on Microsoft Windows Server 2008 R2. First I tried to copy/paste script into Microsoft SQL Server Management Studio. The server has plenty of memory about 5 GB RAM, and script file is about 150 MB in size and …