The pain of Simple Parameterization in SQL Server

In today’s blog posting I want to talk about some specifics and side-effects of the Simple Parameterization mechanism used by SQL Server for ad-hoc SQL statements. First of all, Simple Parameterization will not happen if your SQL statements contain any of these: JOIN IN BULK INSERT UNION INTO DISTINCT TOP ...

Read more

How to find your worst performing SQL Server queries

I get asked this question over and over again: “I have a SQL Server that is performing badly. How can I find the worst performing queries?”. So in today’s blog posting I want to give you some information and guidance that will let you answer this question very easily. Ask ...

Read more

Introduction to Wait Statistics in SQL Server

In today’s blog posting I want to talk more about the Wait Statistics in SQL Server and how they can help you understand why your SQL Server is currently slow. For me the Wait Statistics are the most important concept in SQL Server when it comes to performance troubleshooting. Why ...

Read more

Learn about SQL Server 2014 Performance Improvements

On May 11th I will deliver a precon about SQL Server 2014 Performance Improvements at the SQLDay Poland conference in Wroclaw/Poland. I have already done intensive work on SQL Server 2014 and helped various customers around Europe to move their workload to SQL Server 2014. In this precon I will ...

Read more
SQLpassion

Copyright © 2015 by SQLpassion · Klaus Aschenbrenner · Imprint · Offerings · Academy · Contact · Go to Top