JC stories – Filip Eichenmann
No Comments
Přinášíme vám další rozhovor ze série JC stories. Tentokrát jsme se rozhodli vypustit příběh našeho Filipa, MS BI profík a těžký pohodář zároveň. 🙂 Jak se vůbec dostal k Business…
How to setup portable Tabular Editor
I had discussion lately with some friends working with SSAS Tabular. I was pointing out Tabular Editor of course as a best tool. But they were complaining they are not…
How to get Live Execution Plan using Extended Events
Introduction Have you ever found yourself in a situation where you were supposed to troubleshoot a long running expensive query that was hammering your SQL Server? I bet you wanted…
Extended Events: Detect Implicit Conversions that affect execution plans
Implicit Conversions – Introduction In this blog post, I’ll explain and demonstrate how to use Extended Events to detect Implicit Conversions that affect execution plans on your SQL Server instance.…
JC stories – Pavel Málek
S počátkem nového roku jsme se rozhodli vypustit do světa naše příběhy. Každý jsme si svou profesní cestu vyšlápli po svém a tak se s vámi o to rádi podělíme.…
Clustered Column Store Load Pitfalls – Magic number 64 when using WHERE IN clause
The Problem During our workload we have recognized a difference in performance for queries using IN clause. We are building query dynamically, so you can have a different length of…