Glenn Berry (@GlennAlanBerry) details how you can evaluate the performance of your database servers using tools like Geekbench and CPU-Z.
Continue Reading »Aug 302013
Aug 282013
Paul White (@SQL_Kiwi) discusses the causes of parameter sniffing and goes into detail about the effectiveness of various workarounds.
Continue Reading »Aug 232013
Joe Sack (@josephsack) takes a first glimpse at the SQL Server 2014 enhancements to SELECT INTO: it can now perform in parallel with no code changes.
Continue Reading »Aug 202013
Paul White (@SQL_Kiwi) provides a detailed walk-through of an interesting incorrect results bug involving MERGE JOIN.
Continue Reading »Aug 142013
Aaron Bertrand (@AaronBertrand) of SQL Sentry discusses a case where assumptions can lead to a poorly-performing query and where exploring other options can pay off.
Continue Reading »Aug 072013
Glenn Berry (@GlennAlanBerry) of SQLskills.com talks about the 64GB memory limit in SQL Server 2012 Standard Edition and explains why Microsoft should reconsider this licensing strategy in light of forthcoming hardware advances.
Continue Reading »