SQL Server Central

SQL Server Central Article about Query plans

A nice article describing the workflow when a query is submitted to SQL Server

PassMark Intel vs AMD CPU Benchmarks - High End

PassMark Intel vs AMD CPU Benchmarks - High End

Intel Core i7 X 995 @ 3.60GHz	10,795	NA
Intel Core i7 980X @ 3.33GHz	10,458	$999.99*
Intel Core i7 970 @ 3.20GHz	9,983	$879.99*
Intel Core i7-2600K @ 3.40GHz	9,870	NA
Intel Xeon W3680 @ 3.33GHz	9,577	$1,108.16*
Intel Xeon X5680 @ 3.33GHz	9,540	$1,689.99*
Intel Xeon X5670 @ 2.93GHz	9,151	$1,452.99*
Intel Core i7-2600 @ 3.40GHz	9,136	NA
Intel Xeon X5660 @ 2.80GHz	8,324	$1,229.99*
AMD Opteron 6176 SE	8,203	$1,386.00**
Intel Xeon X5650 @ 2.67GHz	8,146	$1,005.99*
Intel Xeon L5640 @ 2.27GHz	7,332	$1,016.99*
Intel Core i7 975 @ 3.33GHz	7,026	$1,044.49*
Intel Xeon W5590 @ 3.33GHz	6,960	$1,719.74*
Intel Core i7 965 @ 3.20GHz	6,810	$1,498.95*
Intel Xeon W3570 @ 3.20GHz	6,776	$1,105.48**
Intel Core i5-2500 @ 3.30GHz	6,715	NA
Intel Xeon W3580 @ 3.33GHz	6,714	$1,083.47**
Intel Core i7 880 @ 3.07GHz	6,691	$583.00**
Intel Core i7 960 @ 3.20GHz	6,671	$569.99*
Intel Core i7 875K @ 2.93GHz	6,475	$310.39*
Intel Xeon W5580 @ 3.20GHz	6,457	$1,723.39*
Intel Xeon W 570 @ 3.20GHz	6,402	NA
Intel Core i5-2400 @ 3.10GHz	6,364	NA
Intel Core i7 950 @ 3.07GHz	6,331	$294.98*
Intel Xeon X5667 @ 3.07GHz	6,294	$1,440.00**
Intel Xeon X3460 @ 2.80GHz	6,239	$348.99**
Intel Core i7 940 @ 2.93GHz	6,131	$599.99*
Intel Xeon X5677 @ 3.47GHz	6,119	$1,663.00**
Intel Core i7 870 @ 2.93GHz	6,072	$279.99*
AMD Phenom II X6 1090T	6,063	$229.00*
Intel Xeon W3565 @ 3.20GHz	6,030	$639.14**
Intel Xeon X3470 @ 2.93GHz	5,902	$349.99**
Intel Core i7 930 @ 2.80GHz	5,834	$311.91*
AMD Phenom II X6 1100T	5,738	$269.99*
AMD Phenom II X6 1075T	5,662	$199.99*
Intel Xeon W3550 @ 3.07GHz	5,642	$366.49**
Intel Core i7 920 @ 2.67GHz	5,557	$389.94*
Intel Core i7 860 @ 2.80GHz	5,556	$293.45*
Intel Core i7 S 870 @ 2.67GHz	5,554	NA
Intel Xeon X5560 @ 2.80GHz	5,484	$1,208.84*
Intel Xeon X3450 @ 2.67GHz	5,422	$269.89*
Intel Xeon X5570 @ 2.93GHz	5,418	$1,459.99*
Intel Xeon W3540 @ 2.93GHz	5,368	$630.74*
Intel Xeon X3440 @ 2.53GHz	5,290	$243.49*
Intel Xeon X5550 @ 2.67GHz	5,232	$1,004.13*
Intel Xeon X5492 @ 3.40GHz	5,223	$1,391.29*
Intel Xeon E5640 @ 2.67GHz	5,222	$792.39*
AMD Phenom II X6 1055T	5,181	$179.00*
AMD Opteron 6128	5,147	$275.99*
AMD Phenom II X6 1045T	5,121	NA
Intel Core2 Extreme X9750 @ 3.16GHz	5,022	NA
Intel Core2 Extreme X9770 @ 3.20GHz	4,993	$1,400.00**
Intel Xeon X5482 @ 3.20GHz	4,988	$1,279.00**
Intel Xeon W3530 @ 2.80GHz	4,960	$332.49*
Intel Xeon X5460 @ 3.16GHz	4,884	$1,205.84*
Intel Xeon E5630 @ 2.53GHz	4,867	$554.25*
Intel Xeon W3520 @ 2.67GHz	4,865	$303.99*
AMD Phenom II X6 1035T	4,800	NA
Intel Xeon E5530 @ 2.40GHz	4,716	$575.49*
Intel Xeon L3426 @ 1.87GHz	4,716	$310.99**
Intel Xeon X5472 @ 3.00GHz	4,711	$844.50**
Intel Xeon E5620 @ 2.40GHz	4,605	NA
Intel Core2 Quad Q9650 @ 3.00GHz	4,602	$329.99*
Intel Core2 Extreme X9650 @ 3.00GHz	4,593	$999.00**
Six-Core AMD Opteron 2431	4,586	$814.81**
Intel Xeon X5450 @ 3.00GHz	4,581	$1,009.95*
Intel Core i5 760 @ 2.80GHz	4,573	$199.99*
AMD Phenom II X4 970	4,530	$184.99*
Intel Xeon X3370 @ 3.00GHz	4,515	$353.49*
Intel Core i7 920XM @ 2.00GHz	4,420	$1,144.69**
Intel Xeon E5440 @ 2.83GHz	4,409	$798.95*
Intel Core i7 940XM @ 2.13GHz	4,408	NA
Intel Core2 Quad Q9550 @ 2.83GHz	4,366	$274.99*
Intel Xeon E5540 @ 2.53GHz	4,362	$806.75*
Intel Xeon E5520 @ 2.27GHz	4,340	$411.99*
AMD Phenom II X4 B97	4,323	NA
AMD Phenom II X4 965	4,265	$159.99*
AMD Phenom II X4 B60	4,230	NA
Intel Xeon X3350 @ 2.66GHz	4,228	$316.00**
Intel Core i5 750 @ 2.67GHz	4,224	$199.99*
Intel Xeon E5450 @ 3.00GHz	4,183	$1,058.95*
Intel Xeon X3360 @ 2.83GHz	4,168	$290.99*
Intel Core2 Quad Q9500 @ 2.83GHz	4,119	$183.00**
Intel Core2 Quad Q9505 @ 2.83GHz	4,115	$238.49*
Intel Xeon E5430 @ 2.66GHz	4,103	$537.99*
AMD Phenom II X4 40	4,070	NA
AMD Athlon II X4 555	4,069	NA
AMD Opteron 4170 HE	4,057	$183.99*
Intel Xeon X5365 @ 3.00GHz	4,038	$999.99*
Intel Core2 Quad Q9450 @ 2.66GHz	4,037	$398.95**
AMD Phenom II X4 B55	4,000	NA
Intel Core2 Extreme @ 2.40GHz	3,981	NA
AMD Phenom II X4 955	3,941	$144.99*
AMD Phenom II X4 B95	3,937	$225.00**
Intel Core2 Extreme Q6850 @ 3.00GHz	3,885	NA
Intel Xeon E5462 @ 2.80GHz	3,851	$498.95*
Intel Core2 Extreme X9775 @ 3.20GHz	3,810	$1,747.99*
Intel Core i7 840QM @ 1.87GHz	3,809	$579.99*
Intel Core2 Quad Q9400 @ 2.66GHz	3,807	$199.99**
Intel Core2 Extreme Q9300 @ 2.53GHz	3,785	NA
Intel Xeon X3230 @ 2.66GHz	3,777	$323.99**
AMD Phenom II X4 B93	3,754	NA
Intel Xeon X3330 @ 2.66GHz	3,723	$210.49*
AMD Athlon X4 640	3,693	NA
Intel Xeon E5420 @ 2.50GHz	3,691	$519.95*
AMD Phenom II X4 940	3,678	$109.99*
AMD Phenom II X4 B50	3,667	NA
Intel Core2 Quad Q8400 @ 2.66GHz	3,664	$169.99*
Intel Xeon E5507 @ 2.27GHz	3,649	$289.99**
Intel Xeon X3430 @ 2.40GHz	3,638	$213.99*
Intel Core2 Extreme Q6800 @ 2.93GHz	3,633	$1,125.00**
Intel Core i7 740QM @ 1.73GHz	3,614	$394.65*
AMD Phenom II X4 B45	3,604	NA
Intel Xeon X3320 @ 2.50GHz	3,601	$222.65*
Intel Core i5 680 @ 3.60GHz	3,600	$299.99*
AMD Phenom II X4 945	3,600	$135.99*
Intel Core2 Quad Q9300 @ 2.50GHz	3,574	$226.99*
Intel Core2 Quad Q8300 @ 2.50GHz	3,558	$149.99*
AMD Phenom II X4 840T	3,535	NA
AMD Phenom II X4 820	3,530	NA
Intel Core i7 820QM @ 1.73GHz	3,522	$546.00**
Intel Core i5 655K @ 3.20GHz	3,521	$199.99*
AMD Phenom II X4 830	3,521	NA
Intel Core2 Extreme @ 2.26GHz	3,518	NA
Intel Xeon X5355 @ 2.66GHz	3,518	$898.95**
AMD Phenom II X4 B40	3,510	NA
AMD Phenom II X4 B35	3,474	NA
AMD Athlon II X4 640	3,461	$99.99*
Intel Xeon E5410 @ 2.33GHz	3,448	$398.95*
Intel Xeon L5520 @ 2.27GHz	3,442	$568.99**
AMD Phenom II X4 925	3,424	$129.99*
Intel Core2 Quad Q9100 @ 2.26GHz	3,423	$385.89*
AMD Athlon II X4 645	3,411	$115.99*
Intel Xeon E5506 @ 2.13GHz	3,393	$239.49*
Intel Core2 Quad Q6700 @ 2.66GHz	3,376	$798.95**
AMD Phenom II X4 B25	3,353	NA
AMD Athlon II X4 635	3,334	$99.99*
Intel Core i3 560 @ 3.33GHz	3,300	$141.99*
AMD Phenom II X4 920	3,292	$119.99**
Intel Core i5 661 @ 3.33GHz	3,287	$209.99*
AMD Phenom II X4 910	3,285	$204.19**
Intel Core2 Quad Q8200 @ 2.33GHz	3,260	$229.95*
Intel Core i7 720QM @ 1.60GHz	3,259	NA
AMD Athlon II X4 630	3,248	$88.99*
AMD Phenom FX-5200 Quad-Core	3,239	NA
Quad-Core AMD Opteron 2378	3,189	$179.00**
Intel Core i5 670 @ 3.47GHz	3,171	$299.99*
Intel Core i5 650 @ 3.20GHz	3,113	$182.99*
Intel Core i5 660 @ 3.33GHz	3,107	$207.99*
AMD Phenom II X4 810	3,097	$115.99**
Intel Xeon E5504 @ 2.00GHz	3,075	$246.49*
Intel Xeon X3220 @ 2.40GHz	3,053	$349.95*
AMD Phenom 9950 Quad-Core	3,044	$156.99**
AMD Phenom II X4 805	3,030	$173.99**
Intel Core2 Quad Q9000 @ 2.00GHz	3,027	$390.35*
Intel Core i7 M 640 @ 2.80GHz	3,003	NA
Intel Core i3 550 @ 3.20GHz	3,001	$114.99*
AMD Phenom FX-5000 Quad-Core	2,981	NA
AMD Athlon II X4 620	2,980	$89.00**
AMD Phenom II X4 910e	2,978	$191.27*
Intel Core2 Quad Q6600 @ 2.40GHz	2,977	$398.95*
AMD Phenom 9850 Quad-Core	2,958	$69.99*
AMD Phenom II X4 900e	2,945	NA
AMD Phenom II X920 Quad-Core	2,937	NA
Intel Xeon E5345 @ 2.33GHz	2,902	$798.95**
Intel Xeon E5405 @ 2.00GHz	2,893	$254.29*
AMD Phenom II X4 05e	2,891	NA
AMD Phenom II X3 740	2,866	$88.99**
AMD Athlon II X4 615e	2,833	$154.12*
AMD Phenom II X4 905e	2,814	$192.48*
AMD Athlon II X3 450	2,809	$79.00*
Intel Core i3 540 @ 3.07GHz	2,803	$113.99*
AMD Phenom 9750 Quad-Core	2,779	$99.00*
Intel Core i5 520 @ 2.40GHz	2,777	NA
AMD Athlon II X4 610e	2,769	$146.86*
Intel Core i7 620M @ 2.67GHz	2,722	$332.00**
AMD Athlon II X3 445	2,711	$77.00*
Intel Core i3 530 @ 2.93GHz	2,705	$119.99*
Intel Xeon X5260 @ 3.33GHz	2,697	$851.00**
AMD Phenom II N950 Quad-Core	2,696	NA
Intel Core2 Duo E8600 @ 3.33GHz	2,657	$287.99*
Quad-Core AMD Opteron 1356	2,653	$211.80**
AMD Phenom 9650 Quad-Core	2,648	$110.00**
Quad-Core AMD Opteron 2380	2,640	$391.06**
AMD Athlon II X4 605e	2,639	$137.80*
Intel Xeon X3210 @ 2.13GHz	2,625	$209.99**
AMD Phenom 9600B Quad-Core	2,625	$147.19**
Quad-Core AMD Opteron 1352	2,620	$135.99**
Intel Core i5 M 460 @ 2.53GHz	2,602	NA
AMD Phenom II X3 720	2,593	$99.00**
AMD Athlon II X4 6400e	2,569	NA
AMD Athlon II X4 600e	2,567	$140.67*
AMD Phenom 9550 Quad-Core	2,542	$99.97**
AMD Athlon II X3 440	2,538	$83.99*
AMD Athlon II X3 435	2,536	$75.99**
AMD Phenom II N930 Quad-Core	2,514	NA
Intel Core i5 M 580 @ 2.67GHz	2,509	NA
Quad-Core AMD Opteron 1354	2,507	$309.97**
AMD Phenom II X4 B15e	2,491	NA
AMD Phenom II X3 B73	2,489	NA
Intel Core i5 450M @ 2.40GHz	2,484	NA
Intel Xeon E5335 @ 2.00GHz	2,477	$649.95**
Intel Core i5 540M @ 2.53GHz	2,460	$279.99*
AMD Phenom 9750B Quad-Core	2,458	NA
AMD Phenom 9600 Quad-Core	2,442	$95.00*
AMD Phenom 9450e Quad-Core	2,422	$85.00*
Intel Core2 Duo E8500 @ 3.16GHz	2,412	$191.05*
AMD Phenom II X3 B75	2,410	NA
AMD Athlon X3 440	2,382	$87.99**
Intel Core i5 M 560 @ 2.67GHz	2,372	$270.03*
Intel Xeon E3110 @ 3.00GHz	2,367	$181.49*
Intel Core i5 430M @ 2.27GHz	2,356	$79.00**
Intel Core i5 520M @ 2.40GHz	2,330	$234.99*
AMD Phenom 9350e Quad-Core	2,319	$194.99**
Intel Core2 Extreme X9100 @ 3.06GHz	2,307	$851.00**
AMD Athlon II X3 425	2,306	$60.99*
Intel Core2 Duo T9900 @ 3.06GHz	2,294	$530.00**
Intel Xeon E5320 @ 1.86GHz	2,292	$398.95**
AMD Phenom 9500 Quad-Core	2,290	$89.96**
AMD Phenom II X3 705e	2,278	$152.34**
Intel Xeon L5240 @ 3.00GHz	2,277	NA
Pentium Dual-Core E6700 @ 3.20GHz	2,267	NA
Intel Core2 Duo E8435 @ 3.06GHz	2,251	NA
Intel Core2 Duo E8400 @ 3.00GHz	2,245	$169.99*
AMD Phenom II X3 710	2,242	$90.99**
Intel Core2 T9550 @ 2.66GHz	2,235	NA
Intel Core i3 M 380 @ 2.53GHz	2,223	NA
Intel Core2 Duo E8700 @ 3.50GHz	2,212	NA
AMD Phenom II P940 Quad-Core	2,201	NA
Pentium Dual-Core E6600 @ 3.06GHz	2,199	$83.34*
Intel Core2 Duo T9800 @ 2.93GHz	2,198	$423.89**
Intel Core i3 370M @ 2.40GHz	2,196	NA
AMD Phenom 8850B Triple-Core	2,195	NA
AMD Athlon II X3 415e	2,194	$103.74*
Pentium Dual-Core E5700 @ 3.00GHz	2,192	$73.79**
AMD Phenom 9150e Quad-Core	2,168	NA
Pentium Dual-Core E6800 @ 3.33GHz	2,154	$98.65*
AMD Phenom X4 Quad-Core GP-9500	2,152	NA
Intel Core2 Duo P9700 @ 2.80GHz	2,133	NA
Intel Core i7 640LM @ 2.13GHz	2,125	$332.00**
AMD Phenom II N850 Triple-Core	2,112	NA
Intel Core2 Duo E7600 @ 3.06GHz	2,106	$138.30*
AMD Phenom X3 8750	2,082	$59.99**
Intel Pentium E6700 @ 3.20GHz	2,065	NA
Intel Core2 Duo E8335 @ 2.93GHz	2,062	NA
AMD Phenom II X2 560	2,060	$99.99*
Intel Xeon W3505 @ 2.53GHz	2,058	NA
Intel Core i3 350M @ 2.27GHz	2,054	NA
Intel Core2 Duo T9600 @ 2.80GHz	2,022	$339.99*
Pentium Dual-Core E6500 @ 2.93GHz	2,017	$78.08*
AMD Athlon II X2 265	2,017	$69.99*