Blog – Joyful Craftsmen – The Business Intelligence Agency

Extended Events: Detect Implicit Conversions that affect execution plans

January 15, 2019

Data Warehouse, Database, Performance, SQL Server Central

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

January 8, 2019

No Comments

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

December 18, 2018

Column Store Index, Performance, SQL Server Central

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…

Watch out – new Database Level Health Detection can send your AOAG down!

November 20, 2018

Database, Errors, SQL Server Central

No Comments

Background In the past, Windows Server Failover Clustering (WSFC) cluster only monitored the health of your entire Always On Availability Groups (AO AG) primary replica. This meant that even when…

Není v JC pohovor jako “pohovor”

November 9, 2018

No Comments

Slávka je náš happiness manager s velkým “H”, který je s námi už od samého počátku. Nejen, že neustále pomáhá JC budovat, ale baví jí také poznávat nové lidi z…

Failed Installation of SQL Server Cumulative Updates Debugged

November 5, 2018

Errors, KB, SQL Server Central

No Comments

Background Our customer has recently experienced an issue during the installation of the latest cumulative updates in their SQL Server environment. Instances for one specific application ended in a crashed…

Extended Events: Detect Implicit Conversions that affect execution plans

JC stories – Pavel Málek

Clustered Column Store Load Pitfalls – Magic number 64 when using WHERE IN clause

Watch out – new Database Level Health Detection can send your AOAG down!

Není v JC pohovor jako “pohovor”

Failed Installation of SQL Server Cumulative Updates Debugged

About the Company

Partnership

Contacts