In today’s blog posting I want to talk about a very controversial and complex topic in SQL Server: the ambiguity of the ORDER BY clause. Views and ORDER BY Let’s start with a very simple SELECT statement. — A very simple SELECT statement SELECT * FROM Person.Person ORDER BY LastName GO As you can see …
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 in Zurich/Switzerland Based on the …
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 is to perform an ORDER …
Today I have uploaded the 24th SQL Server Quickie to YouTube. This time I’m talking about Index Maintenance Operations in SQL Server. May the fourth be with you! -Klaus
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 GROUP BY HAVING COMPUTE Sub …
The pain of Simple Parameterization in SQL Server + read more
Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.
