SQLpassion Workshops in Fall 2015

Time goes by, and today I’m very proud to announce all upcoming SQLpassion workshops for fall 2015: SQL Server Query Tuning Workshop October 5 – 9 in Utrecht/Netherlands November 23 – 27 in Stockholm/Sweden SQL Server Performance Tuning Workshop November 9 – 13 in Frankfurt/Germany November 30 – December 4 ...

Read more

How to randomize a result set in SQL Server

In today’s very short blog posting I want to show you a simple way to randomize a result set from SQL Server. Imagine you have a task table, and you want to hand out tasks in a random fashion to your employees. The easiest way to randomize the result set ...

Read more

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

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