4 tips to Boost Performance of Azure SQL Server
There are ways to greatly improve performance and power of your SQL Server databases in Azure. …
Performance
How NOT to use CROSS APPLY
OUTER APPLY(SELECT TOP 1) pattern is widespread, even baked into some frameworks like Entity Framework. But …
High Speed Storage in Azure?
Have you noticed that storage is a major bottleneck in all cloud providers (Azure, AWS, Google …
8 Myths about Storage Spaces
Introduction EVERYBODY should read this! Whether you have a big database that needs speed, or other …
My favourite indicator to Monitor SQL
Introduction There are thousands of indicators (Perfmon Counters, system views, …) one can track to monitor …
Plan Cache Tsunami
Your SQL Server may be slow for a peculiar reason: a run-away query that pushes-out all…
SQL Profiler for Developers and Testers
Introduction You developed a new TSQL code and want to check is there a slow SQL …
Collect Performance Data
Introduction Server is sometimes slow and you want to know why? Here is a lightweight performance …
How to save 250 000 EUR to your customer?
Recently, for the first time in my life I had a customer from India. A far …
Query with optional filters (catch-all query)
In almost every database we have a process that filters the same data with different filters.…
