Aaron Bertrand (@AaronBertrand) discusses examples where people expect SQL Server to perform tasks that really should be performed outside the scope of the database.
Continue Reading »Sep 222014
Sep 172014
Glenn Berry (@GlennAlanBerry) of SQLskills walks us through using Geekbench 3.2 from Primate Labs to test and compare CPU and memory performance on Windows database servers.
Continue Reading »Sep 122014
Paul White (@SQL_Kiwi) talks about coercing the optimizer into avoiding sorts, reminding us that sound indexing should still be our first line of attack.
Continue Reading »Sep 092014
Glenn Berry (@GlennAlanBerry) of SQLskills continues on database server hardware trends; today he previews some new processors that may save you some money on SQL Server 2014.
Continue Reading »Sep 032014
Paul White (@SQL_Kiwi) looks at a couple of cases where – even though T-SQL is supposed to be a declarative language, and any query that uses the same logic and same semantics should ultimately lead to the same plan and comparable performance – rewriting queries can change the plan in dramatic ways.
Continue Reading »